Advanced Excel 2016 Training
Course

Advanced Excel 2016 Training

Cutting Edge eLearning Solutions
Updated Feb 18, 2021

This Online course covers working with Microsoft Excel spreadsheet software to create, edit and save worksheets and workbooks. Completing this Microsoft Excel course will improve your workplace skill set.

Our online programme is well designed that you feel same as you are in the classroom. This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. Effective support service, and study materials including step by step guided tutorial videos build your confidence to study well and guide you to secure your qualification.

MICROSOFT EXCEL 2016 – ADVANCE FORMULAS & FUNCTIONS

  • Introduction to Excel 2016 Advance Formula and Functions
  • Values and Formulas
  • Operations in Formulas
  • IF, AND, OR and NOT Functions
  • VLOOKUP and HLOOKUP
  • Tabulating Data and Multiple Criteria
  • Median, Mode and Ranking Data
  • Date, Time and Functions
  • Array Formulas and Frequency Functions
  • OFFSET and INDIRECT Function
  • Different TEXT & Information Functions

MICROSOFT EXCEL 2016 – ADVANCE FORMATING AND TECHNIQUES

  • Introduction to Excel Advance Formatting & Techniques
  • Adjust Fonts, Font Sizes & Font Colours
  • Adjust Cells and Tools
  • Work with Formulas & Tables
  • Adjust Row, Columns and Sheets
  • Different Formatting Styles and Set up Data for Outlines
  • Formatting Picture Styles
  • Formatting Techniques – Restore Missing Data in a Column
;