Microsoft Excel Course

Microsoft Excel is one of the most widely used application for Digital Data Management. It is used for Data calculations, analysis and Visualisation through its features like rich library of functions

Description


Key takeaways

  • Equip the trainees with Basic MS Excel skills like: Microsoft Excel environment
  • Editing and formatting of worksheets to present data professionally
  • basic calculations using formulas and functions
  • data visualization
  • Page setup for printing
  • etc
Targeted Audience

Accountants, Administrators, Logistics Managers, Inventory Managers, Data Analysts, Finance Managers

Duration

Basic MS Excel Course: 1 Day (7 Hours) Advanced MS Excel Course: 1 Day (7 Hours)

Mode of delivery

Virtual

Course Content

Basic Excel Course: This Course is to Equip the trainees with Basic MS Excel skills like:

1. Familiarizing with Microsoft Excel environment

2. Creating Basic Excel datasheet

3. Editing and formatting of worksheets to present data professionally

4. Performing basic calculations using formulas and functions

5. Visually presenting data using charts

6. Page setup & printing

 

Advanced MS Excel Course: This Course is to Equip the trainees with Advanced MS Excel skills like:

1. Range Names in Formulas & Functions

2. Advanced Formulas and Functions

3. Data Analysis

4. Pivot Tables and Charts

5. Automating tasks using Macros