.png){kind=logo}
Instructor
Tommy Stephens, Jr
Instructor
If you are ready for two days of intensive Excel training in a laptop optional, laptop friendly environment, then this course is for you. By using accounting-centric examples, developed for accountants, by accountants, Excel Boot Camp takes you through Excel from A to Z and shows you how to elevate your use of Excel to the next level. In addition to long-standing features in Excel such as lookup functions, the Camera tool, and formatting options, this program will highlight the number of recent improvements to Excel including additions to the function library, tables, a vastly improved charting engine, and an overhaul of PivotTable functionality. You will also learn various techniques for enhancing, not only your efficiency, but also your effectiveness, when working with Excel by taking advantage of a wide variety of power features to assist you in creating accurate spreadsheets in a fraction of the time previously required.
Great course. I wish I would have taken this years ago! L.S. CPA MN
I learned some great tips, tools & efficiencies. R.M. CPA MN
For more details, please visit www.k2e.com/ebc.
Upon completing this course, you should be able to:
* Implement various tips, tricks, and techniques in Excel to address issues, such as formatting, AutoCorrect, handling dates and times, and selecting cells with special characteristics
* Utilize Excels formula-building tools
* Identify how and when Excels table feature should be used
* Create and audit complex formulas, including those containing arrays and SUMIFS, VLOOKUP, HLOOKUP, INDEX, and MATCH functions
* List and apply various techniques for securing Excel workbooks
* Create charts in Excel that captivate audiences and communicate messages effectively
* List the six components of PivotTables and create PivotTables, including PivotTables that perform user-defined calculations
* Implement Excel Camera function to assist in creating custom reports
* Utilize Excels Macro Recorder tool to create simple, yet very useful, macros that you can put to work right away
* Cell formatting
* Understanding workbook and worksheet tools
* Working on the review tab of the ribbon
* Excel tools to keep you working efficiently
* Working with formula basics
* Building complex formulas
* Excel macros
* Using form controls and add-ins in Excel
* Getting data into Excel
* Working with PivotTables
* Understanding tables and data tools
* Charting with Excel
7887 E Belleview Ave Suite 200, Englewood, Denver County, Colorado 80111-6016
Get DirectionsFundamental knowledge of Excel 2007 or newer