Microsoft Excel®
Training

Level 1
You will learn to use Microsoft Excel in less time than you might think. The basics take about an hour, which is enough training to match the skills of most users. By this time you’ll be able to make a simple worksheet.

Creating custom formulas and more advanced worksheets take a little longer to learn, but you’ll be surprised at how quickly you’ll get up to speed. Within the second hour of the course you’ll learn details about how commands like copy and paste work as well as how to leverage command capabilities to meet your needs. Formatting cells and groups of cells, writing equations and formulas, and knowing a good strategy for creating worksheets will be a breeze when you reach this level.

Level 2
You might think building intelligence into your worksheets takes an enormous amount of skill, and it does, but we’re just getting started. Once you reach Level 2 you will learn how to make cells respond to values in other cells. You will master logical operators which give your worksheets the ability to make decisions. You’ll even learn how to make your worksheets change based on those decisions.

Keep in mind that everything you learn in this course is presented in a simple to understand manner. So it’s easy to learn, and believe it or not, you can master these skills. But we’re not finished yet. This only takes us most of the way through Level 2.

About half way through Level 2 the course shifts from the somewhat complex to worksheet formatting and setup for printing. So to keep you from having brain freeze you’ll learn about simple concepts like Freeze Panes and hiding and un-hiding cells. You’ll learn how to setup a print area as well as how to define page breaks. You’ll learn everything you need to take complete control over printing and page format.

Just before you finish with Level 2 you’ll dive back into advanced cell formulas and mathematical functions, and you’ll practice using more advanced logical operators. By this time you’re skill level will be in the top 5% of all Excel users, but who’s counting? You’ve had 4 hours of video instruction. You should be in the top 5%, but we’re not finished.

Level 3
Now you’re ready for Level 3, databases, lists, and macros, and all the functions associated with them. You’re skills will quickly exceed those of the top 1% of Excel users. You will make Excel read values from tables and produce outputs based on the values it finds. In fact, your skill will be strong enough to create a completely automated warehouse inventory worksheet. When items in inventor get low, you will be notified. You’ll be able to check out items from inventory and the remaining quantities are automatically updated. Macros will drive this powerhouse, and you’ll know how everything works.

Did I mention charts and graphs? They’re in there. Pivot tables and Error Trapping? Got it. This course has everything. It’s easy to use, and designed to make it easy to learn. All you have to do is watch the lessons and practice the tasks in the lessons. Within a short time you will be the Excel expert in your community.