Microsoft Excel® Training Courses

We start by teaching the basics of Microsoft Excel. You are probably already familiar with Excel. You most likely understand how to do simple things, like sort, filter, sum, write simple formulas, subtotals, and the like. As you progress through the Excel course, we will re-emphasize what you already know and expand your knowledge by introducing concepts that you may not have explored yet, like PivotTables, advanced functions like VLOOKUP() and MATCH(), and writing complex formulas using a nested IF() function. If you are converting from Excel 2003 to Excel 2007 or higher, click here to access a guide that shows you the commands in Excel 2003 and how to access them in Excel 2007. The ExcelCEO course is divided into three sections; Beginning, Intermediate, and Advanced. The last chapter of the course is the Comprehensive Project. After you complete the entire course and the Comprehensive Project, you will receive a certificate as an Excel Master!

• Beginning Excel teaches Excel basics (like spreadsheet navigation, using toolbars and simple formulas), formatting (font family, size, color, borders and custom formatting), sorting, subtotals, filtering, and printing.
• Intermediate Excel teaches how to write formulas, which we believe is the "lost art" of Excel. In that section, you will use functions in writing formulas (function types include text, financial, math, date, database, lookup and logical), handle errors in formulas, and prepare a discounted cash flow analysis and a proforma income statement.
• Advanced Excel begins with an in-depth study of PivotTables, and progresses to topics such as graphs and trendlines, analysis tools (like Goal Seek and Solver), protecting and sharing workbooks, working with the World Wide Web, macros and other advanced tools.
• The Comprehensive Project - The last chapter is the Comprehensive Project where you will create a relatively complex budgeting spreadsheet. This last chapter is what separates our course from all others in the market - we actually have you apply the concepts you've learned on your own in a real world project. In all the previous chapters, we have told you, almost keystroke-by-keystroke, what to do. You will complete the Comprehensive Project on your own. We give you screenshots with the correct answers throughout the project just so you don't get too far off track. The final exam is based entirely on the completed project. If you do the project correctly, the last test will be the easiest one in the course. If you don't do it correctly, you will fail the final exam miserably, so it is imperative that you complete ALL the exercises in the course to complete the last exam.

Once you complete the entire Excel course, you will have a skillset that is unmatched in the marketplace today. Note: The ExcelCEO course material and website are developed, maintained, and administered by ClineSys, the leader in Microsoft Excel and Access training.