MOF 003 – Microsoft Excel (Beginner to Intermediate), 24 July 2023

MOF 003 – Microsoft Excel (Beginner to Intermediate), 24 July 2023

Teachers
Category:
IT (VL)/ Virtual Learning Programs/
RM 700.00
D4 (1)

RM 700.00

Duration: 1 Day
Lectures: Zoom Meeting
Certificate of Completion

Introduction

Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings help your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.

.

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

1 Day Training Content

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

Day One

Lesson 1.1. Starting Excel

  • Excel Start Screen

Lesson 2.1. The Quick Access Toolbar and File Tab

  • The Default QAT Commands
  • Tabs and Groups
  • The File (Backstage View) Tab

Lesson 2.2. What is in your Workbook?

  • Using Worksheets
  • Various types of Pointer in Excel
  • The Active Cell
  • Exploring a Worksheet
  • Zooming a Worksheet

Lesson 3.1. Working with Excel

  • Columns, Rows, Cells, and Ranges
  • Creating Worksheet Labels
  • Entering and Deleting Data

Lesson 3.2. Basic Excel Features

  • AutoFill Fill Data
  • AutoComplete Data Entry

 Lesson 3.3. Moving your Data

  • How to Cut, Copy, and Paste Cells
  • Using the Clipboard
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo and Redo

Lesson 4.1. Understanding with Basic Mathematical Operators

  • Addition / Subtraction/ multiplication/ Division Formula

Lesson 4.2. Working with Basic Functions

  • Auto Sum Function
  • Count Function
  • Max Function
  • Min Function
  • Average Function

Day One

Lesson 5.1. The Page Setup and Printing

  • Setting Margins
  • Setting the Page Orientation
  • Setting the Paper Size
  • Inserting Headers
  • Inserting Footers
  • File Print Commands
  • Print Settings

  • Topic A.Reuse Formulas
  • Relative References
  • Absolute References
  • Mixed References
  • Understanding Mixed Cell References

Topic A.Using Statistical Function

  • COUNTA Function
  • AVERAGEA Function
  • Topic B.Using Mathematical Function
  • SUMIF Function
  • Topic C.Using Logical Function
  • IFERROR Function
  • IF Function

Topic A.Create and Modify Tables

  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options

Topic B.Sort and Filter Data

  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Removing Duplicate Values

Topic C.Use Subtotal and Database

    • Functions to Calculate Data
    • SUBTOTAL Functions
    • Summary Functions in Tables

About Instructors