Microsoft Excel: Advanced

VTeach Pte Ltd


Course introduction

New and Advanced features of Excel 2010/2013/2016. Participant will get in-depth knowledge to manage, filter and generate reports from Excel database. You will gain knowledge to use advanced functions of Excel and hence increase productivity, augment data in spreadsheets using templates, charts, graphics, and formulas and be work efficient.



Target Audience


For those who have attended Microsoft Excel Basic course or for users with fair knowledge in Microsoft Excel.



Course Outline


Custom & Conditional Formats

  • Create custom number format
  • Apply Conditional Formatting
  • Templates
Using Advanced Formulas & Functions
  • The Excel Date Function
  • Truncate Text Data in Excel with the LEFT Function
  • LEFT Function
  • RIGHT Function
  • Using Logical Functions
  • VLookup
  • HLookup

Working with Range Names
  • Assign a Range Name
  • Edit a Range Name
  • Consolidating Data
Working or Managing Tables
  • Create a Table
  • Delete a table without losing the data or table formatting
  • Create a Data List in Excel
  • Removing the Duplicate Record

Data Sorting and Filtering
  • Perform a Quick Sort
  • Perform a Custom Sort
  • Filter Data
  • Creating a Custom AutoFilter
  • Advanced Filter
Fetch result from your data
  • Create Subtotals
  • Using Automatic Outline
  • Grouping Data Manually
  • Data Validation Rule
Getting Master with Charts
  • Create a Chart
  • Change the Chart Type
  • Change the Chart Style
  • Change the Chart Location
  • Add Axis Titles
Pivot Tables
  • Insert a Pivot Table
  • Change Summary Calculation
  • Two-dimensional Pivot Table
  • Updating a PivotTable Report
  • Change Data Source
  • Moving PivotTable Report Fields
  • Using Expand and Collapse Buttons
  • Hiding PivotTable Report Items
  • Introducing Slicers
  • Formatting a Pivot Table Report
  • Formatting the values in the pivot table

Sharing Workbook
  • Shared a Workbook with other users
  • Tracking Changes
  • Accept/Reject Changes
  • Turn off change tracking for a Workbook
  • Resolve conflicting changes in a Shared Workbook
  • End the sharing of a Workbook
  • Stop sharing the Workbook

Worksheet Protection
  • Protect a Worksheet
  • Protect a Workbook
  • Protecting Cell with a Password
  • Protect your Excel Files
Hands-on with Macros
  • Display the Developer Tab
  • Record a macro
  • Changing Macro Security Setting
  • Creating a Macro Button
  • Assign a Macro
  • Running and Deleting a Macro
  • Run a Existing Macro
Course fee: $285.00 (Group Discount of 10% for 3 or more participants)



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