Microsoft Excel 2016 Intermediate Level 1

Teacher

Sarah

Categories

IT & Software, Microsoft, Popular

Review

(0 review)

Free

Getting started 10
- Lecture1.1
  
  Selecting a data region
- Lecture1.2
  
  Demystifying dates
- Lecture1.3
  
  Creating a custom series
- Lecture1.4
  
  Creating custom date formats
- Lecture1.5
  
  Inserting comments – Part 1
- Lecture1.6
  
  Inserting comments – Part 2
- Lecture1.7
  
  Using Go To Special
- Lecture1.8
  
  Transposing data
- Lecture1.9
  
  Showing formulas
- Lecture1.10
  
  Copying and pasting values of formulas
Naming Cells 15
- Lecture2.1
  
  Introduction to naming cells and ranges
- Lecture2.2
  
  Naming a cell or range using the Name Box
- Lecture2.3
  
  Guidelines on naming a cell or range
- Lecture2.4
  
  Naming a cell or range using the Define Name command
- Lecture2.5
  
  Naming cells automatically using their labels
- Lecture2.6
  
  Managing names using the Name Manager
- Lecture2.7
  
  Using names for navigation
- Lecture2.8
  
  Copying and pasting the names into a worksheet
- Lecture2.9
  
  Using names in formulas – Part 1
- Lecture2.10
  
  Using names in formulas – Part 2
- Lecture2.11
  
  Creating named constants
- Lecture2.12
  
  Names cells and ranges are absolute
- Lecture2.13
  
  Absolute vs relative named cells and ranges
- Lecture2.14
  
  Creating a relative named cell or range – Part 1
- Lecture2.15
  
  Creating a relative named cell or range – Part 2
Linking Data 11
- Lecture3.1
  
  Introduction to linking – Part 1
- Lecture3.2
  
  Introduction to linking – Part 2
- Lecture3.3
  
  Linking data within a sheet – Method 1 (Paste Link)
- Lecture3.4
  
  Linking data within a sheet – Method 2 (Manual)
- Lecture3.5
  
  Linking data between sheets – Method 1 (Paste Link)
- Lecture3.6
  
  Linking data between sheets – Method 2 (Manual)
- Lecture3.7
  
  Linking data between workbooks – Method 1 (Paste Link)
- Lecture3.8
  
  Linking data between workbooks – Method 2 (Manual)
- Lecture3.9
  
  Linking – Tip 1
- Lecture3.10
  
  Linking – Tip 2
- Lecture3.11
  
  Linking – Tip 3
Protecting Data 14
- Lecture4.1
  
  Protecting data in “locked” cells
- Lecture4.2
  
  Turning sheet protection on or off
- Lecture4.3
  
  Unlocking cells – Part 1
- Lecture4.4
  
  Unlocking cells – Part 2
- Lecture4.5
  
  Protecting hidden columns and rows
- Lecture4.6
  
  Hiding formulas
- Lecture4.7
  
  Password protecting cells or ranges
- Lecture4.8
  
  Turning workbook (worksheet structure) protection on or off
- Lecture4.9
  
  Password protecting the file
- Lecture4.10
  
  Applying “Read Only Recommended” to the workbook
- Lecture4.11
  
  Applyng a “Password to Modify” to the workbook
- Lecture4.12
  
  Applying all of the protection options
- Lecture4.13
  
  Does protection really secure my Excel data?
- Lecture4.14
  
  Data entry facilitation using sheet protection
Sorting a List (aka Recordset, Dataset) 11
- Lecture5.1
  
  Introduction to Lists
- Lecture5.2
  
  Guidelines on creating a list
- Lecture5.3
  
  Sorting a list by a number field
- Lecture5.4
  
  Sorting a list by a text field
- Lecture5.5
  
  Sorting a list by a date field
- Lecture5.6
  
  Sorting by a custom list – Part 1
- Lecture5.7
  
  Sorting by a custom list – Part 2
- Lecture5.8
  
  Sorting by a cell color
- Lecture5.9
  
  Sorting by multiple cell colors
- Lecture5.10
  
  Sorting by a font color
- Lecture5.11
  
  Sorting by multiple font colors
AutoFiltering a List 29
- Lecture6.1
  
  Introduction to filtering
- Lecture6.2
  
  Introduction to AutoFilter
- Lecture6.3
  
  Filtering by a field’s unique items
- Lecture6.4
  
  Removing a filter from a field
- Lecture6.5
  
  Filtering by multiple fields’ unique items
- Lecture6.6
  
  Criteria syntax
- Lecture6.7
  
  Comparison operators – Part 1
- Lecture6.8
  
  Comparison operators – Part 2
- Lecture6.9
  
  Single Criterion
- Lecture6.10
  
  Multiple Criterion using the AND operator
- Lecture6.11
  
  Multiple Criterion using the OR operator
- Lecture6.12
  
  Multiple Criterion using a combination of the AND and OR operator
- Lecture6.13
  
  Creating a custom AutoFilter for a text field
- Lecture6.14
  
  Creating a custom AutoFilter for a number field
- Lecture6.15
  
  Creating a custom AutoFilter for a date field
- Lecture6.16
  
  Using the Between option for a number field
- Lecture6.17
  
  Using the Between option for a date field
- Lecture6.18
  
  Creating a custom AutoFilter from scratch
- Lecture6.19
  
  Introduction to the asterisk (*) wildcard character
- Lecture6.20
  
  Introduction to the question mark (?) wildcard character
- Lecture6.21
  
  Introduction to the tilde (~) wildcard character
- Lecture6.22
  
  Some important points about wildcard characters
- Lecture6.23
  
  Creating a custom AutoFilter with an asterisk (*) wildcard character
- Lecture6.24
  
  Creating a custom AutoFilter with multiple asterisk (*) wildcard characters
- Lecture6.25
  
  Creating a custom AutoFilter with multiple question mark (?) wildcard characters
- Lecture6.26
  
  Creating a custom AutoFilter with a tilde (~) wildcard character
- Lecture6.27
  
  Creating a custom AutoFilter using all wildcard characters
- Lecture6.28
  
  AutoFilter limitations – Part 1
- Lecture6.29
  
  AutoFilter limitations – Part 2
Using Advanced Filter on a List 12
- Lecture7.1
  
  Review of the comparison and logical operators
- Lecture7.2
  
  Setting up the criteria range
- Lecture7.3
  
  Using one criterion – Part 1
- Lecture7.4
  
  Using one criterion – Part 2
- Lecture7.5
  
  Using two criteria joined by the AND operator
- Lecture7.6
  
  Using two criteria joined by the OR operator
- Lecture7.7
  
  Using multiple sets of criteria
- Lecture7.8
  
  Using multiple criterion joined by AND under the same field
- Lecture7.9
  
  Using criteria with wild characters
- Lecture7.10
  
  Copying filtered results to another location
- Lecture7.11
  
  Finding unique records only
- Lecture7.12
  
  Entering the “equals to” operator
Using Flash Fill in a List 1
- Lecture8.1
  
  Using Flash Fill

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!