Excel

Level 1: Foundation

Ramp up your Excel skills rapidly

  • Do you feel overwhelmed or frustrated trying to use Excel because you don’t know where to start?
  • Have you ever created an Excel sheet but struggled with properly entering and organizing the data?
  • Does trying to write Excel formulas make your head spin?
  • Do you waste time hunting for data buried deep inside endless spreadsheets?
  • Are you embarrassed to share your Excel documents because of messy, unreadable formatting?
  • Have you avoided printing Excel sheets out of fear they won’t look right on paper?
  • Do you miss shortcuts and commands that would help you use Excel more efficiently?
  • Does Excel feel clunky or rigid because you can’t customize settings and options?
  • Is trying to self-teach Excel through videos or books moving too slowly for your needs?
  • Is your lack of Excel knowledge holding back your productivity and confidence?

If so, then the Excel Level 1: Foundation course will help you.

MORE DETAILSDOWNLOAD BROCHURE

AT A GLANCE

Audience

This course is best suited for beginner or novice users, or those with limited time to develop efficient foundational Excel skills from the ground up.

Format ​

  • 1 x 1-day instructor-led online sessions
  • Public workshops are available for all our Excel courses.

What’s Included

  • Comprehensive Learning Guide and Resource Manual
  • Subscription to our monthly LearningLink e-newsletter

The Fast Track to Excel Excellence

Learn how to prepare and present spreadsheets systematically and professionally and to rapidly build visually-appealing outputs for printing or publishing.

This course will help you:

  • Get started with Microsoft Office Excel.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.
FULL OUTLINEMake an enquiry

What You Will Learn

Create Spreadsheets

Understand the Excel interface and components to create basic worksheets, input data into cells, and navigate workbooks.

Enhance Worksheet Presentation

Format workbook text, cells, rows, columns, and tabs for a clear and professional look.

Use Formulas & Functions

Build formulas with math operators, and utilize essential functions like SUM, AVERAGE and COUNT to calculate data.

Refine Printing

Prepare sheets for printing or turning into PDF by defining page layout, title, layout, view, and other print options.

Detailed Synopsis

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Unit 1 Getting Started with Microsoft Office Excel

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help.

Unit 2 Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

Unit 3 Modifying a Worksheet:

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Unit 4 Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Unit 5 Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

Unit 6 Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
DOWNLOAD BROCHUREMake enquiry