Gtec
Gtec education course thumbnail

Certificate Course in Advanced Excel – GROUND UP

Course category: Certificate Course

Course Duration: 2 Months

OBJECTIVE: -   

This is an advanced course which will helps you to give the basics of excel and covers all the enriched features in Microsoft Excel, including macros, pivot table, audit & analyze worksheets, use advance formulas & functions, work with multiple worksheets and workbooks etc. which in turn increases productivity, improves efficiency by streaming the workflow thus becomes a major asset for professional employees.

COURSE OUTLINE

 

Module 1

  • Introduction to Excel
  • Essential worksheet operation
  • Working with Cells and Ranges
  • worksheet formatting
  • Working with Formulas and Functions
  • Data Sorting and Filtering
  • Charts and Tables
  • Working with Data
  • VBA Macro

G-TEC Courses