Mastering Excel 2016


  • Mastering Excel 2016, Singapore SKillsFuture elarning online course
  • Mastering Excel 2016, Singapore SKillsFuture elarning online course
  • Mastering Excel 2016, Singapore SKillsFuture 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 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.


Course Objectives

• Demonstrate how to navigate the ribbon
• Discuss the compatibility issues between Excel 2016 and older versions of Excel
• Explain the importance of named ranges
• Write nested functions
• Demonstrate advanced functions
• Define and develop macros


Related Courses

  • Entrepreneuring: Keys To Business Success + The Top 5 Marketing Mistakes

    Entrepreneuring: Keys To Business Success + The Top 5 Marketing Mistakes

    SGD $37.50

    Course Description

    Learn To Avoid Another Being A Failure – And The Critical Keys To Achieving Success Across the world, businesses have a 90% failure rate.  Why is it that 9 of every ten businesses fail? This is your chance to pick the brains of some of the greatest entrepreneurial minds and gain the powerful knowledge you need to avoid the common pitfalls, traps, and mistaken ideas that cause most business failures, and learn the critical keys to success that can put your business growth in fast forward. What Is The Difference Between A Marketing Campaign That Delivers Average Results, And One That Boosts Profits And Changes Your Bottom Line? (Hint: The keys to effective marketing are in this course). In this course, Rich Harshaw explains why his famous statement, ""Everything You Know About Marketing Is Wrong"" is so universally true, and what businesses can do to revamp their marketing strategies to achieve superior results

    Read more...

  • Mastering PowerPoint 2010

    Mastering PowerPoint 2010

    SGD $25.00

    Course Description

    Going From Boring And Plain Presentations To Something That Makes People Sit Up And Pay Attention -- How To Effectively Use PowerPoint 2010 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? This course will prepare you for MOS and show you how to turn lackluster presentations into something that is visually stimulating and works to keep your audience engaged.

    Read more...

  • Mastering Word 2016 (full course)

    Mastering Word 2016 (full course)

    SGD $62.50

    Course Description

    Learn Everything You Need to Know About Microsoft Word 2016 -- 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 course produced by Microsoft Certified Trainer Christina Tankersley we’ll show you everything you need to know to start harnessing the power of Microsoft Word, from the very basics to the most advanced features.

    Read more...


Content

Mastering Excel 2016

+
Mastering Excel 2016

01: Intro (8:53)
02: Selecting and Navigating (7:55)
03: Keyboard Navigation and Basic Data Entry (9:18)
04: The Ribbon (5:23)
05: The Quick Access Toolbar (4:28)
06: Creating a New Spreadsheet (9:08)
07: Compatibility Issues (5:26)
08: Cell Data & Data Types (12:41)
09: Accessing Help (3:11)
10: Creating Worksheet Formulas (11:11)
11: Insert Functions (11:28)
12: Re-using Formulas and Functions (12:00)
13: Insert, Delete, & Adjust Columns & Rows (7:22)
14: Find and Replace (9:52)
15: Use Proofing and Research Tools (11:21)
16: Apply Text Formats (14:14)
17: Apply Number Formats (7:00)
18: Align Cell Contents (8:45)
19: Applying Styles and Themes (11:43)
20: Conditional Formatting (11:42)
21: Creating and Using Templates (6:13)
22: Preview and Print a Notebook (8:48)
23: Page Layout (15:44)
24: Configure Headers and Footers (12:37)
25: Managing Worksheets (6:32)
26: View Options (10:54)
27: Managing Workbook Properties (4:58)
28: Working with Named Ranges (11:40)
29: Using Named Ranges in Formulas (3:53)
30: Using Specialized Functions (14:13)
31: Working with Logical Functions (13:56)
32: Displaying Formulas
33: Nesting Functions (5:29)
34: Date and Time Functions (3:38)
35: Text Functions (14:34)
36: Sorting Data (5:35)
37: Filtering Data (9:18)
38: Using Database Functions (7:49)
39: Using Subtotals (9:42)
40: Create and Modify Tables (8:16)
41: Manipulating Table Data (3:51)
42: Conditional Formatting Rules (3:52)
43: Using Logical Functions with Conditional Formatting (5:20)
44: Creating Charts (8:37)
45: Modifying and Formatting Charts (9:38)
46: Creating a Dual Axis Chart (7:21)
47: Chart Templates (2:59)
48: Creating a PivotTable (7:15)
49: Formatting Shapes and Objects
50: Analyzing PivotTable Data (9:47)
51: Pivot Charts (6:26)
52: Slicers and Timelines (6:05)
53: Using Links and External References (10:16)
54: Using 3D References (8:58)
55: Consolidating Data (6:15)
56: Using Lookup Functions (12:01)
57: Using Lookup Functions Copy (5:59)
58: Tracing Precedent and Dependent Cells (6:24)
59: Watching and Evaluating Formulas (5:30)
60: Comments and Track Changes (8:23)
61: Comparing and Merging Workbooks (4:48)
62: Accessibility Checker (4:20)
63: Protecting Worksheets and Workbooks (9:51)
64: Applying Data Validation (9:33)
65: Search for Invalid Data (6:41)
66: Working with Macros, Part 1 (11:27)
67: Working with Macros, Part 2 (7:21)
68: Creating Sparklines (4:42)
69: 3D Maps (6:32)
70: Data Tables (6:32)
71: Using Scenarios (4:55)
72: Goal Seek (2:42)
73: Forecasting Data Trends (3:00)
74: Changing Your Display (4:16)
75: Importing Delimited Text Files (3:42)
76: Data Forms and Form Controls (14:22)
77: Calculated Fields and Cube Functions (4:56)


Simulated Practice Environment
SkillsFuture Credit Eligible
  • SKU CA-N-2019-001981
  • Duration 10 hr 0 mins
  • Skill level All Levels
  • Languages en_US
  • Tag(s) Mastering Excel 2016


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.