Name: Microsoft Excel 2016: Intermediate by NTUC LearningHub
Telephone: 6336 5482

Udemy courses up to 50% off

NTUC LearningHub Course Code: MSE16I

SSG SkillsConnect Reference Number / Course ID to Claim SkillsFuture Credit: CRS-N-0033295

2 Days / 14 Hours

FORMAT WORKSHEETS
- APPLY CONDITIONAL FORMATTING
  - Applying Conditional Formatting
  - Remove Conditional Formatting
- APPLY AND REMOVE CELL STYLES
  - Apply a Cell Style
  - Remove a Cell Style
- CREATE AND MODIFY CELL STYLES
  - Create a New Style
  - Modify a Style

BUILD FORMULAS
- ABSOLUTE AND RELATIVE REFERENCES
  - Relative References
  - Absolute References
- CELL AND RANGE NAMES
  - Create a Name
  - Use a Cell or Range Name in a Formula
  - Navigate to a Named Range
  - Edit and Delete Cell or Range Names
- LOGICAL FUNCTIONS
  - IF Function
- Mathematical and Trig Functions
  - Sumif
- Statistically Functions
  - Countif
  - Averageif
- TEXT FUNCTIONS
  - Concatenate Text
  - Left
  - Right
  - Len
- FORMULA ERRORS
  - #NAME? Error
  - #DIV/0 Error

VIEW AND MANAGE WORKSHEETS
- VIEW WORKBOOKS
  - Change Workbook Views
  - Use Zoom
  - Create a Custom View
  - Apply a Custom View
- FREEZE ROWS AND COLUMNS
  - Freeze Rows and Columns
  - Unfreeze Panes
- SPLIT THE WORKSHEET WINDOW
  - Add a Worksheet Window Split
  - Remove a Worksheet Window Split

DATA AND TABLES
- SORT DATA
  - Sort by One Column
  - Sort by Multiple Columns
- TABLES
  - Create a Table
  - Apply a Table Style
  - Convert to a Range
- ADD AND REMOVE TABLE DATA
  - Add Table Rows and Columns
  - Remove Table Rows and Columns
- REMOVE DUPLICATES
- TOTAL ROWS
  - Add a Total Row
  - Change Calculations
- SLICERS
  - Insert a Slicer
  - Filter with a Slicer
  - Clear and Remove a Slicer
- FILTER DATA
  - Filter
  - Clear a Filter
- DATA VALIDATION
  - Create a Validation Rule
  - Add an Input Message
  - Add an Error Message
- IMPORT DATA
- EXPORT DATA

CHARTS
- CREATE CHARTS
  - Create a Chart
  - Create a Recommended Chart
- MOVE AND RESIZE CHART
  - Move a Chart
  - Resize a Chart
- DELETE A CHART
- CHANGE CHART TYPE
- LAYOUT AND STYLE
  - Apply a Chart Layout
  - Apply a Chart Style
- CHART COLORS
- TITLES AND LEGENDS
  - Change the Chart Title
  - Add Axis Titles
  - Position the Chart Legend
- GRIDLINES
  - Show Chart Gridlines
- LABELS AND DATA TABLES
  - Add Data Labels
  - Display a Data Table
- DATA SERIES
  - Change the Color of a Data Series
- MODIFY CHART DATA
  - Add a Data Series
  - Rename a Data Series
  - Reorder a Data Series
- FILTER CHARTS
  - Filter a Chart
  - Remove a Filter
- SPARKLINES
- CHART TEMPLATES
  - Save a Chart as a Template
  - Create a New Chart from a Template

Microsoft Excel 2016: Intermediate by NTUC LearningHub

You May Also Be Interested In