Are you using Ms Excel at a professional level? Too many people are struggling with their workload because they don't know the correct use of Excel. You can do a lot in Excel armed with the AutoSum and Copy/Paste when your spreadsheets are simple. But when you have to work with many sheets and workbooks and turn raw data into information that is simply not enough.
Do you have to:
- produce statistics
- monthly/quarterly/yearly reports and charts
- find figures in huge spreadsheets quickly
- see and manipulate the relationships between different parts of your data quickly
- consolidate data from different sources into one file?
or
Are you:
- setting up multi-sheet workbooks using copy and paste endlessly
- struggling to understand how formulas are put together
- needing help to understand Excel's Help function
- doing the same tedious jobs over and over again
- working late into the night or weekends just to get your work done?
If you answered yes to any of the above questions then you need to do our special 2-day or 3 mornings Ms Excel Professional Course.
This course will teach you:
- shortcuts and easy ways to work in Excel to make daily tasks quicker
- how to put meaningful formulas together
- how to use functions in powerful ways
- how to create charts, trendlines and use secondary axes in charts
- how to consolidate your data
- how to filter your data and extract sub-totals
- how to extract information from data
- how to link worksheets and workbooks together
- how to create pivot tables
- how to create macros to automate tedious tasks
Course details:
How long?
2 days or 3 mornings
Where?
On-site at your premises
Who should attend?
Managers, financial staff, personal assistants, staff whose job description requires them to work with figures every day.
Prerequisites
A basic knowledge of Ms Excel that you use on a daily basis.
Versions?
Available in Ms Excel 2003, 2007 and 2010
Cost?
contact us for details
