K2's Excel Boot Camp

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.

k2-excel-boot-camp-skills-header

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:

k2-excel-boot-camp-learning-objectives-header

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

Learn how to become more efficient and proficient in Excel.

K2's Advanced Excel

8 CPE Credits:
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
View Course

K2's Advanced Excel Data Magic - Managing, Analyzing, and Reporting

Learn about the importance of creating Data Models to facilitate your financial reporting processes and how you can use Power Pivot to assist in summarizing your data quickly and easily into compelling and interactive statements.

K2's Advanced Excel Data Magic - Managing, Analyzing, and Reporting

8 CPE Credits:
Accounting (8 Credits)
View Course

K2's Advanced Excel Reporting - Best Practices, Tools, & Techniques

Learn how to connect Excel to external data sources, such as your accounting software database, to extract data for reporting and analysis. Additionally, you will learn how to incorporate PivotTables into your reporting routines.

K2's Advanced Excel Reporting - Best Practices, Tools, & Techniques

4 CPE Credits:
Accounting (4 Credits)
View Course

K2's Budgeting and Forecasting Tools and Techniques

Learn how to achieve a greater return on your budgeting and forecasting investment by taking advantage of various tools and techniques available in today’s market.

K2's Budgeting and Forecasting Tools and Techniques

8 CPE Credits:
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
View Course

K2’s Excel Best Practices

Gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets.

K2’s Excel Best Practices

8 CPE Credits:
Computer Software and Applications (8 Credits)
View Course

K2's Excel Financial Reporting and Analysis

Learn options for consolidating financial data from multiple sources, how to create Excel visualizations to improve reader's comprehension of financial information, and more.

K2's Excel Financial Reporting and Analysis

8 CPE Credits:
Accounting (8 Credits)
View Course

K2’s Excel PivotTables for Accountants

Learn how to build PivotTables, how to group data inside PivotTables, and how to create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques.

K2’s Excel PivotTables for Accountants

8 CPE Credits:
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
View Course

K2’s Excel Tips, Tricks, and Techniques for Accountants

Excel is the accountant’s tool of choice for analyzing and reporting financial data. Learn countless ways to improve your utilization of Excel.

K2’s Excel Tips, Tricks, and Techniques for Accountants

8 CPE Credits:
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
View Course

K2’s Excel Charting and Visualizations

Learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting.

K2’s Excel Charting and Visualizations

4 CPE Credits:
Computer Software and Applications (4 Credits)
View Course

K2’s Introduction to Excel Macros

Learn how to use Excel’s Macro Recorder to write simple, yet effective, macros; how to secure and share macros with other Excel users, how to create user-defined functions to solve specific accountant-centric problems in Excel, and many more.

K2’s Introduction to Excel Macros

4 CPE Credits:
Computer Software and Applications (4 Credits)
View Course

K2’s Testing and Auditing Excel Workbooks

Learn how to apply best practices to reduce the error rate in workbooks that you and others on your team create and edit.

K2’s Testing and Auditing Excel Workbooks

4 CPE Credits:
Information Technology (4 Credits)
View Course
Facebook
Twitter
LinkedIn