What's In It For Me
- Data analysis using Microsoft Excel Features
- Extract data using Lookup functions
- Repeat task using Record Macros
Course Overview
NTUC LearningHub Course Code: MSE16A
SSG SkillsConnect Reference Number / Course ID to Claim SkillsFuture Credit: CRS-N-0033298
Course Duration
2 Days / 14 Hours
Course Outline
- FORMAT WORKSHEETS
- APPLY CONDITIONAL FORMATTING
- Advanced Conditional Formatting Rules
- Create a Custom Number Format
- APPLY CONDITIONAL FORMATTING
- BUILD FORMULAS
- LOOKUP FUNCTIONS
- VLOOKUP
- LOOKUP
- Date & Time Functions
- Math & Trig Functions
- Sumifs
- Statistical Functions
- CountIfs
- AverageIfs
- LOOKUP FUNCTIONS
- COLLABORATE WITH EXCEL
- CELL COMMENTS
- Add a Comment
- View a Comment
- Edit a Comment
- Delete a Comment
- SHARE WORKBOOKS
- Share a Workbook
- Stop Sharing a Workbook
- TRACK CHANGES
- Turn on Track Changes
- Track Changes
- Review Changes
- Save a Change History
- PROTECT A WORKSHEET
- Make Cells Editable
- Hiding Formulas
- Protect a Worksheet
- PASSWORD PROTECTION
- SAVE AS WEB PAGES
- CELL COMMENTS
- PIVOT TABLES
- CREATE PIVOTTABLES
- USE MULTIPLE PIVOTTABLE FIELDS
- Add an Additional Field Value
- Expand or Collapse a Heading
- CHANGE A PIVOTTABLES CALCULATION
- FILTER PIVOTTABLES
- Add a Filter Field
- Clear and Remove a Filter
- GROUP VALUES
- Group PivotTable Values
- Ungroup PivotTable Values
- TIMELINES
- Insert a Timeline
- Clear or Remove a Timeline
- PIVOTTABLE LAYOUT
- REFRESH A PIVOTTABLE
- Manually Update a PivotTable
- Automatically Update a PivotTable
- FORMAT A PIVOTTABLE
- Use Style Options
- Apply a Built-in Style
- PIVOT CHARTS
- Insert a PivotChart
- Modify a PivotChart
- Analyzing Data
- Creating Scenarios
- Creating a Scenario Report
- Grouping and Outlining Data
- Using Subtotals
- Working with Macros
- Recording a Macro
- Playing and Deleting a Macro
- Adding a Macro to the Quick Access Toolbar
- Customizing Excel
- Customizing the Ribbon
- Customizing the Quick Access Toolbar
- Changing Excels Default Options
- Creating a Custom Number Format
Categories
More Information
- (Local Institution) NTUC LearningHub
Add a review