MICROSOFT EXCEL 2021 FOUNDATION

MICROSOFT EXCEL 2021 FOUNDATION

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Excel Course: Master Microsoft Excel 2021 Foundation

Are you looking to boost your career prospects? Our Excel Course on Microsoft Excel 2021 Foundation is your ticket to unlocking a world of opportunities. Whether you’re a newbie or already have some spreadsheet experience, this course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels, and anyone eager to elevate their Microsoft Excel skills.

What You'll Learn

In this interactive and practical course, we delve into the core of Microsoft Excel 2021, breaking down complex spreadsheet concepts into easy-to-understand modules. You’ll discover how to navigate the Excel interface, create and format data, perform calculations, and manage large workbooks efficiently. By the end, you’ll be equipped with the skills to confidently handle tasks like data analysis, report creation, and more.

Elevate Your Career

In today’s fast-paced corporate world, Excel proficiency is a valuable asset. Whether you’re striving for a promotion, aiming for a new job, or simply looking to enhance your productivity, mastering Microsoft Excel 2021 through our Excel Course can set you on the path to success. Join us to harness the power of spreadsheets, and watch your career soar to new heights. It’s time to excel in Excel!

Course Details

Course Code: EX21F-1; Instructor-led

 

Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Prerequisites

Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

  • Give participant a systematic understanding of a spreadsheet ad its benefits
  • Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment

Upon completion of this program, participants should be able to:

  • Getting Started with Microsoft Excel 2021, Identify the Elements and Interface of Excel
  • Performing Calculation, Basic Formula and Functions
  • Modify worksheet & Formatting Worksheet
  • Printing and managing large workbook

Outlines

Topic A – Identify the Elements of the Excel Interface

  • Microsoft Excel 2021
  • What is Spreadsheet, Worksheet and Workbook
  • What are Columns, Row, Cells, and Ranges
  • The Excel Interface
  • Navigation Options

Topic B Creating a New Blank Workbook

  • The Ribbon
  • The File View
  • The Save and Save As Commands

Topic A: Formatting Fonts

  • Font type
  • Font size
  • Font color
  • Bold
  • Italic
  • Underline
  • The Mini Toolbar
  • The Clear Button

 

Topic B: Add Borders and Colors to Cells

  • Select Border
  • Select Fill

 

Topic C: Align Cell Contents

  • Horizontal Alignment
  • Vertical Alignment
  • Increase or Decrease Indent
  • Wrap Text
  • Orientation Options
  • Merge & Center

 

Topic D: Apply Formats

  • Format cell
    • Number
    • Date
    • Currency
  • Paste Format

 

Topic E: Move and Duplicate data

  • Dragging and Dropping Cells
  • Cut, copy, and paste cells
  • Cut, copy, and Paste Multiple cells
  • Using the Clipboard
  • Paste Value
  • Format Painter

 

Topic F: Apply Cell Styles

  • Cell Styles
  • Style Dialog Box

Topic G: Manipulate Data

  • Undo and Redo Commands
  • AutoFill Feature
  • Auto Fill Options
  • Transpose Option

Topic H: Insert, Manipulate, and Delete Cells, Columns, and Rows

  • Insert and Delete cell, row, column
  • Column Width and Row Height Alternation Methods
  • Hide and Unhide row, column

Topic A: Create Formulas in a Worksheet

  • Common Mathematical Operators
    • Addition
    • Subtract
    • Multiply
    • Divide
  • The Order of Operations

 

Topic B: Insert Functions in a Worksheet

  • Functions in Excel
    • SUM
    • AVERAGE
    • COUNT
    • MIN
    • MAX
  • Worksheet References in Formulas

Topic A: Format Worksheet Tabs

  • Insert sheet
  • Renaming Worksheet Tabs
  • Changing sheet Tab Color

Topic B: Manage Worksheets

  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets

Topic C: Spell Check a Worksheet

  • The Spelling Dialog Box

Topic D: Search for and Replace Data

  • The Find Command
  • The Replace Command
  • The Go to Command

Topic E: Manage the view of Worksheets and Workbooks

  • Split Command
  • Freeze Panes
  • Arrange All Command
  • View Side by Side Command
  • Switch windows Command
  • New Window Command
  • Zoom Options

Topic A:  Define the Page Setup

  • Page size
  • Page orientation
  • Page Margins
  • Headers and Footers

Topic B: Print Options

  • Scale to fit
  • Page break
  • Print title

Trainers

Reviews

Interested In

MICROSOFT EXCEL 2021 FOUNDATION

Starting From
RM300
Intake Date
11 MAR 2024
,
15 APR 2024
,
13 MAY 2024
,
10 JUNE 2024
,
15 JULY 2024
,
12 AUG 2024
,
2 SEPT 2024
,
7 OCT 2024
,
11 NOV 2024
,
2 DEC 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: MICROSOFT EXCEL 2021 FOUNDATION
Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *