Home / Course catalog / 2021 Microsoft Excel - Certification Tr... (MSO-01)


Get this course ($29.00)
Part of 1 bundle


Microsoft Office

2021 Microsoft Excel - Certification Training For Beginners (MSO-01)


Description
Excel is the most in commonly used and in-demand tool for making sense of data. When you can harness that power, you will be a sought after employee and YOU CAN EARN MORE MONEY!.

If you are reading this, you have already taken your first important step. You want to learn Excel from the ground up, and go from a complete beginner, to super user, to being part of the few Excel Elite, and being able to program your very own full blown applications.

This complete course contains all the lectures, quizzes, projects, and downloadable resources. In fact, everything you will need to go from novice to coder!

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor, Deb Ashby with more than 15+ years of Excel training, guides you step by step through the beginner to advanced level and beyond.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot

  • Audit Excel Worksheet formulas to ensure clean formulas

  • Automate your day to day Excel tasks by mastering the power of Macros and VBA


    • So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!

    25 Hours | Scorm | info@vnnergy.com

Content
  • INTRODUCTION AND OVERVIEW
  • An Introduction to Excel for Beginners sample
  • EXCEL BASIC SKILLS
  • Launching Excel
  • Introduction to the Excel Interface
  • Ribbons and Tabs
  • The Backstage Area
  • The Quick Access Toolbar
  • Useful Keyboard Shortcuts
  • Getting Help
  • Contextual Menus and the Mini Toolbar
  • Status Bar
  • Exercise 01 with Solutions
  • CREATING YOUR FIRST EXCEL SPREADSHEET
  • Working with Templates
  • Working with Workbooks and Worksheets
  • Excel Shortcuts - Worksheets and Workbooks
  • Saving your Excel Spreadsheet
  • Custom Lists and Series Fill
  • Entering and Editing Data
  • Basic Number Formatting
  • Navigating and Selecting Cells and Ranges
  • Shortcuts - When operating within a cell in a sheet
  • Exercise 02 with Solutions
  • INTRODUCTION TO EXCEL FORMULAS AND FUNCTIONS
  • Introduction to Functions and Formulas
  • The Order of Calculation
  • Counting Items in a List
  • Finding Averages
  • Finding the Minimum and Maximum Value
  • Using Multiple Functions in a Formula
  • Errors in Calculations
  • Relative, Absolute and Mixed Referencing
  • Exercise 03 with Solutions
  • NAMED RANGES
  • Creating Named Ranges
  • Managing Named Ranges
  • Using Named Ranges in Formulas
  • Named Ranges Tips and Tricks
  • Exercise 04 with Solutions
  • FORMATTING NUMBERS, CELLS AND WORKSHEETS
  • Formatting Numbers
  • Formatting Dates
  • Applying Formatting to Cells
  • Formatting Columns and Rows
  • Alignment
  • Deleting and Clearing Formatting
  • Themes and Styles
  • Using the Format Painter
  • Exercise 05 with Solutions
  • WORKING WITH EXCEL LISTS
  • How to Structure a List
  • Sorting a List (Single-level sort)
  • Sorting a List (Multi-level sort)
  • Sorting using Custom Lists
  • Using Auto-Filter to Filter a List
  • Format As a Table
  • Creating Subtotals in a List
  • Flash Fill
  • Exercise 06 with Solutions
  • MOVING AND LINKING TO DATA
  • Cut Copy and Paste Basics
  • Paste Options
  • Using the Clipboard
  • Linking to cells in other Worksheets
  • 3D Referencing
  • Inserting Hyperlinks to Worksheets
  • Exercise 07 with Solutions
  • USEFUL FUNCTIONS
  • The VLOOKUP Function (Exact Match)
  • The VLOOKUP Function (Approx Match)
  • The HLOOKUP Function
  • Error Handling in Formulas
  • Logical Functions - Part 1
  • Logical Functions - Part 2
  • COUNTIF and SUMIF
  • Text Functions
  • Date and Time Functions
  • Exercise 08 with Solutions
  • ANALYZING DATA WITH CHARTS
  • Creating Charts to Present Data
  • Formatting a Chart
  • Other Useful Charts
  • Updating Charts
  • Exercise 09 with Solutions
  • SORTING AND FILTERING DATA
  • Sorting Data
  • Filtering Data
  • Exercise 10 with Solutions
  • CONDITIONAL FORMATTING
  • Highlight Cell Rules
  • Data Bars
  • Color Scales
  • Icon Sets
  • Exercise 11 with Solutions
  • INSERTING ITEMS INTO A SPREADSHEET
  • Inserting Pictures
  • Inserting Shapes
  • Inserting Icons and 3D Models
  • Inserting SmartArt
  • Inserting Screenshots
  • Inserting Comments and Notes
  • Exercise 12 with Solutions
  • WORKING WITH VIEWS AND ZOOM
  • Workbook Views
  • Zooming in and Out of a Worksheet
  • Arranging Workbooks and Worksheets
  • Freezing Panes
  • Exercise 13 with Solutions
  • PAGE LAYOUT AND PRINTING OPTIONS
  • Margins and Orientation
  • The Print Area
  • Page Breaks
  • Print Titles-and-Background
  • Headers-and-Footers
  • Printing a Workbook
  • Exercise 14 with Solutions
  • FINALIZING YOUR SPREADSHEET
  • Protecting Workbooks and Worksheets
  • Spell Checking
  • Inspecting the Workbook
  • Saving in Different Formats
  • Sharing a Workbook
  • Exercise 15 with Solutions
  • BONUS LECTURE AND COURSE CLOSURE
  • Bonus Lecture and Course Closure
Completion rules
  • You must complete the units "An Introduction to Excel for Beginners, Launching Excel, Introduction to the Excel Interface, Ribbons and Tabs, The Backstage Area, The Quick Access Toolbar, Useful Keyboard Shortcuts, Working with Templates, Getting Help, Status Bar, Contextual Menus and the Mini Toolbar, Working with Workbooks and Worksheets, Saving your Excel Spreadsheet, Custom Lists and Series Fill, Introduction to Functions and Formulas, Entering and Editing Data, Basic Number Formatting, Navigating and Selecting Cells and Ranges, The Order of Calculation, Counting Items in a List, Finding Averages, Finding the Minimum and Maximum Value, Using Multiple Functions in a Formula, Errors in Calculations, Relative, Absolute and Mixed Referencing, Creating Named Ranges, Managing Named Ranges, Using Named Ranges in Formulas, Named Ranges Tips and Tricks, Exercise 01 with Solutions, Exercise 02 with Solutions, Exercise 03 with Solutions, Exercise 04 with Solutions, Formatting Numbers, Formatting Dates, Applying Formatting to Cells, Formatting Columns and Rows, Alignment, Deleting and Clearing Formatting, Themes and Styles, Using the Format Painter, Exercise 05 with Solutions, How to Structure a List, Sorting a List (Single-level sort), Sorting a List (Multi-level sort), Sorting using Custom Lists, Using Auto-Filter to Filter a List, Format As a Table, Creating Subtotals in a List, Flash Fill, Exercise 06 with Solutions, Cut Copy and Paste Basics, Paste Options, Using the Clipboard, Linking to cells in other Worksheets, 3D Referencing, Inserting Hyperlinks to Worksheets, Exercise 07 with Solutions, The VLOOKUP Function (Exact Match), The VLOOKUP Function (Approx Match), The HLOOKUP Function, Error Handling in Formulas, Logical Functions - Part 1, Logical Functions - Part 2, COUNTIF and SUMIF, Text Functions, Date and Time Functions, Exercise 08 with Solutions, Creating Charts to Present Data, Formatting a Chart, Other Useful Charts, Updating Charts, Exercise 09 with Solutions, Sorting Data, Filtering Data, Exercise 10 with Solutions, Highlight Cell Rules, Data Bars, Color Scales, Icon Sets, Exercise 11 with Solutions, Inserting Pictures, Inserting Shapes, Inserting Icons and 3D Models, Inserting SmartArt, Inserting Screenshots, Inserting Comments and Notes, Exercise 12 with Solutions, Workbook Views, Zooming in and Out of a Worksheet, Arranging Workbooks and Worksheets, Freezing Panes, Exercise 13 with Solutions, Margins and Orientation, The Print Area, Page Breaks, Print Titles-and-Background, Headers-and-Footers, Printing a Workbook, Exercise 14 with Solutions, Protecting Workbooks and Worksheets, Spell Checking, Inspecting the Workbook, Saving in Different Formats, Sharing a Workbook, Exercise 15 with Solutions"
  • Leads to a certificate with a duration: Forever
Back