NZ$627.12 – NZ$836.32

Maximising your Excel Productivity 1 Day Training in Wellington

Actions and Detail Panel

From NZ$627.12

Event Information

Share this event

Date and Time

Location

Location

Regus - Wellington, ANZ Centre

Level 15, 171 Featherston Street

Wellington, North Island 6011

New Zealand

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description
Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.

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

Date and Time

Location

Regus - Wellington, ANZ Centre

Level 15, 171 Featherston Street

Wellington, North Island 6011

New Zealand

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved