MOF 003 – Microsoft Excel (Beginner & Intermediate) 15 August 2023

Name: MOF 003 - Microsoft Excel (Beginner &amp; Intermediate) 15 August 2023
SKU: 10461
Availability: InStock

Teachers

Sazali

Category:

IT (VL) / Virtual Learning Programs /

RM 700.00

MOF 003 - Microsoft Excel (Beginner & Intermediate) 15 August 2023

Price RM 700.00

Duration: 1 Day

Lectures: Zoom Meeting

Certificate of Completion

Objective

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.

Intermediate: Microsoft Excel Intermediate course will equip you with hands-on knowledge to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

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

2 Days Training Content

This content is restricted to members only. Please log in to view more details. Registration are Free!

Day One: Beginner (9am-1pm)

Lesson 1: Getting Started with Microsoft Office Excel

Seminar

Navigate the Microsoft Excel User Interface
Use Microsoft Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Microsoft Excel Help

Lesson 2: Performing Calculations

Practice

Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Practice

Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data

Lesson 4: Formatting a Worksheet

Practice

Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates

Lesson 5: Managing Workbooks

Practice

Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Lesson 6: Printing Workbooks

Practice

Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers

Day One: Intermediate (2pm-5pm)

Lesson 1: Introduction To Microsoft Excel

Activity

What is Microsoft Excel?
Why Should I Learn Microsoft Excel?
Understanding the Ribbon
Ribbon components explained
Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
Important Excel shortcuts

Lesson 2: Excel Basic Formulas

Practice

How to Do Addition, Subtraction, Multiplication & Division in Excel
How To Perform Arithmetic Operations in Excel
Step 1) Create an Excel Sheet and Enter the Data
Step 2) Format Data in Microsoft Excel
Step 3) Make Column Names Bold
Step 4) Align Data to the Left
Step 5) Enclose Data in Boxes
Step 6) Set the Print Area, Print Preview & Page Layout
Proper, Lower & Upper