Microsoft Excel: Advanced

Course Dates:

26 & 27 Oct 2017
20 & 21 Nov 2017
18 & 19 Dec 2017

Course Specifications

Course length: 2 days (9.00am to 5.00pm)

Course Fees: S$285.00 (Group Discount of 10% for 3 or more participants)

Course Objective:

New and Advanced features of Excel 2010/2013. 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 Content

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 

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list

WU EDGE - Western Union Business Solutions


Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Free One-Time Refresher
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479

Email: admin@vteach.com.sg

Privacy Policy