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

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

Teachers
Sazali
Category:
IT PP/ Public Programs/
RM 1,990.00
D4 (2)

RM 1,990.00

Duration: 2 Days
Lectures: De Palma Hotel
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-5pm)

  • 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

  • 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

Day Two: Intermediate (9am-5pm)

  • 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

  • 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

  • Data validation
  • Data filters
  • Group and Ungroup
  • Summary

  • What is a chart?
  • Types of Charts in MS Excel
  • The importance of charts
  • Step by step example of creating charts in Excel
  • Summary

  • SUM
  • SUMIF
  • CONCAT
  • COUNTIF
  • VLOOKUP
  • IF
  • HLOOKUP
  • COUNTIF

  • Insert Picture into a Cell in Excel
  • Layer and Group Graphic Objects
  • Grouping Objects
  • Incorporate SmartArt

  • How to insert the current date and time in Excel
  • Current date and time formulas (dynamic)
  • Date and time example
  • Date and time formulas (static)

  • Insert a Pivot Table
  • Drag fields
  • Sort
  • Filter
  • Change Summary Calculation
  • Two-dimensional Pivot Table
  • Create a PivotTable timeline to filter dates
  • Use a Timeline to filter by time period
  • Use a Timeline with multiple PivotTables
  • Clear a timeline
  • Customize a timeline

About Instructors

Sazali
- Microsoft Office Training - Microsoft Word - Microsoft Excel - Microsoft Powerpoint