PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

Share a file Manage my documents Convert Recover PDF Search Help Contact



free ebook Excel 2010 Advanced .pdf



Original filename: free ebook - Excel 2010 Advanced.pdf

This PDF 1.4 document has been generated by Online2PDF.com, and has been sent on pdf-archive.com on 24/08/2017 at 12:31, from IP address 210.184.x.x. The current document download page has been viewed 273 times.
File size: 11.7 MB (256 pages).
Privacy: public file




Download original PDF file









Document preview


Excel 2010 Advanced 
Stephen Moffat 

Download free books at 

Stephen Moffat, The Mouse Training Company

Excel 2010 Advanced

Download free ebooks at bookboon.com

2

Excel 2010 Advanced

Excel 2010 Advanced
© 2011 Stephen Moffat, The Mouse Training Company & Ventus Publishing ApS
ISBN 978-87-7681-788-6

Download free ebooks at bookboon.com

3

Excel 2010 Advanced

Contents

Contents
1

2

Please click the advert

3

Introduction

7

Advanced worksheet functions

9

Conditional & Logical Functions

10

Counting And Totalling Cells Conditionally

14

And, Or, Not

25

Lookup Functions

31

Views, scenarios, goal seek, solver

39

Goal Seeking And Solving

40

Advanced Solver Features

47

Scenarios

51

Views

59

Using excel to manage lists

64

Excel Lists,List Terminology

64

Sorting Data

65

Subtotals

73

Filtering A List

79

Advanced Filtering

87

Julian Lienich, engineer

I can shape the future. Every day.
The E.ON graduate program requires my energy and creative input. In exchange I get to work with up-to-date
technologies in a team that supports my professional development. What about you?

Your energy shapes the future.
www.eon-career.com

Download free ebooks at bookboon.com

4

Excel 2010 Advanced

4

5

Contents

Criteria Tips

91

Multiple Criteria

93

Calculated Criteria

94

Data Consolidation

102

Pivottables

106

Modifying A Pivottable

117

Managing Pivottables

123

Formatting A Pivottable

130

Banding

131

Slicers

135

Charts

143

Introduction To Charting

143

Creating Charts

145

Formatting Charts

157

Changing The Chart Layout

163

Sparklines

177

Templates

184

Introduction To Templates

185

Create Custom Templates

187

it’s an interesting world

Please click the advert

Get under the skin of it.
Graduate opportunities
Cheltenham | £24,945 + benefits
One of the UK’s intelligence services, GCHQ’s role is two-fold:
to gather and analyse intelligence which helps shape Britain’s
response to global events, and, to provide technical advice for the
protection of Government communication and information systems.
In doing so, our specialists – in IT, internet, engineering, languages,
information assurance, mathematics and intelligence – get well
beneath the surface of global affairs. If you thought the world was
an interesting place, you really ought to explore our world of work.

www.careersinbritishintelligence.co.uk

TOP
GOVERNMENT
EMPLOYER

Applicants must be British citizens. GCHQ values diversity and welcomes applicants from
all sections of the community. We want our workforce to reflect the diversity of our work.

Download free ebooks at bookboon.com

5

6

Please click the advert

7

Contents

Drawing and formatting

194

Inserting, Formatting And Deleting Objects

195

More Formatting

209

Excel tools

227

Reviewing

228

Auditing

245

Proofing Tools

251

You’re full of energy
and ideas. And that’s
just what we are looking for.

© UBS 2010. All rights reserved.

Excel 2010 Advanced

Looking for a career where your ideas could really make a difference? UBS’s
Graduate Programme and internships are a chance for you to experience
for yourself what it’s like to be part of a global team that rewards your input
and believes in succeeding together.
Wherever you are in your academic career, make your future a part of ours
by visiting www.ubs.com/graduates.

www.ubs.com/graduates

Download free ebooks at bookboon.com

6

Excel 2010 Advanced

Introduction

Introduction
Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs.
These can range from simple formulae through to complex functions and mathematical models.

How To Use This Guide
This manual should be used as a point of reference after following attendance of the advanced level Excel 2010 training
course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course.
The manual is divided into sections, each section covering an aspect of the advanced course. The table of contents lists
the page numbers of each section and the table of figures indicates the pages containing tables and diagrams.

Objectives
Sections begin with a list of objectives each with its own check box so that you can mark off those topics that you are
familiar with following the training.

Instructions
Those who have already used a spreadsheet before may not need to read explanations on what each command does, but
would rather skip straight to the instructions to find out how to do it. Look out for the arrow icon which precedes a list
of instructions.

Appendices
The Appendices list the Ribbons mentioned within the manual with a breakdown of their functions and tables of shortcut
keys.
Keyboard
Keys are referred to throughout the manual in the following way:
[ENTER] – Denotes the return or enter key, [DELETE] – denotes the Delete key and so on.
Where a command requires two keys to be pressed, the manual displays this as follows:
[CTRL] + [P] – this means press the letter “p” while holding down the Control key.
Commands
When a command is referred to in the manual, the following distinctions have been made:

Download free ebooks at bookboon.com

7

Excel 2010 Advanced

Introduction

When Ribbon commands are referred to, the manual will refer you to the Ribbon – E.g. “Choose home from the Ribbons
the group name – FONT group and then B for bold”.
When dialog box options are referred to, the following style has been used for the text – “In the PAGE RANGE section
of the PRINT dialog, click the CURRENT PAGE option”
Dialog box buttons are shaded and boxed – “Click OK to close the PRINT dialog and launch the print.”
Notes
Within each section, any items that need further explanation or extra attention devoted to them are denoted by shading.
For example:
“Excel will not let you close a file that you have not already saved changes to without prompting you to save.”
Tips
At the end of each section there is a page for you to make notes on and a “Useful Information” heading where you will
find tips and tricks relating to the topics described within the section.

Download free ebooks at bookboon.com

8

Excel 2010 Advanced

Advanced worksheet functions

1 Advanced worksheet functions
By the end of this section you will be able to:
• Understand and use conditional formulae
• Set up LOOKUP tables and use LOOKUP functions
• Use the GOAL SEEK
• Use the SOLVER

Download free ebooks at bookboon.com

9


Related documents


free ebook excel 2010 advanced
advanced excel 2010
advanced excel training courses
a user manual one for all remote
why use excel
buy ebook from here


Related keywords