Farzana Ferdous, a graduate of Materials & Metallurgical Engineering from Bangladesh University of Engineering & Technology, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, she exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel, Data Analysis, Charts & Dashboards, Power Query, and Excel VBA.
Designation
Excel & VBA Content Developer at ExcelDemy in SOFTEKO.
Method 1: Employee Database & Basic Salary Structure
The figure below shows basic salary structure of a company, and we want to calculate the net salary ...
Method 1 – Using the ‘Text to Columns’ Option to Split Addresses
The below dataset shows an address 986 Riverview Ct-Xenia, OH, 45385’ in the B5 cell from ...