Advanced Excel 2007
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Excel 2007 to your Wishlist.

Add to Wishlist

Advanced Excel 2007

Take your excel skills to the next level and learn useful functionality in this software.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Created by Lisa Newton
Last updated 7/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Use Goal Seek and "What if" Analysis
Create and use Data Tables
Create and use Pivot Tables
Extended Graphics
View Curriculum
Requirements
  • 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.
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.

Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 15 Lectures Collapse All 15 Lectures 01:08:15
+
Introduction
1 Lecture 02:51
+
Goal Seek
6 Lectures 24:40

Creating A Chart
04:23

Loan Mortgage Analysis
02:05


Projecting figures using a Data Table
04:13

Two Input Data Table
04:41
+
Pivot Tables
5 Lectures 25:41
Using Pivot Tables
09:38

Changing the Layout of a Pivot Table
01:53

Filtering Fields
02:15

Format Report
05:51

Creating a Chart from a Pivot Table
06:04
+
Extended Graphics
2 Lectures 14:00
Extended Graphics
04:54

Combination Charts
09:06
+
Final words
1 Lecture 01:03

This spreadsheet has the final result.

Answers - final spreadsheet
01:03
About the Instructor
Lisa Newton
4.0 Average rating
202 Reviews
3,143 Students
80 Courses
Entrepreneur & Serial Author

Lisa Newton BA MSc FMAAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing. She formed her first company in 2004 with £150 in the same month of graduating from City University, London UK. Lisa has never had a full time 9 to 5 job in her life. She's a serial entrepreneur and author who holds directorships in various industries including telecoms, property management, publishing, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007, in 2008 Enterprising Business Award, in 2016 BE Mogul Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award. In 2015 and 2017 one of her companies won Best Bookkeeping Business London (Accountancy International Awards).

Lisa's books include: How to write a book in two weeks, Constant Cashflow, Make the most of your money, How to start your own bookkeeping business, Cosmic ordering with Vision Boards, How to Franchise Your Business and Quickbooks Online The Handbook. Some of the books are in audio-format on itunes and audible.

Lisa supports the charity The MS Society. A speaker, coach, consultant and an avid networker, Lisa enjoys meeting people and working on projects with like-minded individuals.

In her spare time, Lisa likes traveling, dancing salsa, writing books, learning languages, meditation, yoga and cosmic ordering.