fbpx

Microsoft Excel 2016/2019 Level 1, 2 & 3

Level 1 (Intro)

Course Objectives

• Identify basic worksheet and workbook concepts and terms
• Enter & edit data
• Modify the worksheet
• Use functions to calculate and return values
• Format cells to enhance the appearance of your worksheet
• Use drawing features and other enhancements
• Change the page set-up to define how the printed worksheet appears.

Duration: 1 Day

Level 2 (Intermediate)

Course Objectives

  • Using multiple worksheets, workbooks and workspaces
  • Working with Financial functions
  • Use advanced formatting techniques
  • Using the Auditing Tools to track information
  • Using charts to display financial data
  • Use Templates.

Duration: 1 Day

Level 3 (Advance)

Course Objectives

  • Creating, Maintaining, Filtering and using Subtotals in a List
  • Recording, Assigning and Using Macros
  • Creating and Using User-Defined Functions
  • Performing “What If” Analyses
  • Working with Scenarios
  • Querying a Database
  • Importing and Exporting Files and Data
  • Protecting Data
  • Pivot Tables, Reports and Charts.
  • Other Advanced Business Analysis Tools

Duration: 2 Days

Who Should Attend?

Course Details

  • Course Title: Microsoft Excel 2016/2019 Level 1, 2 & 3
  • Class Schedule: TBA
  • Time: 9am to 5pm
  • Duration (Days): 1-2 days
  • Certification Body: Microsoft

Training Date

  • TBA

Course Fee

  • Level 1 (Intro): RM250
  • Level 2 (Intermediate): RM250
  • Level 3 (Advance) RM500