Hidden shortcuts and techniques that save time and improve productivity.
Just some of the things you’ll learn:
● Mouse productivity techniques
● Keyboard productivity techniques
● Control key productivity shortcuts
● Shift key productivity shortcuts
● Alt key productivity shortcuts
● Range name enhancements
● Chart tips and tricks
● Custom lists that save you time
● Clever conditional formatting
● Find / Replace tips
● Grouping to improve readability
● Comments to improve usability
● How to improve your toolbars … and much more!
Duration Learning Credits
2 days -16 hours of 16 PDU’s
Session
Public Classroom Pricing:
Early Bird Price: USD 595.00
Regular Price: USD 795.00
Instructor-Led Virtual Live Pricing:
Early Bird Price: USD 495.00
Regular Price: USD 695.00
Private Group / In-House Learning:
Have a group of 3 or more people? Register
yourself with a special pricing and request
the training exclusively for your group.
Hot Selling Course
Useful techniques and keyboard shortcuts
● Navigating large sets of data
● Control key
● Shift key
● Alt key
● Mouse buttons
Custom Lists & Auto-Correct
● Creation
● Techniques for improving efficiency
Paste-Special
● Often overlooked functionality
Finding & Replacing with a twist
● Highlighting additional functionality that most people aren’t aware of
Data Validation
● Using validation lists to control inputs
● Creating dynamic range names
Printing
● Tips to assist setting up printing
● Repeating headings, printing comments
Protecting your Work
● Restricting user input and user access to your sheets and files.
Grouping
● How to include both summary and detail information on one sheet plus demonstrate benefits of avoiding hiding rows.
Charting
● Best practices for designing and working with charts
Tables and Databases
● Sorting techniques
● Using Autofilter to show top 10 or custom views of the database
● Flagging and removing duplicate entries
Pivot Tables
● Create your own dashboard using pivot tables and pivot charts
● Value and Date grouping functionality
● Top 10 filters
● Traps to avoid
● Present your summarised data in an easy to interpret manner
● Useful Excel functionality in the most recent versions
Related Courses
High-Powered Excel for Finance (1 day)
Excel Data Analysis in Finance (1 day)
● All Excel users. Especially those people interested in the best techniques for manipulating and handling data.
● Learn the hidden productivity tools that are used by Excel Experts to get more done at the same time.
● Make your charts fly: creating new charts, improving existing ones, and making them all look superb!
● Clever range name techniques that improve reliability and readability.
● Best practices in formulas and formatting that help improve both speed and accuracy.
● Ways to quickly navigate large spreadsheets and find what you need to know.
● Ways to speed up data entry.