Details

---

Microsoft Excel – Foundation To Intermediate

Duration: 2 Days

Introduction

Capturing the audience's interest and engaging their participation are crucial for an effective presentation. This training will teach unconventional ways of using PowerPoint functions to create presentations that stand out by applying advanced design principles, such as visual impact, visual excellence, and visual dynamism, will be covered in the session.

Learning Outcomes

After this training workshop, participants will be able to:

• Getting Started with Microsoft Excel
• Identify the Elements and Interface of Excel
• Performing Calculation, Basic Formula and Functions
• Modify worksheet & Formatting Worksheet
• Printing and managing large workbook
• COUNTIF Function
• AVERAGEIF Function
• SUMIF Function
• IF and IFERROR Function
• Filter data using Auto & Advanced Filters
• Advanced Chart Formatting
• Clean Duplicate Records

Key Content

Unit 1 – Getting Started with Microsoft Excel

Topic A

• Identify the Elements of the Excel Interface
• Microsoft Excel
• What are Spreadsheet, Worksheet and Workbook
• What are Columns, Row, Cells, and Ranges
• The Excel Interface
• Navigation Options
• Create a Basic Worksheet • The Ribbon • The Backstage View • The Save and Save As Commands

Topic B Creating a New Blank Workbook

• Create a Basic Worksheet
• The Ribbon
• The Backstage View
• The Save and Save As Commands

Unit 2 – Performing Calculation

Topic A: Create Formulas in a Worksheet

• Excel Formulas
• The Formula Bar
• Elements of an Excel Formula
• Common Mathematical Operators
• The Order of Operations
• Division Formula

Unit 3 – Modifying a Worksheet

Topic A: Manipulate Data

• The Undo and Redo Command
• The AutoFill Feature
• Auto Fill Options
• The Transpose Option
• Live Preview
• The Clear Button

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

• The Insert and Delete options
• Column Width and Row Height Alternation Methods
• The Hide and Unhide Options

Topic C – Search for and Replace Data

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

Topic D – Spell Check a Worksheet

• The Spelling Dialog Box

Unit 4 – Formatting a Worksheet

Topic A: Modify Fonts

• Fonts
• The Font Group
• The Format Cells Dialog Box
• The Format Painter
• Live Preview and Formatting
• The Mini Toolbar

Topic B: Add Borders and Colors to Cells

• Border Options
• Fill Option

Topic C: Apply Number Formats

• Number Formats
• Dragging and Dropping Cells
• How to cut, copy, and paste cells
• How to cut, copy, and Paste Multiple cells
• Using the Clipboard
• Using Paste Special
• Number Formats in Excel
• Custom Number Formats

Topic D: Align Cell Contents

• Alignment Options
• The Indent Commands
• Orientation Options
• The Merge & Center Options

Unit 5 – Printing Workbook Contents

Topic A: Define the Basic Page Layout for a Workbook

• The Print Options in Backstage View
• The Page Setup Dialog Box
• The Print Preview Option
• Headers and Footer
• Header and Footer Settings
• Page Margins
• Margins Tab Options
• Page Orientation

Topic B: Refine the Page Layout and Apply Print Options

• Zoom Options
• Page Breaks
• Page Break Options
• The Print Area
• Print Titles
• Scaling Options

Unit 6 – Managing Large Workbooks

Topic A: Format Worksheet Tabs

• Renaming Worksheet Tabs
• Changing Tab Color

Topic B: Manage Worksheets

• Repositioning Worksheets
• Inserting or Deleting Worksheets
• Hiding and Unhiding Worksheets
• Worksheet References in Formula

Unit 7 – Performing Calculations

Topic A: Reuse Formulas

• Relative References
• Absolute References
• Mixed References
• Understanding Mixed Cell References

Unit 8 – Working with Functions

Topic A: Using Statistical Functions

• COUNTIFS Functions
• AVERAGEIFS Function

Topic B: Using Mathematical Function

• SUMIFS Function

Topic C: Using Logical Function

• IFERROR Functions
• IF Function

Unit 9 – Organizing Worksheet Data with Tables

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 to Calculate Data

• SUBTOTAL Functions
• Summary Functions in Tables

Unit 10 – Visualizing Data with Chart

Topic A: Create Charts

• Charts
• Chart Types
• Chart Insertion Methods
• Resizing and Moving the Chart
• Adding Additional Data
• Switching Between Rows and Columns

Target Audience

This course is intended for participants who wish to gain more knowledge from the foundation level of Excel. For participants who are working with lots of formulas and creates report to understand the necessary technique on how an electronic spreadsheet works.

Methodology

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