Microsoft Excel 2016 - Level 2 Advanced

MDIS


Course introduction

Microsoft’s Excel programme has progressed from being just a simple online spreadsheet, with its uses covering a wide range – from simple data entry to complicated financial models and analysis. For those seeking to develop an advanced understanding of Microsoft’s Excel program, this course will definitely be of great use to you. After attending our advanced Excel course here in Singapore, participants will be able to use complex functions to model their data as well as generate a variety of reports.
 
If you are looking to attend this advanced Excel course, a good foundation in Excel is essential. Participants should be familiar with the program and be able to create basic Excel formulas. Having attended an essentials Excel course is definitely advantageous. A combination of lectures and demonstrations is applied to this course.



Course Benefits


Upon completion of this workshop, participants will be able to;

  • Learn how to use complex functions to model their data
  • Learn to generate a variety of answers and reports.



Target Audience


Those seeking to further their knowledge of Excel would benefit from this course. Those needing to create spreadsheet models & data analysis are especially encouraged to attend.



Course Outline


Module 1: Using Range Names

  • Assigning Names
  • Jumping to Named Ranges
  • Create Range Names from Headings
Module 2: Database/List Operations
  • Introduction to Excel Database
  • Using Tables
  • Removing Duplicates
  • Database Functions
  • Summarize Data using Subtotals
  • Grouping & Outlining Data
Module 3: Data Validation
  • Setting Data Validation
  • Displaying Input Message & Error Alert
  • Circling Invalid Data
Module 4: Data Consolidation
  • 3D Formulae: Using Multi-Dimension Worksheets & Workbooks
  • Consolidating Data
Module 5: Auditing Worksheets
  • Tracking Errors in Excel
  • Understanding Precedents & Dependencies
  • Viewing & Hiding Tracer arrows
  • Resolving Circular References<
  • Using the Watch Window
  • Evaluate Formulas
Module 6: Advanced Functions
  • Nesting of Functions
  • Lookups & Referencing
  • Combining Functions
Module 7: Data Analysis
  • What-If Analysis
  • Using Goal Seek
  • Solver
  • Using the Scenario Manager
Module 8: Pivot Tables
  • Understanding Pivot Tables
  • Building a Pivot Table
  • Pivot Table Formatting
  • Creating Pivot Charts
  • Printing a Pivot Report
  • Module 9: Collaborating
  • Sharing Workbooks
  • Merging Workbooks



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


Microsoft Certified Trainer

All of our Associate Trainers offer our high level of service therefore are subject to regular peer assessments and interview prior to joining our Institute. They must all be qualified and have relevant experience to an agreed level and are subjected to continual audit and evaluation. Strict internal assessment is implemented as an integral part of our quality control mechanism.



 

Top