Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
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.
Microsoft improved Excel significantly in versions 2007, 2010, 2013, and 2016. Additions to the function library, Tables, a greatly improved charting engine, and an overhaul of PivotTable functionality are just a few of changes you will learn about in Excel Boot Camp. In addition, throughout the two-day Excel Boot Camp, you and your team will learn various techniques for enhancing not only your efficiency, but also your effectiveness, when working with Excel. In this seminar, you will learn a wide variety of "power features" that will assist you in creating accurate spreadsheets in a fraction of the time previously required.
Schedule
- September 16, 2024, 8:30 a.m. - 12:30 p.m.
- September 17, 2024, 8:30 a.m. - 12:30 p.m.
- September 23, 2024, 8:30 a.m. - 12:30 p.m.
- September 24, 2024, 8:30 a.m. - 12:30 p.m.
Key Takeaways
Upon completion of this course, you will 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.
- Describe 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 describe various techniques for securing Excel workbooks.
- Create charts in Excel that captivate audiences and communicate messages effectively.
- List and describe the six components of PivotTables and explain how to create simple PivotTables.
- Create PivotTables, including PivotTables that perform calculations other than the predefined eleven calculations available.
- Use the 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 Will Benefit
Accountants who work with Excel and who want to learn all of the best features.
Prerequisite(s)
- Participants should have a fundamental knowledge of Excel 2007 or higher.
- Group-live demo and discussion using color computer projection.
- This course is laptop friendly , so feel free to bring your laptop equipped with Excel 2007 or higher.
- This course will be taught in Windows Excel 2016. Reference will be made to the differences between Excel 2016 and Excel 2013, 2010 and 2007.
How to Access the Course
This course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
Electronic material can be accessed one week prior to the course and should be downloaded in advance.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
K2E Canada Inc, and its US partner K2 Enterprises is the pre-eminent provider of technology-focused continuing professional education to accountants and other professionals in Canada and the United States. We offer seminars on Excel, Word, PowerPoint, Outlook and Access. In addition, our catalogue includes seminars on Internal Controls, Cloud Computing, Tech Tools to Prevent Fraud, Adobe PDF and overviews of current technology for accountants.