CPE Course Excel Boot Camp for Accountants

June 20, 2018

12:45pm — 4:30pm

Location Manchester

Member Price $129.50Register after May 30 and pay $139.50
Non-member Price $179.50Register after May 30 and pay $189.50

Curriculum Other

Field of Interest Computer Training, Other

Level Advanced

Designed For

Accountants who utilize Excel

Objective

After completing this class, you will have the skills to:
• Create complex spreadsheets quicker and more accurately
• Learn Advanced skills to build complex formulas
• Apply techniques to troubleshoot complex formulas

Highlights

• Build Complex Formulas quickly and easily with Excel’s Formula and Function tools
• What's in a Name? - use Range Names for easy Cell Referencing
• Reformat data with TEXT functions
• Use DATE functions in calculations and Data Analysis
• Calculate and Summarize data with the SUMIF and SUBTOTAL functions
• Perform Advanced data retrieval with Excel’s powerful LOOKUP and INDEX & MATCH functions
• Test conditions with the LOGICAL functions (IF, AND, OR, NOT)
• Learn the Art of Nesting formulas and Troubleshooting Complex formulas
• Discover Excel’s Error-Checking functions to ensure error free spreadsheets
• Track Changing Cells with the Watch window
Includes a review of best-formula building practices and new functions introduced in Excel 2013 and 2016.

Instructors

Marie McCooey

I’m Marie McCooey, better known as the Software Trainer™. I help organizations become more productive, simply by delivering the best Microsoft Office training available anywhere.I’ve been training for over 20 years, and I still get excited when a workshop attendee has one of those “aha” moments! See, these tips and techniques are more than just shortcuts. They’re a way to maximize your productivity and make you more of an asset to your organization.That’s why I’m passionate about what I do.I love helping people! I love sharing things with people, and I love training and teaching.I didn’t actually set out to be a trainer. I had just finished my MBA at Bryant University when my professor asked if I could teach her class while she took a sabbatical. I said “yes,” and over time developed my own curriculum and specialized training. Over 10,000 students later, I’m still going strong and excited to impact the bottom line for individuals and companies every day.Today I’m a Microsoft Certified Trainer (MCT) providing training in Microsoft Office applications, including Excel, Word, PowerPoint, Access, and Visio. I help people in Fortune 100 companies, small businesses, and universities become more productive, more efficient, and less frazzled, simply by learning, remembering, and implementing these powerful (and rarely taught) Microsoft Office tips.Whether you’re “technologically challenged,” an advanced user, or somewhere in between, chances are I’ll help you get more done in less time. I’m able to convey complex information in a manner that’s easy to understand, and help you apply it immediately.One last thing you should know – learning Microsoft Office inside and out is actually quite fun! Yes, I know the material could seem dry, but people who come to my training are surprised at how engaging and lively it is, and you will, too. During our time together in the training, I’ll give you practical, useable, easy-to-retain tips and tools that will make you a rock star of productivity back in the office.close

Prerequisites

Intermediate knowledge of Excel

Developer

The Software Trainer

Back to Course List Add to Cart View Cart