Course Overview:

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!

Target Audience:

• All Excel users. Especially those people interested in the best techniques for manipulating and handling data.

Learning Objectives:

• 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.

There’s also a question and answer time so you can get answers to all those questions that have been bugging you! … plus many many more ways to improve your productivity and reduce your frustration!

Prerequisites:

All Excel users. Especially those people interested in the best techniques for manipulating and handling data.

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

There is no exam for this course.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Agenda:

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)