Excel - FOUNDATION

I love sharing my own experience with you, so you know I’ve been in your shoes. Alas, I wasn’t born with any Excel skills. I had to go through the motion as well.

I made the decision to learn Excel after putting it on my resume while applying for a job. My friend had talked me into making the claim that I know it. I had never used it.

To save myself the embarrassment during the upcoming interview, I decided to cram the whole weekend learning Excel from scratch.

I bought 3 short manuals on my way home and spent the whole weekend learning it. I immediately realized that it was so easy to learn. And let me tell you, that is coming from someone who’s very number challenged.

Not only that, I went to a testing center the following Thursday and took the Microsoft Office Specialist test and got certified. Only days after learning it, mind you.

My point is, if I can do it, literally anyone can.

Take a chance on this greatly designed foundation course. Your future self will thank you for it.

Excel FOUNDATION – Course Description

An extremely powerful yet easy to use spreadsheet program, learning Excel is an essential to everyone’s advancement and career development. Everyone uses Excel at their job.

This great course lays down a solid foundation for the entire program and sets you up to build on it thereon. With a solid knowledge base, learning further advanced features will come effortlessly.

Using built-in functions as well as writing your own mathematical equations, this course will teach you how to build your own spreadsheet, how to format them, and how to print targeted sections of it.

In addition, of course, to many more essential working specifics.

It’s a one-day course that will accelerate your entire learning experience mastering this application.


This course is closed for enrollment.

Excel FOUNDATION – Knowledge Requirement

While prior knowledge of Excel is not required, it is essential you have a strong level of familiarity of the Windows Operating System’s basics:

·       Full command using a mouse and a keyboard

·       Creating a folder

·       The difference between Save and Save As

·       Cut/Copy and Paste

·       Ability to follow instructions

Excel FOUNDATION - Course Overview:

In this course you will learn how to:

·       Work within a worksheet, and master all aspects of its basic workings

·       Construct your own formulas and explore 5 built-in functions: Sum; Average; Count; Max; and Min

·       Copy formulas using Relative, Absolute and Mixed references – most vital to learning Excel

·       Format a worksheet’s text and numbers, and achieve the look and layout of your choice

·       Build custom lists and trends

·       Print targeted areas and certain elements of your work


Excel FOUNDATION - Course Outline

·       Introduction to the Environment – workbook, worksheet, cells, and ranges

·       Navigating Excel – simple ways to get around the application

·       The 3 Excel cursers – what does each do

·       Excel Formulas – the 3 rules of Excel formulas

·       Calculations in Excel – calculate cells and cell ranges

·       Using Built-in Functions – Sum; Avg; Max; Min; Count; etc.

·       Understanding Functions Syntax – learn the common Excel function patterns

·       Using the Function Palette - as an alternative to typing your own

·       Copying Formulas in Excel – essential to every user

·       Relative Reference vs Absolute Reference – learn the default action and how to counter it

·       Mixed Formula Reference – a little of both concepts

·       Built-in and Custom Lists

·       Understanding Excel Dates – date formats and more

·       Formatting in Excel – fancy up your worksheet

·       Printing in Excel – determine and have control of what you print