Microsoft Excel: Advanced

VTeach Pte Ltd


Course introduction

Microsoft Excel Advanced course will equip you with hands-on knowledge of advanced data analysis, collaborate on workbooks with other users and automate workbook functionality.



Target Audience


This course is designed for students who already have foundational knowledge and skills in Microsoft Excel and who wish to begin taking advantage of some of the higher-level functionality in Microsoft Excel to analyze and present data.



Course Outline


Lesson 1: Conditional Formats and Templates

  • Apply Conditional Formatting
  • Templates
Lesson 2: Advanced Formulas, Functions and Conditional Formatting
  • Date Function
  • Truncate Text Data in Microsoft Excel with the LEFT Function
  • LEFT Function
  • RIGHT Function
  • Using Logical Functions
  • VLookup
  • HLookup
Lesson 3: Working with Range Names
  • Assign a Range Name
  • Edit a Range Name
  • Consolidating Data
Lesson 4: Organizing and Analyzing Datasets and Tables
  • Create and Modify Tables
  • Perform a Quick Sort
  • Custom Sort
  • Filter Data Apply Multiple Filters Advanced Filtering
  • Custom AutoFilter
  • Groups and Subtotals
Lesson 5: Visualizing Data with Charts
  • Types of Charts
  • Create a Chart
  • Chart Layout and Style
  • Create Sparklines Modify Sparklines
Lesson 6: Using Automated Analysis Tools
  • Use the Goal Seek Feature
  • Other Types of What-If Analysis
Lesson 7: Sharing and Collaborate Workbooks
  • Sharing Workbook
  • Understanding Track Changes
  • To Turn on Track Changes
  • Accept/Reject Changes
  • Turning off Track Changes
  • Add, Edit and Hide Comments Delete a Comment
Lesson 8: Protecting Workbooks
  • Document Inspector
  • Protect a Cell
  • Protect Workbook
Lesson 9: Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Create a PivotTable
  • Pivoting Data
  • To Add Filters
  • To Add Slicers PivotCharts
Lesson 10: Recording and Using Macro
  • Display the Developer Tab
  • Macro Security Setting
  • Record Macros
  • Edit Macros
  • Run Macros
  • Placing a Macro on the Quick Access Toolbar
  • A Quick Introduction to VBA Programming in Microsoft Excel



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


ACTA and Microsoft Certified

VTeach appoints experienced trainers who are knowledgeable on wide range of topics and skillful at teaching in the interesting and simple way. We invest a lot of time finding the right trainers and have fantastic team working for us.
Our trainers are all qualified who are ACTA and Microsoft Certified.



 

Top