Mastering Excel 365 – Advanced

# of Lessons

Duration

4:14:41

Skill Level

Advanced

MSRP

$30

Instructor(s)

Kathy Jones, Alexa Botelho

Available Captions

Not Captioned

Also Included

Handout, 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 365, and those who wish they were

When you master 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. Once you have completed this course, there are few things you won’t be able to do with Excel!

Topics covered include:

Collaborating and Sharing
Efficiency functions
Auditing Functions
Forecasting data and trends

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

Course Contents:

Section #	Section Title	Lesson #	Lesson Name	Duration
1	Linking and Consolidating	1	Introduction	1:55
		2	Creating Internal Links	4:08
		3	Creating External Links	9:00
		4	Using Paste Special	5:50
		5	Using Group Mode	3:18
		6	Using 3D References	2:32
		7	Consolidating Data	6:56
2	Sharing and Protecting	8	Adding Comments	7:23
		9	Tracking Changes	6:04
		10	Co-Authoring, Part 1	6:12
		11	Co-Authoring, Part 2	4:44
		12	Using Sheet Views	4:29
		13	Using Compare and Merge	3:04
		14	Preparing to Share	7:19
		15	Adding Digital Signatures	5:55
		16	Protecting Worksheets	10:33
		17	Protecting Workbook Structure	3:01
		18	Protecting a Workbook File	7:08
3	Automating	19	Applying Data Validation	7:18
		20	Adding a Dropdown List	4:56
		21	Customizing Data Validation	5:18
		22	Recording a Macro	8:08
		23	Running a Macro	5:32
		24	Editing a Macro	8:27
4	Using Lookup Functions	25	Using VLOOKUP, Part 1	5:40
		26	Using VLOOKUP, Part 2	5:14
		27	Using XLOOKUP	10:51
		28	More Lookup Functions	9:44
		29	Using Array Formulas	6:00
5	Auditing Formulas	30	Tracing Formulas	6:22
		31	Addressing Formula Errors	7:16
		32	Watching and Evaluating Formulas	4:46
		33	Adding Error Handling	4:34
		34	Working with Information Functions	5:11
6	Forecasting Data	35	Using Goal Seek	3:30
		36	Forecasting with Data Tables	5:04
		37	Using Solver	6:46
		38	Forecasting with Scenarios	8:16
		39	Forecasting Data Trends	3:23
7	More Features	40	Inserting Symbols and Special Characters	2:31
		41	Creating Sparklines	3:58
		42	Creating a Map Chart	3:47
		43	Creating a 3D Map Tour	8:27
		44	Creating Custom Lists	5:34
		45	Importing and Exporting Data	3:19
		46	Creating a Web Query	3:52
		47	Using Data Types	0:00
		48	Working with Forms	9:54
		49	Using ActiveX Controls	4:01
		50	Ideas in Office 365	2:06

Related Course Recommendations:

Mastering Excel 365 – Advanced

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!