Learning Excel 2019 – Advanced (TOSA)

# of Lessons

Duration

5:34:58

Skill Level

Advanced

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 in the world: A handful of people who are masters of Excel, and the millions of others who wish they were.

When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet expert can work wonders—from organizing lists to creating multi-layered interactive reports; from answering critical business questions to managing budget allocations and tracking expenses.

Take this course and you’ll be one step closer to becoming an expert at using Excel 2019. Material in these modules is aligned with the Level 4 – Advanced User TOSA Certification. You’ll work with more complex features and functions of Excel and acquire a skillset to handle large tables and databases. Learn to use customized sorting and filters to extract data, so you can review and manage your data with ease.

Topics covered include:

Using Autofill and Named Ranges
Working with advanced functions (Date, Time, Conditional, Database, Lookup)
Applying advanced filtering
Using advanced chart features
Inserting and modifying graphics
Creating PivotTables with advanced PivotTable features
Creating internal and external links
Consolidating data
Co-authoring and using Compare and Merge
Adding Digital Signatures
Protecting workbooks and worksheets
Customizing Data Validation
Running and editing Macros
Inserting symbols and characters
Working with Forms

Enjoy over five hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Course Contents:

#	Section	#	Lesson	Length
1	Working with Functions	1	Using AutoFill	7:36
		2	Copying Formulas and Functions	7:09
		3	Using Named Ranges, Part 1	5:00
		4	Using Named Ranges, Part 2	5:25
		5	Using Named Ranges, Part 3	5:08
		6	Working with Date Functions, Part 1	8:55
		7	Working with Date Functions, Part 2	4:17
		8	Working with Date Functions, Part 3	3:37
		9	Working with Time Functions	5:29
		10	Working with Conditional Functions	7:33
		11	Multiple Criteria Functions	5:03
2	Working with Lists	12	Filtering Data, Part 1	7:11
		13	Filtering Data, Part 2	7:55
		14	Querying with Database Functions	6:55
		15	Using the Subtotal Function	4:28
		16	Using the Subtotal Feature	6:12
3	Visualizing Data with Charts	17	Using Advanced Chart Features	4:29
		18	Applying Trendlines	4:35
		19	Creating a Chart Template	3:27
4	Inserting Graphics	20	Inserting Graphics	8:41
		21	Modifying Graphics, Part 1	5:40
		22	Modifying Graphics, Part 2	6:12
5	Using PivotTables and Slicers	23	Creating a PivotTable	11:31
		24	Summarizing Data in a PivotTable	8:00
		25	Grouping Data in a PivotTable	6:15
		26	Formatting a PivotTable	6:56
		27	Selecting and Moving PivotTables	3:15
		28	Changing PivotTable Options	8:07
		29	Adding Calculated Fields	2:03
		30	Using Slicers	7:26
		31	Using Timeline Slicers	1:44
6	Linking and Consolidating	32	Creating Internal Links	4:08
		33	Creating External Links	9:00
		34	Using Paste Special	5:50
		35	Consolidating Data	6:56
7	Sharing and Protecting	36	Co-Authoring, Part 1	6:12
		37	Co-Authoring, Part 2	4:44
		38	Using Compare and Merge	3:04
		39	Adding Digital Signatures	5:55
		40	Protecting Worksheets	10:33
		41	Protecting Workbook Structure	3:01
		42	Protecting a Workbook File	7:08
8	Automating	43	Applying Data Validation	7:18
		44	Adding a Dropdown List	4:56
		45	Customizing Data Validation	5:18
		46	Recording a Macro	8:08
		47	Running a Macro	5:32
		48	Editing a Macro	8:27
9	Using Lookup Functions	49	Using VLOOKUP, Part 1	5:40
		50	Using VLOOKUP, Part 2	5:14
		51	More Lookup Functions	9:44
		52	Using Array Formulas	6:00
10	Other	53	Using Goal Seek	3:30
		54	Inserting Symbols and Characters	2:32
		55	Working with Forms	9:54

Related Course Recommendations:

Learning Excel 2019 – Advanced (TOSA)

About

Friendly experts, modern technology, and a unique Teacher-Learner style, make award-winning Bigger Brains courses the first choice of learners and training professionals around the world.

Catalog Request

Get course updates, Learning and Development ideas, and Information on how to use Bigger Brains!