top of page

INTRODUCTION TO MICROSOFT EXCEL - BASIC

5 hacker.png
This Intermediate Microsoft Excel  training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

Students who have basic skills with Microsoft Excel who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the interface.

SUGGESTED ENTRY REQUIREMENTS

  • Basic computer skills

  • Computers made easy course

  • Introduction to Excel

COURSE & TECHNICAL REQUIREMENT

In order to get the full benefit of and complete this programme, you are required to:

  • Have a registered email account for notifications and communications

  • Have access to a computer/laptop/tablet

  • Have a stable internet connection

  • Read documents in Adobe Acrobat PDF reader, or a similar PDF viewer

  • Have access to the Microsoft Office Suite (inclusive of MS Word, Excel, PowerPoint) or Mac OS Pages Application to create and read documents, as well as have the ability to export documents into PDF files

  • Use the latest version of Firefox/Internet Explorer/Chrome web browser when accessing the Virtual Learning Environment

WHAT YOU WILL LEARN

  • Learn to use formulas and functions.

  • Create and modify charts.

  • Convert, sort, filter, and manage lists.

  • Insert and modify illustrations in a worksheet.

  • Learn to work with tables.

  • Learn to use conditional formatting and styles.

COURSE OUTLINE

MODULE 1: Microsoft Office Basics

  • Logging in to Microsoft 365

  • Installing Applications

  • Creating New Files and AutoSaving

  • Protected View

  • File Sharing

  • File Collaboration

  • Version History

  • Getting Updates

  • Mac Versions


MODULE 2: Creating a Microsoft Excel Workbook

  • Starting Microsoft Excel

  • Creating a Workbook

  • Saving a Workbook

  • The Status Bar

  • Adding and Deleting Worksheets

  • Copying and Moving Worksheets

  • View Options for the Worksheet

  • Closing a Workbook

  • Creating a Microsoft Excel Workbook (Exercise)


MODULE 3: The Ribbon

  • Tabs

  • Groups and Commands

  • Microsoft Search Box


MODULE 4: The Backstage View (The File Menu)

  • Introduction to the Backstage View

  • Opening a Workbook

  • Open a Workbook (Exercise)

  • New Workbooks and Excel Templates

  • Select, Open, and Save a Template Agenda (Exercise)

  • Printing Worksheets

  • Print a Worksheet (Exercise)

  • Personalizing Microsoft Office


MODULE  5: The Quick Access Toolbar

  • Getting Started

  • Adding Common Commands

  • Adding Additional Commands with the Customize Dialog

  • Adding Ribbon Commands or Groups

  • Customize the Quick Access Toolbar (Exercise)


MODULE  6: Entering Data in Microsoft Excel Worksheets

  • Entering Text

  • Inserting and Deleting Cells

  • Inserting Hyperlinks

  • Inserting WordArt

  • Using AutoComplete

  • Entering Text and Using AutoComplete (Exercise)

  • Entering Numbers and Dates

  • Using the Fill Handle

  • Entering Numbers and Dates (Exercise)


MODULE  7: Formatting Microsoft Excel Worksheets

  • Selecting Ranges of Cells

  • Hiding Worksheets

  • Adding Color to Worksheet Tabs

  • Adding Themes to Workbooks

  • Customize a Workbook Using Tab Colors and Themes (Exercise)

  • Adding a Watermark

  • The Font Group

  • Working with Font Group Commands (Exercise)

  • The Alignment Group

  • Working with Alignment Group Commands (Exercise)

  • The Number Group

  • Working with Number Group Commands (Exercise)


MODULE  8: Editing Worksheets

  • Find

  • Find and Replace

  • Using Find and Replace (Exercise)

  • Using the Clipboard

  • Using the Clipboard (Exercise)

  • Moving Columns / Rows


MODULE  9: Working with Rows and Columns

  • Inserting and Deleting Rows, Columns, and Cells

  • Transposing Rows and Columns

  • Row Height and Column Width

  • Hiding and Unhiding Rows and Columns

  • Freezing Panes

  • Working with Rows and Columns (Exercise)


MODULE  10: Using Formulas in Microsoft Excel

  • Math Operators and the Order of Operations

  • Entering Formulas

  • AutoSum (and Other Common Auto-Formulas)

  • Copying Formulas

  • Relative, Absolute, and Mixed Cell References

  • Working with Formulas (Exercise)


MODULE  11: Finalizing Microsoft Excel Worksheets

  • Setting Margins

  • Setting Page Orientation

  • Setting the Print Area

  • Print Scaling (Fit Sheet on One Page)

  • Repeating Headings

  • Headers and Footers

  • Preparing to Print (Exercise)

bottom of page