Office Excel Tutorials - Microsoft Excel Training
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
1 Day
-
Start date
Different dates available
Delegate pack consisting of course notes and exercises Manual Experienced Instructor Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Excel
- IT
- Office IT
- Microsoft Excel
- Writing
- Ms Office
- Microsoft excel training
- MS Excel
Course programme
Introduction
This 1 day course offers delegates a more advanced look at Excel 2010. Delegates will learn more advanced writing functions, keyboard commands and shortcuts. This course will teach delegates how to get more out of their data by using analysis functions.
Pre-Requisites
- Delegates should have good knowledge of Microsoft Windows, Excel 2010 as well as an understanding of basic functions like Sum and Average.
Who should attend?
- This course is suitable for delegates who need to make the most out of their data and may work in areas such as finance, statistics, project analysis, market analysis or data manipulation.
What will you learn?
- Once you have completed the Advanced Function Writing for Microsoft Excel 2010 course you will understand:
- How to control text values
- How to manage date and time functions
- How to use the Aggregate function for conditional formatting
- How to use the look up function
- How to use the reference function
- How to use nested and array combined functions
- How to use IF and other functions
Course Outline
- IF Functions
- Array Functions
- Aggregate Functions
- Date and Time Functions
- Rounding Numbers
- Compatibility guide
- Look up and reference functions
- Function writing
Additional information
- COURSE BULLET LIST
- Gain an understanding of how to use the reference function
- Learn the key to function writing
- Develop knowledge of IF Functions
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Courses delivered by world class training instructors
- Training provided in luxury venues
- Includes material and manuals
- Book Online or Call 01344 203999 to speak to a training advisor today
Office Excel Tutorials - Microsoft Excel Training