Self-Paced Course
Excel Pro Tips: Productivity
Save time and work more efficiently with Excel’s most powerful productivity tools, including shortcuts, flash fill, named ranges, and more.
Course Description
The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.
In this course, the name of the game is productivity. We'll cover a range of topics to help you save time and work more efficiently, including keyboard shortcuts, autofill & flash fill, data validation, cell protection, named ranges, multi-level sorting, advanced filters, and much more.
It's time to start working smarter, not harder. If you're ready to supercharge your productivity and absolutely revolutionize your Excel workflow, this is the course for you.
COURSE CURRICULUM:
- Course Structure & Outline
- DOWNLOAD: Course Resources
- Setting Expectations
- Introduction
- Customizing the Footer
- CTRL Shortcuts
- ALT Key Tips
- Go To Special Options
- Removing Blank Rows
- Data Validation Drop-Downs
- Autofill & Flash Fill
- Customizing the Ribbon
- Splitting Text to Columns
- Synchronous Scrolling
- Extracting Unique Values
- Named Range & Table References
- Protecting Cells & Formulas
- Multi-Level Row & Column Sorting
- Advanced Filter Criteria
- QUIZ: Productivity Tips
- Course Feedback Survey
- Share the love!
- Next Steps
WHO SHOULD TAKE THIS COURSE?
Excel users who want to save time and work more efficiently
Analysts looking to reduce human error and develop strong productivity habits
Anyone seeking to explore some of Excel's most useful productivity tools & techniques
WHAT ARE THE COURSE REQUIREMENTS?
Microsoft Excel 2007-2019+ or Office 365 for PC/Windows (some demos may be unavailable for Mac or Excel Online)
Familiarity with basic Excel functionality is recommended
Start learning for FREE, no credit card required!
Every subscription includes access to the following course materials
- Interactive Project files
- Downloadable e-books
- Graded quizzes and assessments
- 1-on-1 Expert support
- 100% satisfaction guarantee
- Verified credentials & accredited badges
Ready to become a
data rockstar?
Start learning for free, no credit card required!