Microsoft Excel 2016 – Level 1

Duration: 2 Evenings

This course provides and covers the same topics as provided for in our regularly scheduled day sessions. However, because it is scheduled for the evening, two sessions are required to cover topics.

Interested in attending? Have a suggestion about running this course near you?
Register your interest now

Description

On completion of this course, you will be able to:

  • Understand and Work with Microsoft Excel
    • Understanding and Working with Microsoft Excel
      • Understand Difference Between Rows, Columns, Cell, Cell Pointer, AutoFilter Handle
      • Identify and Use of the Formula Bar
      • Identify and Use of the Name Box
      • Identify and Use Status Bar & Features
      • Review of Mathematical Symbols and Other Symbols to be used
      • Customize the Ribbon and Quick Access Toolbar
    • The Design of a Basic Worksheet
    • Create and Editing Formulas in a Worksheet
      • Insert Functions in a Formula
      • SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, DATEDIF, TODAY, NOW, SUBTOTAL, TEXT, IF
    • Working with AutoSum
    • Copying Formulas
    • Sort Data
    • Insert, Manipulate, and Delete Cells, Columns, and Rows
    • Working with Flash Fill vs Concatenate
    • Find and the Replace Command
    • Spell Check a Worksheet
    • Formatting the Worksheet
      • Modify Font Name, Size and Color, Fill, Borders and Underlining
      • Apply Date and Number Formats
      • Align Cell Contents and Indentation of Labels
      • Working with Orientation, Wrap Text and Merge and Center
      • Working with Clear
      • Adjusting Column Width and Row Height
    • Understand Use of and Working with the Format Painter
    • Refine the Page Layout and Apply Print Options
    • Manage Worksheets
      • Rename Worksheet
      • Insert and Delete Worksheet
      • Copy and Move Worksheet
      • Re-Arrange Sheet Tab Order
      • Change Tab Color
      • Move Between Worksheets
    • Manage the View of Worksheets and Workbooks
    • Change Worksheet Zoom

Progression: Microsoft Excel 2016 Level 2

Prerequisites

Basic knowledge of computers and use of mouse

Do NOT follow this link or you will be banned from the site!