K2's Excel Boot Camp
Course Information
16
CPE Credits
16-Hour Course
Computer Software and Applications (16 Credits)
Fundamental Knowledge of Excel 2013 and Newer
Prerequisites
Intermediate
Program Level
No
Preparation
Course Information
16
CPE Credits
16-Hour Course
Computer Software and Applications (16 Credits)
Fundamental Knowledge in Excel 2013 and Newer
Prerequisites
Intermediate
Program Level
No
Preparation
Course Description
If you are ready for two days of intensive Excel training in a “laptop optional, laptop friendly” environment, then K2’s Excel Boot Camp is for you! By using accounting-centric examples, developed for accountants, by accountants, Excel Boot Camp takes you through Excel from A to Z. Participate in this course and you will 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, K2’s Excel Boot Camp will highlight the number of recent improvements to Excel. For example, you will learn about new functions, tables, a vastly improved charting engine, and an overhaul of PivotTable functionality.
Additionally, you will learn various techniques for enhancing not only your efficiency, but also your effectiveness when working with Excel. Further, you will learn how to take advantage of a wide variety of “power features” to assist you in creating accurate spreadsheets in a fraction of the time previously required.
If you plan to take only one Excel course this year, make sure K2’s Excel Boot Camp is the one you choose!
Learning Objectives
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 Excel’s formula-building tools
- Identify how and when Excel’s 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’s Camera function to assist in creating custom reports
- Utilize Excel’s Macro Recorder tool to create simple, yet very useful, macros that you can put to work right away
Who is the course for?
Excel users and potential Excel users who want to increase their efficiency and effectiveness with Excel
Instructional Delivery Method
Group-live demo and discussion using color computer projection – we encourage you to bring your laptop equipped with Excel 2013 or newer. Program focuses on Excel for Windows, but many of the features can be found in Excel for Mac.
What People are Saying
More Courses
Looking for Other Excel-Focused Learning Options?
Consider the Following Seminars Available from K2 Enterprises
K2's Advanced Excel
K2's Advanced Excel
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2's Advanced Excel Data Magic - Managing, Analyzing, and Reporting
K2's Advanced Excel Data Magic - Managing, Analyzing, and Reporting
Accounting (8 Credits)
K2's Advanced Excel Reporting - Best Practices, Tools, & Techniques
K2's Advanced Excel Reporting - Best Practices, Tools, & Techniques
Accounting (4 Credits)
K2's Budgeting and Forecasting Tools and Techniques
K2's Budgeting and Forecasting Tools and Techniques
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Excel Best Practices
K2’s Excel Best Practices
Computer Software and Applications (8 Credits)
K2's Excel Financial Reporting and Analysis
K2's Excel Financial Reporting and Analysis
Accounting (8 Credits)
K2’s Excel PivotTables for Accountants
K2’s Excel PivotTables for Accountants
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Excel Tips, Tricks, and Techniques for Accountants
K2’s Excel Tips, Tricks, and Techniques for Accountants
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Excel Charting and Visualizations
K2’s Excel Charting and Visualizations
Computer Software and Applications (4 Credits)
K2’s Introduction to Excel Macros
K2’s Introduction to Excel Macros
Computer Software and Applications (4 Credits)
K2’s Testing and Auditing Excel Workbooks
K2’s Testing and Auditing Excel Workbooks
Information Technology (4 Credits)