Employers and Manufacturers Association (EMA) Northern - Top 10 Tips for Productivity Using Excel

Top 10 Tips for Productivity Using Excel

This half-day workshop will help you confidently complete your Excel tasks for increased output and productivity.

 COURSE OVERVIEW
This half-day workshop is designed to give you a solid overview of the most ueful functions within Excel, as well as tips and tricks to optimise your everyday use of the applications.

 

RELEVANT TO YOU?
If you want to work faster and smarter on Excel, this is the workshop for you.

 

TOPICS INCLUDE
• Different ways to work faster - quick access toolbar, autosum and shortcut keys.
• Building formulas and using functions like If and Date.
• Paste options.
• Sort and filter; using name manager; choosing flash fill and autofill options.
• Conditional formatting, inserting slicers, removing duplicates.
• Learning how to analyse data with a pivot table.

 

AFTERWARDS, YOU’LL BE ABLE TO...
• Customise the quick access toolbar.
• Use key functions for formulas.
• Understand paste options.
• Sort and filter data.
• Detect and track calculations with formula tools.
• Useful shortcut keys.
• Create, combine, copy and split data.
• Analyse tables of data in Excel.
• Apply conditional formats to highlight key data.
• Add charts to Excel.

 

FACILITATOR
A Fit-for-Business Computer Coach

For any queries contact learnit@ema.co.nz 

Join Us.

Together we're building businesses, communities and opportunities for all
New Zealand

Join Online Now
Download PDF form here
View subscription rates

Related Events & Training

Time Management - Personal Effectiveness
If you feel constantly stressed by your workload and consider yourself time-poor, this workshop will get you back in control. Brush up on your time management skills or send a colleague.
Find out more
Managing Employee Leave
This introductory to intermediate-level workshop is designed for anyone responsible for managing employee leave records. It will equip you to ensure full compliance with current employment legislation, reducing risks to your organisation.
Find out more
Employment Relations Act 2000 and its Amendments
This introductory to intermediate workshop is designed for people new to HR as well as managers, HR advisors and business partners. Certain employer obligations are essential under the Act and this workshop provides the working knowledge you need.
Find out more
Creativity and problem solving - today's differentiator
If you need to be more effective in finding out-of-the-box solutions to problems, this challenging and interactive workshop is just what you need.
Find out more
Leading Disciplinary Meetings
If you are responsible for managing people, an HR Advisor or Business Partner, this practical course is for you. To get the most out of this course, participants should already have a working knowledge of procedural fairness.
Find out more
 
View all Related Events & Training

Related Services

NZ Wage & Salary Solution
No one wants to miss out on a great opportunity. Find out what your offer should be, what the rest of the market is doing, and how to position yourself as the top choice for top talent.
Read full story
Online Learning
EMA Learning (Digital) delivers and facilitates digital and online training anytime, anywhere across multiple platforms.
Read full story
Advocacy Forums: Policy, Employers, Manufacturers
EMA members can be actively involved in advocacy through our Policy, Employer and Manufacturing Forums.
Read full story
AdviceLine
AdviceLine is our front line employment relations service. Available between 8am to 8pm to advise and guide you through your issues to find effective solutions.
Read full story
Employee and Personal Development
Our workshops are specifically designed to boost self-confidence and maximise your potential or the potential of a team member. A crucial part of building better businesses is by investing in the personal development of yourself and your team.
Read full story
 
View all Related Services