Learning Excel 2019 – Expert (TOSA)

# of Lessons

Duration

4:03:10

Skill Level

Expert

MSRP

$30

Instructor(s)

Kathy Jones

Available Captions

Not Captioned

Also Included

Handout, Practice Files, Knowledge Check, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course will get you one step closer to becoming an expert at using Excel 2019. The material is aligned with the Level 5 Expert TOSA Certification.

Topics covered include:

Customizing your instance of Excel
Using a wide variety of functions including Logical functions, Text functions, Conditional functions, Lookup functions, Math functions, Database functions, Subtotals, and nested functions
Creating a Pivot Table to group and summarize data
Applying advanced Pivot Table features
Creating a Pivot Chart
Collaborating with others using Co-Authoring
Using Tracing, Evaluate Formula, and the Watch Window to find and address errors
Using your data to plan and forecast trends and explore a variety of outcomes based on variables and scenarios
Working with Forms including ActiveX Controls

Over four hours of high-quality HD content in the “Uniquely Engaging” ^TM Bigger Brains Teacher-Learner style!

Course Contents:

#	Section	#	Lesson	Length
1	Customizing Options	1	Customizing General Options	4:45
		2	Customizing the Ribbon	7:02
		3	Customizing the Quick Access Toolbar	6:46
2	Working with Functions	4	Working with Logical Functions	8:36
		5	Working with Conditional Functions	7:33
		6	Multiple Criteria Functions	5:03
		7	Using Nested Functions	5:13
		8	Using IFS and SWITCH Functions	5:56
		9	Working with Text Functions, Part 1	4:13
		10	Working with Text Functions, Part 2	4:27
		11	Working with Text Functions, Part 3	3:42
		12	Working with Text Functions, Part 4	8:14
		13	Working with Math Functions	6:59
		14	More Lookup Functions	9:44
3	Using PivotTables and PivotCharts	15	Creating a PivotTable	11:31
		16	Summarizing Data in a PivotTable	8:00
		17	Grouping Data in a PivotTable	6:15
		18	Formatting a PivotTable	6:56
		19	Selecting and Moving PivotTables	3:15
		20	Changing PivotTable Options	8:07
		21	Adding Calculated Fields	2:03
		22	Presenting Data with PivotCharts	4:21
4	Sharing and Protecting	23	Co-Authoring, Part 1	6:12
		24	Co-Authoring, Part 2	4:44
		25	Protecting a Workbook File	7:08
		26	Applying Data Validation	7:18
5	Auditing Formulas	27	Addressing Formula Errors	7:16
		28	Watching and Evaluating Formulas	4:46
		29	Adding Error Handling	4:34
		30	Working with Information Functions	5:12
6	Forecasting Data	31	Forecasting with Data Tables	5:04
		32	Using Solver	6:46
		33	Forecasting with Scenarios	8:16
		34	Forecasting Data Trends	3:23
		35	Creating Sparklines	3:58
7	More Features	36	Using Paste Special	5:50
		37	Summarizing Data in Tables	4:32
		38	Creating Custom Lists	5:34
		39	Working with Forms	9:54
		40	Using ActiveX Controls	4:02

Related Course Recommendations:

Learning Excel 2019 – Expert (TOSA)

Catalog Request