Study Learn Grow
Advanced Excel

Advanced Excel


We don't want you to spend a day of your life in the classroom... learn 4 useful, practical things which you can apply on your job or on your projects.

Overview

Description
Advanced Excel 2007 is a course aimed at the excel user who is fairly competent on the software but is just looking for a few more handy tips and tricks to really get to know what this software can do. If you are handling data, or have the responsibility for analyzing data or presenting information in a useful format - reports for your team, or managers etc., then this course will be very handy.

We don't want you to spend a day of your life in the classroom... learn 4 useful, practical things which you can apply on your job or on your projects.

1) Goal seek and 'what if' analysis

When working with worksheet models - do you have the answer you want, but must work backward to find the input value that gives you that answer? Goal seek will help you. If you have to analyse scenarios for forecasting - what if X happens, instead of Y? The 'what if' section will help you.

2) Data Tables

Data can be confusing and difficult to interpret or understand if it's not presented in logical format. Data tables can really help.

3) Using Pivot Tables

A pivot table is an interactive worksheet table that quickly summarizes large amounts of data using a format and calculation methods that you may choose yourself.

4) Extended graphics

Analyse the trends that are apparent and create charts to present information clearly for work reports, essays and assignments.

The target audience is those who are at an intermediate level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010.

A booklet with screen shots is given in lecture one, so that you can follow step by step what we do in each lecture. We also provide a spreadsheet with each lecture - for you to practice what was done in that lecture/

The course will take approx 2-3 hours to complete.

Take this course if you want to take your intermediate-level understanding of Excel to an advanced level.


Basic knowledge
Students will need to have Excel 2007 installed, as this is the system used in the teaching
We provide you with a spreadsheet which is pre-populated with data, so that you can try the tasks and activities given in the lecture

Course Information

Students will need to have Excel 2007 installed, as this is the system used in the teaching
We provide you with a spreadsheet which is pre-populated with data, so that you can try the tasks and activities given in the lecture

What will you learn
Use Goal Seek and "What if" Analysis
Create and use Data Tables
Create and use Pivot Tables
Extended Graphics

Who this course is for:

This is for those who already have an intermediate knowledge of Excel and want to take it further - using Excel 2007
This course is not suitable for "beginners" to Excel

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs