Maximising your Excel Productivity 1 Day Virtual Training in Townsville

Maximising your Excel Productivity 1 Day Virtual Training in Townsville

Actions and Detail Panel

From A$527.53

Location

Online event

Refund policy

Refunds up to 7 days before event

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning.

About this event

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)

Share with friends