Mastering Excel 2010


Mastering Excel 2010, 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 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


Course Objectives

• Create and manipulate worksheets
• Demonstrate the different ways to copy and paste data
• Organize spreadsheets to increase productivity

Related Courses

  • 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 2016

    Mastering Excel 2016

    SGD $62.50

    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 2016 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 covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.  Note: This course covers all the objectives required in the Microsoft Office Specialist exam 77-727.

    Read more...

  • Mastering PowerPoint 2013

    Mastering PowerPoint 2013

    SGD $50.00

    Course Description

    Going From Boring And Plain Presentations To Something That Makes People Sit Up And Pay Attention -- How To Effectively Use PowerPoint 2013 Have you seen someone deliver a PowerPoint presentation that was really well done? Do you remember the difference it made – not only in helping you understand the content, but the way it made you feel about the presenter? Recommended for MOS preparation, this course will show you how to turn lackluster presentations into something that is visually stimulating and works to keep your audience engaged.

    Read more...

Content

Mastering Excel 2010

+
Mastering Excel 2010

1: Introduction (0:52)
2: Workbooks & Worksheets (8:38)
3: Adding & Changing Worksheets (6:39)
4: Basic Text & Number Entry (12:39)
5: The Excel Interface, Part 1 (6:36)
6: The Excel Interface, Part 2 (15:01)
7: Keyboard Shortcuts (10:02)
8: File Types (9:42)
9: Open, Save, and AutoSave (14:37)
10: Templates (7:50)
11: Autocorrect (5:49)
12: Undo & Redo (4:40)
13: Text Formatting, Part 1 (9:01)
14: Text Formatting, Part 2 (9:25)
15: Adding Hyperlinks (4:32)
16: Scientific Equations (6:46)
17: The Windows Clipboard (12:17)
18: The Office Clipboard (6:32)
19: Find & Replace (8:10)
20: Spellcheck and References (9:12)
21: Shapes (11:19)
22: Shapes, Part 2 (8:42)
23: Pictures (11:13)
24: Pictures + Shapes (4:04)
25: Clipart & SmartArt (10:11)
26: Text Boxes (6:02)
27: Highlighting and Navigating in a Workbook (11:53)
28: Insert, Delete, Hide, Unhide (10:15)
29: Entering Data in Series (8:54)
30: Formulas and Order of Operations (13:04)
31: Intro to Functions (8:59)
32: Financial Functions (9:55)
33: Date & Time Functions (9:08)
34: Text Functions (7:49)
35: Logical, Math, & Statistical Functions (8:39)
36: vLookup & Misc Functions (8:35)
37: Formatting Cells & Ranges (8:10)
38: Number Formatting (10:42)
39: Tables (12:36)
40: Sorting & Filtering (11:54)
41: Sub Totals (6:36)
42: Pivot Tables (7:49)
43: Customizing Pivot Tables (14:35)
44: Importing Data (8:54)
45: Intro to Charts (4:27)
46: Choosing the Right Chart (5:36)
47: Chart Data (3:50)
48: Advanced Chart Formatting (11:37)
49: Pivot Charts (2:58)
50: Sparklines (5:26)
51: Customizing Your View, Part 1 (12:47)
52: Customizing You View, Part 2 (3:51)
53: Advance Formatting (7:46)
54: Advance Data Copy Techniques (8:35)
55: Transforming Data with the Clipboard (2:53)
56: Manipulating Text with Functions (8:36)
57: Printing Worksheets (11:37)
58: Working with Print Area (5:29)
59: Print Titles, Headers, and Footers (9:27)
60: Using Data Validation (10:34)
61: Analyzing Data with Scenario Manager (7:26)
62: Analyzing Data with Data Tables (7:49)
63: Analyzing Data with Solver and Goal Seek (3:03)
64: Text to Columns (4:36)
65: Consolidating Data (3:38)
66: Creating Macros (8:11)
67: Advance Macros (5:56)
68: Custom Series (6:49)
69: Conditional Formatting, part 1 (6:15)
70: Conditional Formatting, part 2 (10:05)
71: External References (3:54)
72: Exporting and Sharing (5:33)
73: Comments (3:55)
74: Customizing the Ribbon & Quick Access Toolbar (9:31)
75: Conclusion (0:41)

Mastering Excel 2010

SGD $25.00
(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.

Payment

You are making payment for the following course :
 
Price (SGD$) : 25.00
 
Redemption
Cashback balance ($) : 0.00
 
Coupon Code
 
GST 7% ($) : 1.75
Final amount to pay ($) : 26.75