Microsoft Programmes

back-arrow Back to courses

Microsoft Excel for Business Analysis Online Workshop

Course Description: Microsoft Excel for Business Analysis, you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This Online Excel program is designed specifically for those who are new to spreadsheet and looking to perform a professional financial analysis using Excel.

4 Days (10 Hours)

Tuesday and Thursday


English / Sinhala

Study Method

Online (Via Online)

Course Fee

Rs 4000/=


E – Certificate (Hard copies on request)

Apply Now

Learning Outcomes

Upon successful completion of the course unit, the student should be able to perform the following tasks:

  • Calculating data using advanced formulas and functions;
  • troubleshooting and solving function errors;
  • assigning names to cells and ranges;
  • formatting values and creating custom number types
  • ; enforcing data validation.
  • Analyzing and presenting worksheet data using Charts,
  • Sparklines, Diagrams, PivotTables, PivotCharts, What-if Analysis,
  • Collaborating and importing data into Excel
  • Adding worksheet protection

Course Content

  • Excel Basics
  • Work with Cells and Worksheets
  • Calculate Your Data
  • Format your Workbook
  • Add Charts and Graphics
  • Collaborate with Others
  • Excel Formulas & Functions
  • IF /AND/ OR Conditions
  • Data Table Tools
  • PivotTables
  • Flash Fill
  • Auto Filter
  • Advanced Filter
  • Sort using Value, Color, Icon
  • Grouping & Subtotal
  • Conditional Formatting
  • Absolute/Relative Cell Reference
  • Data Validation
  • Data Management functions
  • Advanced Excel Analytics
  • Worksheet Protection
  • Power Pivots
  • Sparkline
  • Goal seek

Call for Registration

070 190 7383 / 076 190 7383

eXelient Higher Education

(+94) 76 690 0009
(+94) 71 690 0009

Reg No: BB 10132





AC 105014022870
Sampath Bank

Pay Online

Social Media