Mastering Excel 2013


  • Mastering Excel 2013, Singapore elarning online course
  • Mastering Excel 2013, Singapore elarning online course
  • Mastering Excel 2013, Singapore elarning online course

Course Description

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 business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your path to first learning, then even mastering Excel.


Course Objectives

• 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


Related Courses

  • Mastering Outlook 2016 (full course)

    Mastering Outlook 2016 (full course)

    SGD $62.50

    Course Description

    From Time-Waster to Productivity Booster: Change the Way You Use Microsoft Outlook Few things have greater impact on your productivity than the way you employ Outlook. Too many people waste time on unnecessary tasks that could be either managed automatically or handled in a fraction of the time – if the Outlook user just knew how to use the proper tools. This Course Prepares You for MOS and Teaches How To Make The Leap From Being A Mere User To Being An Outlook Master.

    Read more...

  • Mastering Word 2013

    Mastering Word 2013

    SGD $50.00

    Course Description

    This Is Your Authoritative Course For All Things On Microsoft Word 2013 -- Delivered In Easily Searchable, Highly Informative Content Modules Microsoft Word:  Hands-down the most powerful document creation tool on the planet.  Used by millions of people each day, very few know how to use it properly.  In this comprehensive course produced by Microsoft Certified Trainer Christina Tankersley with closely aligned syllabus for MOS preparation, we’ll show you everything you need to know to harness the power of Microsoft Word.

    Read more...

  • Mastering Excel 2010

    Mastering Excel 2010

    SGD $25.00

    Course Description

    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 2010 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 not only suitable for MOS preparation, it is your path to first learning, then even mastering Excel

    Read more...


Content

Mastering Excel 2013

+
Mastering Excel 2013

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)
67: Text to Columns (4:35)
68: Consolidating Data (3:37)
69: Creating Macros (8:16)
70: Advanced Macros (5:49)
71: Creating Random Numbers & Custom Series (6:46)
72: External References (3:55)
73: Customizing the Ribbon & Toolbar (9:28)
74: Power View (7:50)


Simulated Practice Environment
SGD $62.50
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.