Microsoft Excel: 3 Time-Saving Automation Tips & Tricks; AutoComplete, AutoCorrect & AutoCalculate

Microsoft Excel: 3 Time-Saving Automation Tips & Tricks; AutoComplete, AutoCorrect & AutoCalculate

Microsoft Excel Tips, Training, and Software Productivity Lessons from For more time-saving tips for Excel and other top software programs, join our free monthly software tips newsletter at AND get access to valuable keyboard shortcuts handouts.
How can you save time by automating your work in Microsoft Excel? In this training, find out how to take advantage of 3 key automation tricks in Microsoft Excel: AutoComplete, AutoCorrect, and AutoCalculate. These Excel tips and shortcuts help make it faster and easier to add data and to quickly audit and calculate numbers in Excel. AutoComplete is a fast way to repeat data entry in a column of text or numbers. AutoCorrect not only helps correct spelling errors in an Excel worksheet but it’s also a handy way to create your own fast shorthand for commonly typed text. And AutoCalculate is a simple way to check a variety of calculations including totals, averages, and counts. (Clickable chapter links provided below)
These time-saving tricks are supported by Microsoft Excel 365, Excel 2019, Excel 2016, and Excel 2013. Discover more Microsoft Excel lessons and download a free Excel keyboard shortcuts handout at Software Productivity is Only a Click Away! ™
#ExcelTips #Productivity #Excel

Video Chapters:
0:00 Introduction
0:25 Tip 1-AutoComplete
1:20 AutoComplete shortcuts to display lists
2:06 Tip 2-AutoCorrect
2:55 Customizing AutoCorrect
4:55 Tip 3-AutoCalculate
6:00 Closing

About Your Instructor:
Dawn Bjork, MCT, MOSM, is The Software Pro® with 25+ years’ experience as a tech translator and problem solver.
A professional speaker, Microsoft Certified Trainer, computer consultant, software training author, and business owner, Dawn simplifies complex processes with an informative, fun, and entertaining approach and delivers valuable content you can use immediately. Dawn has helped more than 100,000 individuals from Fortune 500 companies, government, education, and other organizations to learn smart, easy, and productive ways to use software and technology more effectively.
Microsoft has awarded Dawn with the certifications of Microsoft Certified Trainer (MCT), Microsoft Office Specialist Master (MOSM), and Microsoft Excel Expert as well as individual certifications in Microsoft Windows, Word, PowerPoint, Outlook, Access, and OneNote. Would you like virtual training for your team? in addition to 30+ Microsoft certifications, to help you and your organization feel confident you will have a positive virtual experience, Dawn has earned a Certified Virtual Presenter (CVP) certification. Whether it’s a conference education session or internal training program, the CVP certification verifies she has the technology, environment, and skill to deliver a professional, collaborative, and engaging presentation.
A software and productivity speaker for conferences and meetings, Dawn is a Past President of the National Speakers Association-Colorado, the largest chapter in the country. Dawn is based in Denver, Colorado, and travels nationally in the United States as well as globally. Stop wasting time and effort trying to figure out software problems on your own!
Are you looking for Excel training in Denver, Colorado? Dawn delivers customized Microsoft Excel training classes (virtual or in-person) in the Rocky Mountain Region (Colorado, New Mexico, Wyoming, Utah, Arizona) as well as across the United States and Canada. Each of these Excel skills topics can be customized for on-site training classes and workshops, virtual learning, webinars, remote training, or conference breakout sessions. Virtual Microsoft Excel training can be delivered globally for your corporation, association, or agency. Are you planning a meeting or conference? Dawn is also a conference speaker for technology education tracks and breakout sessions on specialized Excel topics (tips and tricks, PivotTables, formulas and functions, linking and sharing workbooks, charts and graphics, and more) as well as other Microsoft Office and Adobe Acrobat skills. All Excel software sessions are designed to fit the industry and needs of conference participants. Contact Dawn at (303) 699-6868 or to find out how you can add Microsoft Excel training to increase productivity by leveraging technology and software skills.
More Software Tips, Techniques, Tricks, and Shortcuts:
But Wait, There’s More! Do you want more time-saving software tips, tricks, and techniques? Subscribe to our free monthly software tips newsletter at AND get access to valuable handouts with 477+ keyboard shortcuts for your top software programs including Microsoft Office, Microsoft Excel, Microsoft Outlook, Microsoft Word, Microsoft PowerPoint, Microsoft Teams, Microsoft OneNote, Microsoft Access, Microsoft Windows, and Adobe Acrobat.

Leave a Reply

Close Menu