Contact Us
Microsoft Office

Microsoft Excel 2021 Foundation

  • 1 Day(s)
Excel Foundation course to build basic spreadsheet skills, formulas, functions, tables, charts, and daily Microsoft Excel confidence.

The Excel Foundation course is designed for learners who want to build strong basic skills in Microsoft Excel for daily workplace use. This course introduces participants to essential spreadsheet concepts, including referencing calculations, working with functions, organizing data with tables, and presenting information through simple data visualization.

Participants will learn how to create, manage, calculate, and organize spreadsheet data more confidently. The course is suitable for those who need to prepare reports, manage records, perform basic calculations, and improve productivity using Microsoft Excel.

This Excel Foundation training is suitable for clerks, officers, executives, supervisors, administrators, managers, and working professionals who want to strengthen their practical Excel skills for everyday business tasks.

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

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.

Course Outlines:

Module 1: Getting Started with Microsoft Excel 2021

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
  • Blank and new template
  • The Save and Save As Commands
Module 2: Formatting a Data in Worksheet

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

 

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 Special
  • 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 I – Spell Check a Worksheet

  • The Spelling Dialog Box

 

Topic J – Search for and Replace Data

  • The Find Command
  • The Replace Command
  • The Go to Command
Module 3: Performing Calculation

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
Module 4: Referencing Calculations

Topic A: Formula Reference

  • Relative References
  • Absolute References
  • Mixed References
Module 5: Managing Large Workbooks

Topic A: Format Worksheet Tabs

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

 

Topic B: Manage Worksheets

  • Repositioning Worksheets
  • Hiding and Unhiding Worksheets

 

Topic C: 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
Module 6: Printing Workbook Contents

Topic A: Define the Page Setup

  • Print Options In Backstage View
  • Page Setup Dialog Box
  • Print Preview Option
  • Page size
  • Page orientation
  • Page Margins
  • Headers and Footers

 

Topic B: Print Options

  • Scale to fit
  • Page break
  • Print title

Courses You May Like

Engineering & Industry

TOTAL PRODUCTIVE MAINTENANCE

View Course

Team Building

The Supercharged Team

View Course

Leadership

Strategic Performance Measurement and Appraisal (Using Balance Scorecard)

View Course

Leadership

Shake It Up

View Course

Accounting & Finance

Service Tax Act 2018

View Course

Law & Legal

Personal Data Protection Act

View Course

Your RFQ submission has been received

Our representative will be in touch with you soon