Ultimate Excel 2016 Bundle (3-Courses: Intro, Interm & Adv)
4.7 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
28 students enrolled

Ultimate Excel 2016 Bundle (3-Courses: Intro, Interm & Adv)

Everything you need to know about Excel in this bundle with over 200 videos, from beginner to advanced topics!
4.7 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
28 students enrolled
Last updated 6/2019
English
English [Auto-generated]
Current price: $62.99 Original price: $89.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10 hours on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Navigate Excel
  • Create Workbooks and Use Templates
  • Work with Formulas
  • Format worksheet Data
  • Work with Named ranges
  • Use Logical and Lookup functions
  • Filter Data
  • Work with Graphs
  • Using IF Statements
  • Using Worksheet Protection
  • Work with PivotTables
  • Use Macros
  • Collaborate in Excel
Requirements
  • This course is recommended for those who wish to learn an extensive array of topics on Excel 2016, from beginner to advanced.
Description

Over 200 videos are included in this bundle! 

Save 20% by purchasing 3 Excel 2016 courses, which will teach you everything you need to know about the program. This bundle includes:

  • Excel 2016 Introduction
  • Excel 2016 Intermediate
  • Excel 2016 Advanced

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. 

In the Introduction course, you will learn the fundamentals of Excel and the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

In Intermediate course, students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. 

In the Advanced course, students will learn advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Who this course is for:
  • Anyone who is interested in learning Excel. No previous Excel experience is required.
Course content
Expand all 206 lectures 10:04:49
+ Excel 2016 Introduction
67 lectures 03:45:28
What is Excel?
02:01
Opening Excel
04:25
Using the Excel Ribbon
02:55
Understanding Excel Worksheet Components
03:55
Using the Backstage View
02:32
Creating a New Workbook
03:01
Creating Workbooks Using Templates
03:24
Saving an Excel Workbook
05:20
Using Convert and Checking Compatibility
02:19
Navigating a Worksheet by Mouse or Keyboard
04:52
Understanding Excel Data Types
02:50
Working with Cell and Range Addressing
02:20
Using Various Data Selection Techniques
05:14
Working with Common Excel Commands
07:25
Using the Autofill Handle
02:37
What are Formulas and Functions?
02:02
Understanding the Components of a Formula
05:39
Understanding Calculation Hierarchy and the Order of Operations
02:26
Working with Basic Functions and AutoSum
03:59
Using Cell References
03:37
Using the Quick Analysis Tool
01:15
Modifying Columns and Rows
06:08
Hiding and Unhiding Columns and Rows
03:06
Formatting and Aligning Data
05:47
Merging Data
03:52
Wrapping Text and Adjusting Orientation
01:45
Formatting Numbers
03:10
Using Borders and Shading
02:37
Using the Format Painter
01:21
Removing Formatting Quickly
01:24
Understanding Cell Styles
01:38
Applying Cell Styles
04:23
Applying Themes
03:13
Inserting and Formatting Images
02:46
Inserting and Formatting Shapes
04:27
Inserting and Formatting SmartArt
03:47
Inserting Screenshots
02:17
Inserting Hyperlinks
02:37
Inserting Symbols and Equations
03:13
Inserting WordArt and Text Boxes
03:50
Inserting Other Excel Objects
03:53
Arranging Objects
03:47
Using Find and Replace
03:43
Finding and Replacing Formatting
01:19
Using Go To and Go To Special
02:23
Using the Spell Checker
02:34
Using the Thesaurus and Translation Features
03:04
Printing and Previewing Excel Files
02:57
Creating Custom Margins and Scaling
04:53
Adding Headers and Footers
03:40
Formatting a Page with the Page Layout Tab
02:34
Printing Titles and Specific Worksheet Areas
04:31
Exporting to PDF and XPS
01:36
Renaming and Coloring Worksheet Tabs
02:34
Adding, Deleting, and Navigating Worksheets
03:29
Moving and Copying Worksheets
03:44
Hiding and Unhiding Worksheets
02:11
Viewing Workbooks
02:44
Using Zoom Tools
02:13
Configuring Sheet Options
02:16
Using the Freeze Panes and Split Commands
04:49
Working with Window Commands
03:41
Course Recap
01:42
+ Excel 2016 Intermediate
75 lectures 04:00:44
Customizing the Ribbon
06:09
Customizing the Quick Access Toolbar
03:46
Customizing the General and Formula Options
02:28
Customizing the AutoCorrect Options
03:31
Customizing the Save Defaults
02:25
Customizing Advanced Excel Options
02:49
Linking Workbooks and Worksheets
04:55
Linking Worksheets with 3D References
02:54
Understanding the Consolidate Feature
04:44
What are Range Names?
02:43
Creating Range Names Using the Name Box and Define Name
06:46
Creating Range Names Using Create from Selection
02:39
Working with the Most Common Logical Functions
02:31
Evaluating Data with the AND Function
03:15
Evaluating Data with the OR Function
03:07
Understanding IF Functions
04:19
Nesting AND and OR Inside an IF Function
05:57
What are Lookup Functions?
01:41
Using VLOOKUP
07:39
Understanding the Differences Between Sorting and Filtering
01:43
Sorting Lists
03:49
Filtering Lists
03:18
Creating Tables and Understanding the Benefits
02:28
Formatting a Table
02:36
Sorting Tables
02:05
Filtering Tables
02:38
Filtering with Slicers
02:49
Calculating with Tables
03:42
Removing Erroneous Table Data
02:08
Exporting, Refreshing, and Converting Tables
02:06
What is Conditional Formatting?
01:18
Conditional Formatting: Highlight Cells and Top Bottom Rules
04:23
Conditional Formatting: Data Bars, Icon Sets, and Color Scales
03:55
Using Custom Fonts and Colors
02:15
Using Custom Conditional Formatting
02:46
Modifying or Removing Conditional Formatting
02:04
What are Subtotals and Grouping?
01:06
Creating Subtotals
03:00
Grouping and Ungrouping Data
02:02
What are Charts?
03:42
Creating Charts
04:02
Understanding Chart Elements
02:57
Modifying Chart Elements
07:24
Changing and Moving Charts
03:42
Filtering a Chart
02:25
Formatting Charts
06:44
Adjusting Numbering
03:19
Creating Dual Axis Charts
02:14
Forecasting with Trendlines
04:30
Creating a Chart Template
01:10
Displaying Trends with Sparklines
04:18
What is a PivotTable?
03:57
Creating a PivotTable
02:56
Working with the PivotTable Fields Pane
06:44
Basic Data Organization and Analysis with PivotTables
03:42
Formatting PivotTables
05:31
Creating a PivotChart
03:33
Modifying and Formatting a PivotChart
03:13
Adding Slicers and Timeline Slicers
03:28
Formatting Slicers
03:01
What is Flash Fill?
01:12
Using Flash Fill and Autofill
02:41
Filling Various Series
04:20
What are Date and Time Functions?
01:31
Using TODAY, NOW, and DAY Functions
02:04
Using NETWORKDAYS and YEARFRAC Functions
02:23
Using CONCATENATE
02:35
Using Text to Columns
02:26
Using LEFT, RIGHT, and MID Functions
01:59
Using UPPER, LOWER, and PROPER Functions
01:39
Course Recap
01:32
+ Excel 2016 Advanced
64 lectures 02:18:37
Summarizing Data with SUMIF
04:27
Summarizing Data with AVERAGEIF
02:35
Summarizing Data with COUNTIF
01:52
Using VLOOKUP with TRUE
03:40
Using HLOOKUP with TRUE
01:22
Using the INDEX Function
03:09
Using the MATCH Function
02:14
Combining INDEX and MATCH
04:09
Comparing Two Lists with VLOOKUP and ISNA
03:47
Creating a Nested IF Function
02:53
Using the IFERROR Function
02:15
Using the LEN Function
02:07
Using the TRIM Function
01:03
Using the SUBSTITUTE Function
02:22
Showing Formulas
01:01
Tracing Precedents and Dependents
02:33
Error Checking
01:55
Using the Scenario Manager
03:20
Using Goal Seek
01:43
Analyzing with Data Tables
02:28
Understanding Protection
01:53
Encrypting Files with Passwords
02:35
Allowing Specific Worksheet Changes
01:27
Adding Protection to Selected Cells
02:48
Additional Protection Features
01:45
Using the PivotTable and PivotChart Wizard
02:02
Adding a Calculated Field
01:33
Adding a Calculated Item
01:43
Applying Conditional Formatting to a PivotTable
02:35
Using Filters in a PivotTable
01:42
Creating Filter Pages for a PivotTable
01:16
Enabling the PowerPivot Add-In
03:59
What are Macros?
02:37
Displaying the Developer Tab
02:41
Creating a Basic Formatting Macro
02:58
Running a Macro
01:32
Assigning a Macro to a Button
02:07
Creating Complex Macros
02:29
Viewing and Editing the VBA Code
02:37
Adding a Macro to the Quick Access Toolbar
01:49
What are Form Controls?
01:44
Adding Spin Buttons and Check Boxes
02:04
Adding a Combo Box
01:42
What is Data Validation?
01:26
Restricting Data Entry to Whole Numbers
01:33
Restricting Data Entry to a List
01:07
Restricting Data Entry to a Date
01:15
Restricting Data Entry to Specific Text Lengths
01:23
Composing Input Messages
01:36
Composing Error Alerts
02:00
Finding Invalid Data
01:56
Editing and Deleting Data Validation Rules
00:57
Working with Comments
03:04
Printing Comments and Errors
01:45
Sharing a Workbook
03:21
Tracking Changes in a Workbook
02:35
Working with Versions
01:59
Sharing Files via Email
01:51
Importing a Text File
02:44
Exporting Data to a Text File
01:16
Course Recap
01:14