Mastering Excel 2013

# of Lessons

Duration

10:02:19

Skill Level

Everyone

MSRP

$45

Instructor(s)

Barbara Evers

Available Captions

Not Captioned

Also Included

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

The world is filled with two kinds of people: a handful of people who are masters of Excel, and the millions of others who wish they were

If you’ve mastered Microsoft Excel 2013, then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to businesses’ critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your path to first learning, then mastering Excel.

This is our most requested training course! If you learn to use Excel 2013, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. Of course, you may have a rudimentary knowledge of how Excel works, but if you want to get the most of it, then take this course. Let our Microsoft Certified Trainers, Barbara Evers and Christina Tankersley, walk you through everything you’ve ever wanted to know about Microsoft Excel 2013.

Topics covered include:

Customizing Microsoft Excel features to work best for you
Creating & modifying Pivot Tables
Creating easy-to-view Charts & Graphs
Using Conditional Formatting and Sparklines to highlight data trends
Learning tips & tweaks for over 120 Excel 2013 functions and features!

High-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!

Course Contents:

#	Lesson	Length
1	Looking at Excel 2013	8:58
2	Navigating the Worksheet	6:49
3	Worksheet Navigation, Part 2	8:15
4	Sheet Tab Options	6:40
5	The Excel Interface	9:35
6	The Status Bar	9:53
7	Keyboard Shortcuts	10:10
8	File Types	9:48
9	Open, Save, & Autosave	14:44
10	Templates	7:50
11	AutoCorrect	5:48
12	Undo & Redo	4:43
13	Text Formatting, Part 1	9:02
14	Text Formatting, Part 2	9:26
15	Adding Hyperlinks	4:31
16	Scientific Equations	6:45
17	The Windows Clipboard	12:16
18	Microsoft Office Clipboard	6:32
19	Find & Replace	8:09
20	Spellcheck & References	9:12
21	Shapes, Part 1	11:19
22	Shapes, Part 2	8:42
23	Pictures	11:13
24	Pictures + Shapes = Awesome	4:04
25	ClipArt & SmartArt	10:10
26	Text Boxes	6:02
27	Highlighting & Navigating in a Workbook	11:52
28	Entering Data in Series	8:54
29	Flash Fill	6:43
30	Formulas	13:04
31	Intro to Functions	8:58
32	Financial Functions	9:54
33	Data & Time Functions	9:08
34	Text Functions	7:48
35	Logical, Math, & Statistical Functions	8:33
36	vLookup & Misc Functions	8:35
37	New Functions in 2013	6:33
38	Formatting Cells & Ranges, Part 1	8:08
39	Formatting Cells & Ranges, Part 2	10:36
40	Tables	12:34
41	Sorting & Filtering	11:51
42	Quick Analysis & Slicers	9:17
43	Subtotals	6:33
44	Creating Pivot Tables	7:46
45	Recommended Pivot Tables	3:53
46	Customizing Pivot Tables	14:33
47	Importing Data	8:50
48	Intro to Charts	4:24
49	Choosing the Right Chart	5:33
50	Chart Data	3:46
51	Optimizing Charts	10:56
52	New Chart Formatting Options	12:14
53	Pivot Charts	5:14
54	Sparklines	5:22
55	Customizing Your View, Part 1	12:44
56	Customizing Your View, Part 2	3:47
57	Advanced Formatting	7:43
58	Advanced Data Copy Techniques	8:31
59	Transforming Data with the Clipboard	2:50
60	Manipulating Text with Functions	8:35
61	Printing Worksheets	11:34
62	Working with Print Area	5:27
63	Using Data Validation	10:31
64	Analyzing Data: Scenario Manager	7:27
65	Analyzing Data: Data Tables	7:47
66	Analyzing Data: Goal Seek	2:59

Related Course Recommendations:

Mastering Excel 2013

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!