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
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
- 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
- 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
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: Managing Large Workbooks
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
Module 5: Printing Workbook Contents
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
