Click once to Select All. Many of us know that we can select the entire excel sheet by using the Ctrl.
Discounts for 3+ Users
Do you need more information about group pricing for our training courses?
ANY SIZE/ANY INDUSTRY (Businesses, Non-Profits, Academic Institutions)
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
- Learning VBA for MS Excel, will allow you to automate existing things you do in Excel, so that you can save time and make your life easier. It can also make excel do things that you would never have been able to do without VBA. You can use these skills to make your day to day working life easier, impress your colleagues or your boss.
- And since nobody ever said Excel was easy, we’ve collected our favorite strategies for improved performance. 1.) Navigate Excel like a pro. Sure, a mouse and a trackpad are standard fixtures on most modern desks. But if you want to really supercharge your use of Microsoft Excel, learn keyboard shortcuts.
- Mastering Excel Formulas VLOOKUP Mark Moore. 3.6 out of 5 stars 32. Excel Conditional Formatting: Tips You Can Use Immediately To Make Your Data Stand Out (Data Analysis With Excel Book 3) Scott Hartshorn. 4.3 out of 5 stars 39.
Teacher : Barbara Evers Learner : Christina Tankersley
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 business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your path to first learning, and then mastering Excel 2013.
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 learn 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, including:
- How to customize Microsoft Excel 2013 to work better for you
- Easily creating & modifying Pivot Tables
- The best way to create easy-to-view Charts & Graphs
- Using Conditional Formatting and Sparklines to Highlight Data Trends
- Tips & Tweaks for over 120 Excel 2013 functions and features!
Objectives – You will be able to:
- Demonstrate navigating around the Excel Interface
- Explain the relationship between Workbooks, Worksheets, rows, columns, cells, and named ranges
- Describe how to create and use Pivot Tables and Pivot Charts
What You'll Learn
Lessons Include:
Mastering Excel 2013 – Basics
02: Worksheet Navigation, Part 1 (6:50)
03: Worksheet Navigation, Part 2 (8:15)
04: Sheet Tab Options (6:41)
05: The Excel Interface (9:36)
06: The Status Bar (9:54)
07: Keyboard Shortcuts (10:10)
08: File Types (9:49)
09: Open, Save, & AutoSave (14:45)
10: Templates (7:51)
11: AutoCorrect (5:48)
12: Undo and Redo (4:44)
13: Text Formatting, Part 1 (9:02)
14: Text Formatting, Part 2 (9:27)
15: The Windows Clipboard (12:17)
16: Microsoft Office Clipboard (6:32)
17: Highlighting and Navigating in a Workbook (11:52)
18: Entering Data in Series (8:54)
19: Flash Fill (6:43)
20: Formulas (13:04)
21: Intro to Functions (8:59)
Mastering Excel 2013 – Intermediate
2: Scientific Equations (6:46)
3: Find and Replace (8:10)
4: Spellcheck and References (9:12)
5: Shapes, Part 1 (11:19)
6: Shapes, Part 2 (8:42)
7: Pictures (11:13)
8: Pictures + Shapes = Awesome (4:04)
9: ClipArt & SmartArt (10:11)
10: Text Boxes (6:02)
11: Financial Functions (9:55)
12: Data and Time Functions (9:09)
13: Text Functions (7:48)
14: Logical, Math, and Statistical Functions (8:31)
15: vLookup & Misc Functions (8:36)
16: New Functions in 2013 (6:35)
17: Formatting Cells & Ranges, Part 1 (8:10)
18: Formatting Cells & Ranges, Part 2 (10:43)
19: Tables (12:36)
20: Sorting and Filtering (11:51)
21: Importing Data (8:53)
22: Intro to Charts (4:27)
23: Choosing the Right Chart (5:36)
24: Chart Data (3:49)
25: Optimizing Charts (10:57)
26: New Chart Formatting Options (12:17)
28: Manipulating Text with Functions (8:36)
29: Printing Worksheets (11:37)
30: Working with Print Area (5:29)
Mastering Excel 2013 – Advanced
1: Quick Analysis & Slicers (9:19)
2: Subtotals (6:36)
3: Creating Pivot Tables (7:48)
4: Recommended Pivot Tables (3:55)
5: Customizing Pivot Tables (14:38)
6: Pivot Charts (5:18)
7: Customizing Your View, Part 1 (12:47)
8: Customizing Your View, Part 2 (3:51)
9: Advanced Formatting (7:46)
10: Advanced Data Copy Techniques (8:35)
11: Transforming Data with the Clipboard (2:52)
12: Using Data Validation (10:33)
13: Analyzing Data: Scenario Manager (7:26)
14: Analyzing Data: Data Tables (7:48)
15: Analyzing Data: Goal Seek (2:59)
16: Text to Columns (4:36)
17: Consolidating Data (3:38)
18: Creating Macros (8:18)
19: Advanced Macros (5:53)
20: Creating Random Numbers and Custom Series (6:48)
21: External References (3:55)
22: Customizing the Ribbon and Toolbar (9:31)
23: Power View (7:52)
Pricing
Pricing
This course is included in the Bigger-Brains online subscription for individuals or organizations, or can be purchased in SCORM format for use in your own LMS (Learning Management System)
Free Online Excel Training
- Individuals — more info
- Organizations — more info
- SCORM format — more info
Also available from these partners:
Mastering Excel 2013 – Intermediate
Mastering Excel 2013 – Full Course
Course Length
Course Length
Versions Available : Standard HD SCORM, MP4, reseller HTML, Vimeo embed
Produced by : Bigger Brains
Modules : 21
Seat Time : 3 Hours
Mastering Excel Book
Modules : 30
Seat Time : 4.25 Hours
Modules : 23
Seat Time : 2.75 Hours
Modules : 74
Seat Time : 10 Hours
Sample Course Video
Who else has used Bigger Brains courses?