Getting Started with Microsoft Office Excel 2019 Part2
0.0 (0 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.
0 students enrolled

Getting Started with Microsoft Office Excel 2019 Part2

Part2
0.0 (0 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.
0 students enrolled
Last updated 2/2020
English
English [Auto-generated]
Current price: $64.99 Original price: $99.99 Discount: 35% off
2 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 7 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
  • Working with functions and lists
  • Analyzing and visualizing data with charts
  • Using PivotTables and PivotCharts
Requirements
  • Microsoft Excel 2007 - 2019
  • Computer or laptop with Windows
Description

This course will introduce students to Microsoft Office Excel 2019, and teach students about performing calculations, modifying a worksheet, formatting a worksheet, printing workbooks, managing workbooks, adding borders and colors to worksheets, and basic Excel customization.

This course will teach students about working with functions, working with lists, analyzing data, visualizing data with charts, using PivotTables and PivotCharts, working with graphical objects, and using array formulas.

This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.

Who this course is for:
  • Absolute beginners who want to learn all about Microsoft Excel
  • Excel users with basic skills but interested in learning new features
  • Business professionals
  • Data analysts for building strong analytical and business intelligence skills
Course content
Expand all 209 lectures 03:59:38
+ Working with Functions
51 lectures 01:06:14
Cell and Range Names in Formulas
00:54
The Use in Formula Command Method
00:42
The Formula AutoComplete Method
00:44
Demo - Using Defined Names in a Formula
01:36
Topic B: Use Specialized Functions
00:23
The Excel Function Reference
01:06
Function Syntax
01:09
Criteria Argument Syntax
01:37
Demo - Locating and Using Specialized Functions
05:28
Topic C: Work with Logical Functions
00:29
Logical Values
01:07
Comparison Operators
00:28
The IF Function
02:30
The AND Function
01:10
The OR Function
00:23
The NOT Function
00:56
Demo - Working with Logical Functions
05:44
Nesting
01:09
Nested Function Syntax
03:00
Guidelines for Combining Functions
01:41
Demo - Combining Functions
03:00
Topic D: Work with Date and Time Functions
00:29
The TODAY Function
00:49
The NOW Function
00:17
The DATE Function
01:01
The NETWORKDAYS Function
00:53
The WEEKDAY Function
00:59
The WORKDAY Function
00:59
The ISOWEEKNUM Function
00:37
Demo - Working with Date and Time Functions
01:46
Topic E: Work with Text Functions
00:31
The LEFT Function
00:32
The FIND Function
01:19
The RIGHT Function
00:36
Convert Text to Columns Wizard
00:41
The MID Function
00:47
The CONCAT Function
01:36
Text Concatenation with the Ampersand
00:44
The UPPER Function
00:26
The LOWER Function
00:10
The PROPER Function
00:13
Demo - Working with Text Functions
03:40
Chapter 01 Review
00:43
+ Working with Lists
26 lectures 32:34
Section Introduction
00:44
Topic A: Sort Data
00:56
Sorting
01:56
Multiple Column/Row Sorting
00:56
Quick Sorts
00:56
The Sort Dialog Box
01:06
The Sort Options Dialog Box
00:36
Demo - Sorting Data
02:22
Topic B: Filter Data
00:26
Filtering
01:12
AutoFilters
01:19
The Custom AutoFilter Dialog Box
00:43
Advanced Filtering
00:30
The Criteria Range
01:57
Demo - Filtering Data
02:34
Topic C: Query Data with Database Functions
00:20
Database Functions
01:58
Database Function Syntax
01:42
Demo - Using Database Functions
03:38
Topic D: Outline and Subtotal Data
00:19
Outlines
01:04
The SUBTOTAL Function
01:18
The Subtotals Feature
01:29
The Subtotal Dialog Box
00:28
Demo - Using Subtotals to Summarize Data
01:41
Chapter 02 Review
00:24
+ Analyzing Data
25 lectures 31:32
Section Introduction
00:45
Topic A: Create and Modify Tables
00:44
Tables
00:51
Table Components
01:02
The Create Table Dialog Box
00:26
The Table Tools Design Contextual Tab
00:59
Table Styles and Quick Styles
00:29
The New Table Style Dialog Box
00:26
Quick Analysis
01:00
Demo - Creating and Modifying Tables
03:43
Demo - Using Summary Functions in Tables
02:09
Topic B: Apply Intermediate Conditional Formatting
00:41
The New Formatting Rule Dialog Box
01:44
The Conditional Formatting Rules Manager Dialog Box
00:42
Rule Precedence
01:40
Demo - Applying Intermediate Conditional Formatting
02:15
Topic C: Apply Advanced Conditional Formatting
00:48
The Use a Formula to Determine Which Cells to Format Rule Part1
01:02
The Use a Formula to Determine Which Cells to Format Rule Part2
00:44
Cell References and Conditional Formatting Part1
02:09
Cell References and Conditional Formatting Part2
01:20
Guidelines for Applying Conditional Formatting to Cells Based on Values in Other
01:01
Guidelines for Applying Conditional Formatting to Cells Based on Values in Other
00:38
Demo - Using Logical Functions to Apply Conditional Formatting
03:43
Chapter 03 Review
00:31
+ Visualizing Data with Charts
28 lectures 36:34
Section Introduction
01:06
Topic A: Create Charts
00:16
Charts
00:53
Chart Basics
00:58
Chart Insertion Methods
01:26
Chart Types
01:40
Recommended Charts
00:28
Demo - Creating Charts
03:32
Topic B: Modify and Format Charts
00:32
Chart Modifications
00:36
Chart Formatting
00:22
Chart Elements
00:56
Guidelines for Modifying Chart Elements
01:46
The Design Tab
00:54
The Format Tab
00:30
The Format Task Pane
01:14
The Chart Tools Buttons
00:37
The Select Data Source Dialog Box
00:23
Demo - Modifying and Formatting Charts
04:39
Topic C: Use Advanced Chart Features
00:56
Dual-Axis Charts
01:10
Forecasting
00:34
Trendlines
00:52
The Format Trendline Task Pane
00:58
Demo - Creating a Dual-Axis Chart with a Trendline
05:31
Chart Templates
01:04
Demo - Creating a Chart Template
01:54
Chapter 04 Review
00:47
+ Using PivotTables and PivotCharts
35 lectures 38:28
Section Introduction
01:22
Topic A: Create a PivotTable
00:26
Pivoting
01:58
PivotTables
01:09
Transactional Data
01:08
The Create PivotTable Dialog Box
00:35
The PivotTable Fields Task Pane
01:11
Demo - Creating a PivotTable
01:55
Topic B: Analyze PivotTable Data
00:38
Start with Questions, End with Structure Part1
01:18
Start with Questions, End with Structure Part2
01:10
Start with Questions, End with Structure Part3
00:30
The Value Field Settings Dialog Box
00:36
SUM Function Only
00:45
Percentage of Total
00:34
Difference From Option
00:44
The Analyze Tab
01:25
The Design Tab
00:23
The GETPIVOTDATA Function
01:53
Demo - Analyzing PivotTable Data
03:28
Topic C: Present Data with PivotCharts
00:30
PivotCharts
00:38
The PivotChart Fields Task Pane
00:28
PivotChart Filters
00:35
Demo - Presenting Data with PivotCharts
03:28
Topic D: Filter Data by Using Timelines and Slicers
00:43
Slicers
01:16
The Insert Slicers Dialog Box
00:17
The Slicer Tools Contextual Tab
00:51
The Report Connections Dialog Box
00:39
Timelines
00:33
The Insert Timelines Dialog Box
00:22
The Timeline Tools Contextual Tab
00:32
Demo - Filtering Data by Using Slicers and Timelines
03:43
Chapter 05 Review
00:45
+ Working with Graphical Objects
28 lectures 14:53
Section Introduction
00:53
Topic A: Insert Graphical Objects
00:15
Graphical Objects Part1
00:39
Graphical Objects Part2
00:57
The Insert Picture Dialog Box
00:24
The Insert Online Pictures Window
00:21
Shapes
00:19
Icons
00:22
3D Models
00:21
Screenshots
00:42
Text Boxes
00:22
WordArt
00:17
Topic B: Modify Graphical Objects
00:28
The Picture Tools Contextual Tab
00:44
The Image Editor
00:36
The Drawing Tools Contextual Tab
00:44
The Graphics Tools Contextual Tab
00:32
The 3D Model Tools Contextual Tab
00:27
The Selection Task Pane
00:42
The Format Task Panes
00:32
Object Properties
00:52
Topic C: Work with SmartArt
00:19
SmartArt Graphics
00:36
SmartArt Shapes
00:36
The Choose a SmartArt Graphic Dialog Box
00:25
The Text Pane
00:24
The SmartArt Tools Contextual Tab
00:30
Chapter 06 Review
00:34
+ Using Array Formulas
13 lectures 16:07
Section Introduction
00:46
Topic A: Use Array Formulas
00:13
Arrays
01:12
Array Formulas
02:11
Single-Cell Array Formula
00:36
Array Constants
00:56
Array Formula Syntax
01:43
Array Formula with Data Ranges
00:43
Array Formula Rules Part1
01:04
Array Formula Rules Part2
00:33
Demo - Using Array Formulas
04:19
Chapter 07 Review
00:19
Course Closure
01:32