Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel.
In this course, you’ll discover a variety of the best time-saving shortcuts, countless tricks, and techniques to reduce the amount of time you spend on routine tasks, such as formatting, learn valuable formula-building skills and tips to boost your productivity.
• Reduce Data Entry time with AutoCorrect
• Discover the Conditional Formatting Formula to Highlight Worksheet Formulas
• Learn how to create Custom lists for Frequently Used Entries
• How to Analyze Data instantly with Excel’s Quick Analysis
• Formatting Essentials to Enhance your Spreadsheets
• A review of Best Formula Building practices
• Debug Formulas with the F9 key
• Learn Charting Fundamentals to present your Data Visually
• Use the Camera tool to create Dynamic Reports from worksheet cell ranges
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
Working knowledge of Excel
The Software Trainer