Microsoft Power BI

    Microsoft Excel Refresher Essentials

    Course Duration: 90 Minutes

    Target Audience:

    This session is designed for those who have not used Excel in a long time or are intermittent users and would like to refresh their key skills in Excel.

    Course Objectives:

    To develop a good working knowledge of Excel to include features such as basic functions and formulas, sorting and filtering data, formatting and printing spreadsheets.

    Course Outline:

    Course Introduction

    Microsoft Excel Basics

    • Creating a new Workbook and new Worksheet
    • The Excel screen and user environment
    • Entering data into a Worksheet, and managing columns and rows
    • Formatting information to look professional
    • Printing the information and using Print Preview
    • Saving and closing a Workbook
    • Opening existing Workbooks
    • Creating standard formulas
    • Formula concepts within Excel
    • The four different mathematical operators
    • The order of operators within a formula
    • Editing formulas in-cell and using the Formula Bar
    • Using Copy & Paste, and the Autofill feature
    • Understanding Relative and Absolute cell referencess
    • What is are Functions in Excel?
    • Using Standard Functions - Sum, Average, Max, Min, and Count

    Discussion and Question Time

    View Schedule
    Contact Us