Excel Essentials

Level
Total time

Excel Essentials

Acuity Training Ltd.
Logo Acuity Training Ltd.

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Acuity Training Ltd. offers this product as a default in the following regions: Surrey

Description

Course Objectives

Learn the essential skills of using the spreadsheet management program Excel.  By the end of this course, students will be able to create Excel workbooks and worksheets, navigate around them, use time saving features such as AutoSum, AutoFill, and create formulae and format worksheets.

Prerequisites

This course assumes that you have gained a basic understanding of Windows.  This includes an ability to work with multiple windows and navigate the desktop, as well as having an understanding of computer file storage (i.e. drives, files and folders).

Exercises

This course is instructor led, involving the utilisation of examples and exercises in a workshop environment.

TOPI…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Course Objectives

Learn the essential skills of using the spreadsheet management program Excel.  By the end of this course, students will be able to create Excel workbooks and worksheets, navigate around them, use time saving features such as AutoSum, AutoFill, and create formulae and format worksheets.

Prerequisites

This course assumes that you have gained a basic understanding of Windows.  This includes an ability to work with multiple windows and navigate the desktop, as well as having an understanding of computer file storage (i.e. drives, files and folders).

Exercises

This course is instructor led, involving the utilisation of examples and exercises in a workshop environment.

TOPICS

Getting to Know Excel

  • Starting Microsoft Excel
  • How Microsoft Excel  Works
  • Using The Ribbon
  • Using Ribbon Key Tips
  • Minimising The Ribbon
  • Understanding The Backstage View
  • Accessing The Backstage View
  • Using Short Cut Menus
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding The Quick Access Toolbar
  • Adding Commands To The QAT
  • Understanding The Status Bar
  • Exiting Safely From Excel

 Creating a New Workbook

  • Understanding Workbooks
  • Creating a New Workbook
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Typing Formulas
  • Saving a New Workbook
  • Easy Formulas
  • Checking the Spelling
  • Making Basic Changes
  • Printing a Worksheet
  • Safely Closing a Workbook

Selecting Ranges

  • Understanding Cells And Ranges
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Using Special Selection Techniques
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns

Editing In A Workbook

  • Understanding data editing
  • Overwriting Cell Contents
  • Editing Longer Cell Entries
  • Clearing A Cell
  • Deleting In A Worksheet
  • Undoing and Redoing Operations

Working with Comments

  • Understanding Comments
  • Adding Worksheet Comments
  • Managing Worksheet Comments
  • Printing Comments
  • Deleting Comments

Filling Data

  • Filling A Growth Series
  • Filling A Series Backwards
  • Filling Using Options
  • Creating A Custom Fill List
  • Modifying And Deleting Custom Fill Lists

Formulas & Functions

  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply and Divide
  • Understanding Functions
  • Using The SUM Function To Add
  • Summing Non-Contiguous Ranges
  • Calculating An Average Finding A Maximum Value
  • Finding A Minimum Value
  • More Complex Formulas
  • What If Formulas

 Formula Auditing

  • Tracing Precedents and Dependents
  • Showing Formulas and Cell Arguments
  • Common Error Messages
  • Checking for Errors
  • Tracing Errors
  • Evaluating Formulas Using the Watch Window
  • Dealing with Circular References

Formula Referencing

  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References

Font Formatting

  • Working With Live Preview
  • Changing Fonts
  • Changing Font Size
  • Growing and Shrinking Fonts
  • Changing Font Colours
  • Changing Background Colours
  • Using The Format Painter
  • Increasing And Decreasing Decimals

Number Formatting

  • Applying General Formatting
  • Formatting As Currency
  • Formatting Percentages
  • Formatting As Fractions
  • Formatting As Dates
  • Using The Thousands Separator

Applying Borders

  • Understanding Borders
  • Applying a Border to a Cell
  • Applying a Border to a Range
  • Applying a Bottom Border
  • Applying Top and Bottom Borders
  • Removing Borders
  • Using the More Borders Option

Working With a Worksheet

  • Understanding Worksheets
  • Changing Worksheet Views
  • Worksheet Zooming Viewing The Formula Bar
  • Viewing The Gridlines
  • Viewing The Ruler
  • Inserting Cells
  • Deleting Cells
  • Inserting Columns
  • Inserting Rows
  • Deleting Rows And Columns
  • Switching Between Worksheets

 Printing

  • Previewing Before You Print
  • Selecting A Printer
  • Printing A Range
  • Printing An Entire Workbook
  • Specifying The Number Of Copies
  • The Print Options
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.