Introduction
This Intermediate Microsoft Excel training class is designed for students to gain the skills necessary to work with formulas, functions, worksheets, tables and data analysis..
MOF 003 – Microsoft Excel (Beginner to Intermediate), 11 & 12 September 2023
MOF 003 – Microsoft Excel (Beginner to Intermediate), 11 & 12 September 2023
RM 1,990.00
Objective
- Upon Completion Of This Program, Participants Should Be Able To:
- Create a spreadsheet with simple formatting
- Create basic formulas – Addition, Subtraction, Multiplication and Division
- Use basic functions – AutoSum, Count, Max, Min and Average functions.
- Create a basic chart
- Print a spreadsheet with headers and footers added
- Customize formulas
- Managing data using Excel Table
- Visualize trend by using tiny chart (Sparklines)
Methodology
- This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise
2 Days Training Content
Day One
- Organizing Worksheet
- Working with Multiple Worksheets
- Finding and Replacing Data
- Using Quick Styles
- Removing Style from a Table
- Defining a Title
- Using the Total Row Command
- Removing a Duplicates
- Using Slicer to View Data Table
- Converting a Table into a Range
- Apply a Specific Conditional Format
- Use the Rules Manager to Apply Conditional Formats
- Types of Data Validation
- Allow Only Specific Values to Be Entered in Cells
Day Two
- Sort Data on a Single Criterion
- Sort Data on Multiple Criteria
- Sort Data Using Cell Attributes
- Custom Sort
- Using Autofilter
- Creating a Custom AutoFilter
- Filtering Data Using Cell Attributes
- Building Charts
- Formatting a Chart with a Quick Style
- Formatting the Parts of a Chart Manually
- Modifying a Chart
- Using New Quick Analysis Tools
- Use Logical Functions – IF , IFS
- Use Date Function – TODAY, NOW,DATE, DATEDIF
- Use Math and Trigo Functions – SUMIF, SUMIFS
- Trace Cells
- Watch and Evaluate Formulas