Application Deadline
June 30th, 2020.


Microsoft Excel - Essentials for Business Analysis I

Course Outline


Microsoft Excel is one of the most universal pieces of software used in everyday operations of almost all big and small companies across the world. Completing this course and becoming proficient in MS Excel will add a highly valuable skill to your profile, which can lead to better opportunities and higher income. It will position you ahead of others at a time when jobs demanding digital skills are growing much faster than non-digital jobs. Thousands of job advertisements requiring Excel skills are posted every month in Pakistan. With the launch of ‘Digital Pakistan’ initiative, this number is only likely to increase.

This course has been designed keeping in mind two kinds of participants – those who have very little functional knowledge of Excel, and those who use Excel regularly with some working knowledge but wish to enhance their skills. The course will help you learn a variety of skills and techniques in these few weeks that will become a standard component of your everyday use of Excel. You will also get enough practice to be able to independently learn any other Excel functionality you might need in future.

Upon completing the course, learners would have acquired the skills to extract meaningful information from data, and to present it using smart visualizations, in order to make sense out of it. The course will take you from basic operations to some of the more advanced functionality of Excel. All along, the techniques and best practices will be introduced with easy to understand hands-on exercises, developing your data analysis skills.

Course Outline:

  • Introduction to spreadsheets
    • Interface – Tabs and Ribbons
    • Navigation
  • Entering, Editing and Formatting Data
    • Fonts, Fills and Alignment
    • Moving, Finding and Replacing a Value
    • Paste Special
  • Basic Formatting
    • Formatting Numbers and Dates
    • Format Painter
  • Filtering and Sorting Data
    • Filtering Data and Advanced Filtering
    • Sorting Data and Multiple Level Sorting
  • Performing Calculations
    • Creating and Copying Formulas
    • Using Excel’s Built-in Formulas
    • Relative and Absolute Referencing
  • Common Statistical Functions
    • SUM, COUNT, AVERAGE
    • MODE, MEDIAN
    • MAX, MIN
  • Common Text Functions
    • LEN, TRIM, CONCATENATE
    • LEFT, RIGHT, MID
    • LOWER, UPPER, PROPER
    • FIND, SEARCH, SUBSTITUTE
  • Common Logical Functions and Summarizing Data
    • IF, IFERROR, Nested IFs
    • AND, OR, NOT
    • SUMIF, SUMIFS
    • COUNTIF, COUNTIFS
    • AVERAGEIF, AVERAGEIFS
  • Common Lookup Functions
    • VLOOKUP (Approximate and Exact Matches)
    • INDEX, MATCH
  • Formula Auditing
    • Tracing Precedents and Dependents
    • Evaluating Formulas and Error Checking
  • Conditional Formatting and Sparklines to spot trends and patterns in data
    • Highlighting Cells and Top/Bottom Rules
    • Data Bars and Color Scales
    • Sparklines – mini charts placed in single cells to show trends in rows of data
  • PivotTables and PivotCharts for data exploration and visualization
    • Choosing Fields and Value Field Settings
    • Break-up Analysis and Cross Tabulation
    • Visualizing Data with PivotCharts
    • Working with Time Series Data
    • Grouping Fields
    • Combo Charts
    • Slicers

Instructor Profile


Ahmad Bilal Aslam is a Teaching Fellow at ITU’s Faculty of Business and Management. He teaches courses in quantitative methods, business analytics, problem solving and decision making to graduate (Executive MBA) and undergraduate (BS in Management & Technology) students.

Bilal holds a master’s degree in Business Analytics from Imperial College London (programme ranked No. 2 in the world), where he studied as a Commonwealth Scholar and graduated with a Distinction. Prior to this, he completed his Bachelors in Accounting & Finance with Computer Science from LUMS. In addition, he has worked in data analytics and digital marketing roles in the industry for more than three years. He is also a Microsoft certified Excel expert, and has been providing in-house Excel trainings during his time in the corporate sector.

Bilal is particularly gifted with strong quantitative and analytical skills, which stem from his proficiency in mathematics. He has got top positions in Pakistan in multiple mathematics competitions, and has been a member of Pakistan national team for International Mathematical Olympiads. His research interests are in the applications of data analytics in retail, digital marketing and sports to improve decision making and performance.