Microsoft Excel 2016 Intermediate Level 2

Teacher

Sarah

Categories

IT & Software, Microsoft, Popular

Review

(0 review)

Free

Outlining 8
- Lecture1.1
  
  What is outlining?
- Lecture1.2
  
  Identifying groups of data
- Lecture1.3
  
  Identifying summary vs detail rows and columns
- Lecture1.4
  
  Using Auto Outline – Part 1
- Lecture1.5
  
  Using Auto Outline – Part 2
- Lecture1.6
  
  Manually outlining – Part 1
- Lecture1.7
  
  Manually outlining – Part 2
- Lecture1.8
  
  Manually outlining – Part 3
Subtotaling 8
- Lecture2.1
  
  Introduction to subtotaling
- Lecture2.2
  
  Activating subtotals
- Lecture2.3
  
  Removing subtotals
- Lecture2.4
  
  Creating multiple subtotal rows
- Lecture2.5
  
  Creating subtotal rows for groups within a group
- Lecture2.6
  
  Inserting subtotals above each group
- Lecture2.7
  
  Copying and pasting only subtotal rows
- Lecture2.8
  
  Formatting only subtotal rows
Charts 21
- Lecture3.1
  
  Introduction to charts
- Lecture3.2
  
  Chart terminology – Part 1
- Lecture3.3
  
  Chart terminology – Part 2
- Lecture3.4
  
  Setting up your data for a chart
- Lecture3.5
  
  Creating a chart
- Lecture3.6
  
  Moving a chart
- Lecture3.7
  
  Switching the data series and categories
- Lecture3.8
  
  Changing the chart type
- Lecture3.9
  
  Applying a quick layout
- Lecture3.10
  
  Modifying chart elements
- Lecture3.11
  
  Applying a chart style and changing colors
- Lecture3.12
  
  Using themes – Part 1
- Lecture3.13
  
  Using themes – Part 2
- Lecture3.14
  
  Using themes – Part 3
- Lecture3.15
  
  Using themes – Part 4
- Lecture3.16
  
  Using themes – Part 5
- Lecture3.17
  
  Changing the source data
- Lecture3.18
  
  Showing or hiding the data series and categories
- Lecture3.19
  
  Useful shortcut buttons
- Lecture3.20
  
  The Format pane for elements
- Lecture3.21
  
  Popular changes to chart elements
Sparklines 12
- Lecture4.1
  
  Introduction to sparklines
- Lecture4.2
  
  Creating sparklines
- Lecture4.3
  
  Switching row/column chart type
- Lecture4.4
  
  Showing value points
- Lecture4.5
  
  Changing styles and colors
- Lecture4.6
  
  Showing the horizontal axis
- Lecture4.7
  
  Plotting data in the opposite direction
- Lecture4.8
  
  Using the date axis
- Lecture4.9
  
  Changing the minimum value on the vertical axis
- Lecture4.10
  
  Changing the maximum value on the vertical axis
- Lecture4.11
  
  Handling empty cells
- Lecture4.12
  
  Grouping and ungrouping sparklines
Formulas and Functions 12
- Lecture5.1
  
  A thorough refresher
- Lecture5.2
  
  Refresher on function syntax
- Lecture5.3
  
  Relative vs absolute cell referencing
- Lecture5.4
  
  Using Auto Fill to fill down
- Lecture5.5
  
  Using Auto Fill to fill across
- Lecture5.6
  
  AVERAGE function
- Lecture5.7
  
  COUNT Function
- Lecture5.8
  
  MAX function
- Lecture5.9
  
  MIN function
- Lecture5.10
  
  Using Auto for the AVERAGE, COUNT, MAX, and MIN functions
- Lecture5.11
  
  COUNTA function
- Lecture5.12
  
  Viewing the totals in the status bar
IF, AND, OR Functions 13
- Lecture6.1
  
  Introduction to the IF function
- Lecture6.2
  
  Syntax of the IF function
- Lecture6.3
  
  Logical comparison argument
- Lecture6.4
  
  Technically speaking on the logical comparison argument
- Lecture6.5
  
  The valueiftrue and valueiffalse arguments
- Lecture6.6
  
  Using the IF function – Example 1
- Lecture6.7
  
  Using the IF function – Example 2
- Lecture6.8
  
  Using the IF function – Example 3
- Lecture6.9
  
  Using the IF function – Example 4
- Lecture6.10
  
  Smarter data setup – Part 1
- Lecture6.11
  
  Smarter data setup – Part 2
- Lecture6.12
  
  AND function
- Lecture6.13
  
  OR function
Nested Functions (aka Nested Statements) 6
- Lecture7.1
  
  Introduction to nested functions
- Lecture7.2
  
  Nesting an OR function within an IF function – Part 1
- Lecture7.3
  
  Nesting an OR function within an IF function – Part 2
- Lecture7.4
  
  Nesting an OR function within an IF function – Part 3
- Lecture7.5
  
  Nesting an OR function within an IF function – Part 4
- Lecture7.6
  
  Nesting an OR function within an IF function – Part 5

Sarah

Sarah has been teaching for over two decades in all areas spanning IT with a particular focus on data management and business intelligence. She is one of the most demanded instructors in the nation, and is reputed for her ability to share her deep knowledge in a clear, thorough, and engaging format. We promise you'll love her videos which students have evaluated as some of the best ones online!