Course Description

I have been using Excel for over twenty years. In that time, I have seen a lot of changes to the appearance of the program, as well as improvements to how the program itself functions.

In this course, students will learn how to create a basic spreadsheet in Excel 2013. We will create a live example to demonstrate the functionality of Excel. This course focuses on the basics of Excel, including formatting, data analysis, and common formulae.

The course is approximately 75 minutes long and includes a combination of presentation slides and live examples. I create a spreadsheet in real time so that the student can see how easy it can be.

You should take this course if you want to become familiar with the functionality in Excel 2013. This course can serve as a great introduction or a refresher to using Excel.

By the end of this course, you will be able to create, edit, and properly format Excel spreadsheets.

  • You will be introduced to business analysis in this course, at a high level.
  • This course is intended for people in business who would like to learn how to use the power of Excel to analyze their data.
  • There are no pre-requisites to this course. I highly recommend that you have access to Excel 2013.

Growth Strategist

Jeff Borschowa

Jeff Borschowa is an author, educator, writer, international speaker and technology enthusiast. Jeff works with accounting professionals to help them leverage technology in their growth. Jeff’s focus is on how to run a better business built on better technology. Jeff is a thought leader in the accounting industry and has written 3 books in the “8 Pillars for Exponential Business Growth” series.

Course curriculum

  • 1

    Introduction

  • 2

    Quick Tour of Excel

    • Excel - Quick Tour

    • Excel - Name and Save

    • Excel - Basics of Text Formatting

    • Excel - Entering Data
  • 3

    Excel Features

    • Excel - Assign Cell Formats

    • Excel - Autofill Data In Sequence
  • 4

    Excel Functions (formulae)

    • Excel - Calculating Totals With AutoSum

    • Excel - Average, Minimum, and Maximum Values

    • Excel - Absolute Referencing

    • Excel - Essential Formulas
  • 5

    Navigation

    • Excel - Freezing Columns and Rows

    • Excel - Navigation Shortcuts

    • Excel - Advanced Formatting
  • 6

    Advanced Features

    • Excel - Best practices for spreadsheets

    • Excel - Copying and moving worksheets

    • Excel - Introduction to Charts

    • Excel - Adding comments

    • Excel - Sorting

    • Excel - Filtering

    • Excel - Formatting for Printing

    • Excel - Pivot Tables
  • 7

    Conclusion

    • Excel - Conclusion