Categories Pricing Corporate
Professional eBook

193 Reviews
(193 ratings)
4 Reviews
178
Language:  English
This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.
Description
Content
Reviews

This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.

You will learn how to:

• Use Conditional Logic in a formula – IF statements
• Use the SumIF and CountIF functions
• Produce a chart
• Sort and filter
• Apply subtotals
• Introduction to Pivot Tables
• Introduction to Macros
1. Apply Conditional Logic in formula
1. IF Function (IF Statement)
2. Nested IF Function
3. COUNTIF Function
4. SUMIF Function
2. Create and apply Range Names
1. Defining a Named Cell or Range of Cells
2. Using a Named Cell in a formula
3. Naming a range of cells
4. Editing and renaming a named range
5. Define a Name Using the Dialogue Box
6. Sum a range
3. Charts
1. Using Quick Analysis
2. Recommended Charts
3. Creating charts with the keyboard
4. Creating line charts
5. Creating and editing a column chart
6. Creating pie charts
7. Modifying charts using the Ribbon
8. Modifying charts using icons
9. Formatting charts – Task Pane
4. Apply and manipulate illustrations
1. Pictures in Excel
2. Resize the picture – dragging
3. Modify a picture
4. Reset a picture
5. SmartArt
1. SmartArt
6. Shapes
1. Inserting shapes into a workbook
7. Screenshots
1. Inserting a screenshot
9. Sorting data
1. Databases in Excel – introduction
2. Sort data
3. Sort on font colour
4. Sort on cell colour
5. Sort on cell icon
10. Filtering data
1. Filter data – the filter icon
2. Filter on text
3. Filter on more than one column
4. Remove the filter
5. Filter data on colour
6. Text filters
7. Number filters
8. Date filters
11. Format as table
1. What is format as table
2. Format as table icon
3. Insert a table
4. Change table style
5. Remove formatting
6. Name the table
7. Calculated columns
9. Convert back to a range (remove automatic functionality)
12. Filter a table
1. Filter a table
2. Filter a table with a total row
3. Insert a slicer
4. Customize a slicer
5. Delete a slicer
13. Grouping and outlining
1. Outlining
2. Create an automatic outline
14. Subtotals
1. Why use subtotals?
2. Sort first
3. Subtotals command
4. Remove subtotals
15. Apply conditional formatting
1. Conditional formatting
2. Top and bottom rules
3. Data bars
4. Colour scales
5. Icon sets
6. Clear rules
7. Use a formula to control conditional formatting
16. Sparkline charts
1. Sparkline line chart
2. Column spark lines
3. Creating a win/loss spark line chart
4. Remove a spark line chart
17. Text functions
1. Text functions – an introduction
2. Concatenate
3. Trim
4. Upper
5. Lower
6. Proper
7. Right
8. Left
9. Mid
18. Quick analysis
1. Quick analysis
2. Quick analysis Formatting
3. Quick analysis totals
4. Quick analysis Charts
5. Quick analysis Tables
6. Quick analysis sparklines
19. Macros
1. What is a Mmcro
2. Macro security
4. Get set and go
5. Run the macro
20. Index
This is the best book to learn all the features of excel.
This book is very useful.
Awesome! This book is resourceful.
The most comprehensive book on excel that's on the web for free. It covers most of the advanced skills that you need for business. I really enjoyed the macros section and I know that would've been really useful if I had that information in previous jobs. It really lays it out clearly.

Shelley Fishel

Shelley Fishel is the owner and founder of tomorrow's VA - an online training portal with courses in Microsoft Office. Shelley has been teaching Microsoft Office for over 20 years both in the classroom and online. A Fellow of the Learning and Performance Institute, Shelley holds the Certified Online Learning Facilitator - COLF qualification and the Certified Designer of Online Learning - CDOL both from The Learning and Performance Institute.

Prior to setting up tomorrow's VA , Shelley ran The IT Training Surgery, a face to face training company which she sold in January 2019.

With several titles on Bookboon, Shelley spends time learning new features of each release of Office and creating training courses and books.

Shelley loves to simplify a process and help her students become more productive when using Microsoft Office.

You can find Shelley's courses at https://tomorrowsva.com and follow her blog there  - a weekly tip on Microsoft Office.

Follow Shelley on Social Media