Duration: 2 days / 15 hours
Time: 9am to 5.30pm
Course Code: CRS-N-0045462
TPGateway Course Code: TGS-2020501691
Funding available for this course :
SkillsFuture Credit | PSEA | UTAP | Broad based Funding |
What Will Be Taught For This Microsoft Excel 2016 Advanced Course?
In this course, the participant will be introduced to the more advanced features of Microsoft Excel 2016. The participant will learn how to manage, filter and generate reports from Excel data. The course also shows the participant how to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek. Additionally, participants will learn how to create macros to automate some repetitive tasks, as well as how to protect worksheets and workbooks. At the end of the course, the participant will be able to demonstrate the ability to manage and analyze data efficiently with Microsoft Excel 2016.
- Applying Conditional Formats
- Changing a Conditional Format
- Adding a Conditional Format
- Creating a Custom Conditional Format
- Using Data Bars
- Deleting a Conditional Format
- Creating a Custom Number Format
- Labs
- Copying Worksheets
- Hiding Columns and Rows
- Unhiding Columns and Rows
- Saving a Workbook as a Template
- Using a Template
- Editing a Template
- Inserting a New Worksheet
- Hiding/Unhiding a Worksheet
- Deleting a Template
- Finding Online Templates
- Labs
- Creating Subtotals in a List
- Removing Subtotals from a List
- Sorting Data by Multiple Levels
- Using Custom Sort
- Using Data Validation
- Validating Data using a List
- Creating a Custom Error Message
- Removing Data Validation
- Labs
- Creating a Criteria Range
- Using a Criteria Range
- Showing All Records
- Using an Advanced And Condition
- Using an Advanced Or Condition
- Copying Filtered Records
- Using Database Functions
- Finding Unique Records
- Removing Duplicates from a Table
- Labs
- Formatting an Axis
- Changing the Axis Scaling
- Formatting the Data Series
- Adding Data from Different Worksheets
- Using a Secondary Axis
- Changing Data Series Chart Types
- Changing Source Data Range
- Labs
- Creating a PivotTable Report
- Adding PivotTable Report Fields
- Selecting a Page Field Item
- Refreshing a PivotTable Report
- Changing the Summary Function
- Adding New Fields to a PivotTable Report
- Moving PivotTable Report Fields
- Hiding/Unhiding PivotTable Report Items
- Deleting PivotTable Report Fields
- Creating a Page Field Report
- Formatting a PivotTable Report
- Creating a PivotChart Report
- Grouping Data Manually
- Labs - Creating/Revising PivotTables
- Jumping to a Named Range
- Assigning Names
- Using Range Names in Formulas
- Creating Range Names from Headings
- Applying Range Names
- Deleting Range Names
- Using Range Names in 3-D Formulas
- Displaying/Removing Dependent Arrows
- Displaying/Removing Precedent Arrows
- Showing Formulas
- Labs
- Importing Data from Text Files
- Changing External Data Range Properties
- Removing the Query Definition
- Creating a Hyperlink
- Editing a Hyperlink
- Labs
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the IF Function
- Using Nested IF Functions
- Using the ISERROR Function
- Using an AND Condition with IF
- Using an OR Condition with IF
- Using the ROUND Function
- Using COUNTIF Function
- Using RANK Function
- Using Financial Functions
- Using Text Functions
- Labs
- Creating a Scenario
- Displaying a Scenario
- Editing a Scenario
- Creating a Scenario Summary Report
- Working with Data Tables
- Placing Formulas in Data Tables
- Creating a One-Variable Table
- Creating a Two-Variable Table
- Labs
- Unlocking Cells in a Worksheet
- Protecting a Worksheet
- Unprotecting a Worksheet
- Creating Allow-Editing Ranges
- Deleting Allow-Editing Ranges
- Protecting Workbook Windows
- Unprotecting Workbook Windows
- Assigning a Password
- Opening a Password-protected File
- Removing a Password
- Labs - Using Worksheet Protection
- Saving a Shared Workbook
- Viewing Users Sharing a Workbook
- Viewing Shared Workbook Changes
- Changing the Update Frequency
- Highlighting Changes
- Managing Conflicting Changes
- Resolving Conflicting Changes
- Setting Change History Options
- Adding a History Worksheet
- Reviewing Tracked Changes
- Merging Shared Workbook Files
- Labs
- Recording a Macro
- Saving a Macro-Enabled Workbook
- Running a Macro
- Assigning a Shortcut Key
- Using a Shortcut Key
- Deleting a Macro
- Adding a Macro to Quick Access Toolbar
- Deleting a Macro Button from QAT
- Labs
- Inserting Comments
- Viewing Comments
- Reviewing Comments
- Printing Comments
- Labs
Who Should Attend This Advanced Microsoft Excel Course Training?
Highly recommended for any individuals with at least basic or intermediate grasp of Microsoft Office Excel concepts and interested in learning more advanced functions for more challenging work.
Pre-requisite
An understanding of MS Excel 2016 basic and intermediate level is required.
w/o GST | w GST | |
Course Fee | $550 | $588.50 |
CANCELLATION/POSTPONEMENT / CHANGE of VENUE
- 2 to 4 weeks’ written notice from start date of training - 50% of course fee for cancellation
- Less than 2 weeks’ written notice from start date of training - 100% of course fees for postponement or cancellation
- ST Electronics (e-Services) Pte Ltd reserves the right to cancel or postpone any course or change the venue due to unforeseen circumstances.
Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.
Please ensure that you have read our Terms and Conditions before submitting the enrolment form.
Please click on the course date to enrol.
- CL: Classroom Learning
- VILT: Virtual Instructor-Led Training
- GTR: Guaranteed To Run
- Sat: Saturday
- Wkn: Weekend