Gtec
Gtec education course thumbnail

Certificate Course In Advance Excel

Course category: Certificate Course

Course Duration: 1 Month

OBJECTIVE:

This course is outlined in a way that it covers majority of enriched features in Microsoft Excel 2016, including Macros, Pivot tables, Audit and Analyze worksheets, Use Advance Formulas and Functions, work with multiple Worksheets and Workbooks etc., which in turn increases productivity, improves efficiency by streamlining the workflow thus becomes a major asset for professional employees. 

COURSE OUTLINE

Module 1

  • Introduction to Excel
  • Working with formulas and functions
  • Data sorting and filtering
  • Auditing
  • Charts and tables
  • Working with data
  • What if analysis
  • Exporting importing and reviewing a worksheet
  • VBA Macro

G-TEC Courses