Advanced Excel 2007

Take your excel skills to the next level and learn useful functionality in this software. | taught by Lisa Newton

Course 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.

Lisa Newton
Lisa Newton
Serial author and entrepreneur
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, software, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007 and in 2008 Enterprising Business Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award.

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 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 and cosmic ordering.

Lisa Newton course tutor can be contacted at [email protected] or send a skype message to: lisa.boogles

Lisa is on various social media platforms - twitter: @lisa_newton1, or via facebook fanpage: https://www.facebook.com/Lisa-Newton-1744027392375...

Course Curriculum

New Chapter
1:08:23
1 Intro video - same
Downloadable template files
2 Goal Seek
3 Creating a Chart
4 Mortgage Loan Analysis
5 Interest Rate
6 One Input Data Table
7 Two Input Data Table
8 Using Pivot Tables
9 Changing Layout of Pivot Table
10 Filtering Fields
11 Format Report
12 Creating a Chart From A Pivot Table
13 Extended Graphics
14 Combi Charts
15 Final Words
Hide Content