Beginner: Microsoft Excel Basic course will equip you with hands-on knowledge to create and develop Microsoft Excel worksheets, perform simple calculations and to create a simple chart. The course provides all necessary foundational skills on this topic.
MOF 003 – Microsoft Excel (Beginner) 20 November 2023
MOF 003 – Microsoft Excel (Beginner) 20 November 2023
RM 700.00
Objective
Methodology
- Work with functions.
- Work with lists.
- Analyze data.
- Visualize data with charts.
- Visualize Data with Charts
- Create Advanced Charts
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Using date & time function
- Create pivot table and use pivot function
1 Day Training Content
Day One (9am-1pm)
- Navigate the Microsoft Excel User Interface
- Use Microsoft Excel Commands
- Create and Save a Basic Workbook
- Enter Cell Data
- Use Microsoft Excel Help
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas and Functions
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Search for and Replace Data
Day One (2pm-5pm)
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Styles and Themes
- Apply Basic Conditional Formatting
- Create and Use Templates
- Manage Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
About Instructors
Sazali
- Microsoft Office Training
- Microsoft Word
- Microsoft Excel
- Microsoft Powerpoint