on-demand course

Advanced Microsoft Excel 2013

with Guy Vaccaro

January 2013

Intermediate

9h 54m

English

Infinite Skills

Closed Captioning available in German, English, Spanish, French, Italian, Japanese

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Will I Be Able To Keep Up?
3m 57s
Using The Included Files
1m 17s
New For 2013: Its All In The Cloud
4m 3s
The Very Clever Flash Fill
4m 13s
The Basic SUM, COUNT, MIN, And MAX
3m 40s
AVERAGE, MODE, MEAN, And MEDIAN
4m 4s
SUMIF For Selective Adding Up
6m 30s
COUNTIF For Selective Counting
3m 18s
AVERAGEIF For The Mean Of Selected Cells
3m 30s
Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
7m 6s
Area And Volume Calculations
4m 9s
IF Syntax And Uses
7m 55s
Nesting The IF Statement
7m 27s
Use Of The AND Operator Within An IF
6m 30s
Use Of The OR Operator Within An IF
4m 4s
The NOT Operator Within AND And OR Statements
4m 28s
Display Cell Formulas In Another Cell
4m 11s
VLOOKUP: Syntax And Usage
4m 52s
VLOOKUP In Live Action
6m 53s
HLOOKUP: Variation On A Theme
4m 42s
Using A Near Match In The Lookup
3m 44s
Dealing With Missing Data In A Lookup
4m 56s
Managing The Lookup Table
5m 3s
Lookups Nested Within Lookups
6m 29s
Creating A Sparkline
4m 59s
Altering The Design Of Sparklines
4m 26s
Dealing With Empty Cells
2m 25s
Comparing Sparklines Within A Sparkline Group
4m 19s
Removing Sparklines From A Worksheet
2m 14s
Working With Time In Excel
10m 21s
Calculations Using Time
3m 59s
Useful Time And Date Functions
4m 45s
Rounding Decimal Places
4m 32s
MOD And INT Functions And Uses
4m 43s
Generate And Use A Random Number
5m 37s
Loan And Investment Calculations
5m 59s
Loan Calculation Elements And Functions
4m 4s
Create An Outline Automatically
3m 47s
Adding An Outline Manually
3m 22s
Editing And Removing Outlining
6m 39s
Setting Up A Set Of Scenarios
6m 59s
Displaying And Editing The Different Scenarios
3m 12s
How To Work Out Which Scenario You Are Displaying
4m 6s
Merging And Deleting Scenarios
3m 42s
Producing A Summary Of Scenarios
3m 52s
Custom Views Explained
3m 3s
Use Of Outlining To Help Setup Custom Views
3m 57s
Editing And Deleting Custom Views
4m 25s
Add Quick Access To Custom Views
3m 31s
LEFT And RIGHT: Text Manipulation
4m 28s
LEN And TRIM: String Extractions
6m 35s
FIND And MID: Text Functions Working Together
6m 53s
CONCATENATE: Building Strings From Multiple Cells
5m 24s
Changing Case Functions
4m 3s
REPLACE And SUBSTITUTE: Two More String Manipulation Functions
4m 43s
Use Of CHAR Function For More Obscure Characters
6m 12s
Formatting Numeric And Date Values Using TEXT
5m 1s
Keeping The Values Created By String Manipulation
3m 22s

Content preview from Advanced Microsoft Excel 2013

LEN And TRIM: String Extractions

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Microsoft Excel 2013

Guy Vaccaro

Microsoft Excel Advanced 2019

Simon Sez IT

Learning Microsoft Excel 2016

Guy Vaccaro

Microsoft Excel Beginners 2019

Simon Sez IT

Publisher Resources

ISBN: 9781771370646Supplemental Content

Advanced Microsoft Excel 2013

with Guy Vaccaro

Getting Started

Using Mathematical Functions

IF Functionality

Performing Data Lookups

Sparklines

Further Mathematical Functions

Outlining

Scenarios

Custom Views

Functions For Manipulating Text

Arrays

Useful Data Functions

Some Other Useful Functions

Auditing And Troubleshooting Formulas

PivotTables

PivotCharts

Goal Seek And Solver

Macros

Summary And Credits

Content preview from Advanced Microsoft Excel 2013

LEN And TRIM: String Extractions

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.