Cademy logoCademy Marketplace
  • Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel - basics to expert
Microsoft Excel - basics to expert
1 / 2

Microsoft Excel - basics to expert

By Vnnergy LLC

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • All levels

Description

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

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

Method of Assessment

To successfully complete the Microsoft Excel course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel course. After successfully passing the Microsoft Excel course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel qualification.

Certification

All students who successfully complete the Microsoft Excel course can instantly download their free e-certificate. You can also purchase a hard copy of the Microsoft Excel course certificate, which will be delivered by post for £9.99.

Frequently Asked Questions

  • How many CPD's or PDUs do I earn from this course?
    25 CPD 's or PDU hours
    Accredited by Project Management Institute (PMI)
  • How many sections and lectures are there?

    17 sections and 108 Lectures, and there are almost a hundred downloadable resources for you to practice.

  • Who is this course for?
    • This course is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today.
    • Master Excel skills which you require in your day to day activity in office.
    • This Microsoft Excel course is designed to enhance your expertise and boost your CV.
    • Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.
  • What are the prerequisites for the course?
    • Internet connection
    • Access to MS Excel on your computer/laptop
    • The Microsoft Excel is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills.
  • What You Get Out Of Studying Microsoft Excel With Vnnergy
    • Free PDF certificate upon successful completion of the Microsoft Excel
    • Lifetime access to Microsoft Excel Course materials
    • Instant assessment results with the Microsoft Excel
    • No hidden fees
    • Full tutor support available from Monday to Friday with the Microsoft Excel
    • Study Microsoft Excel at your own pace
    • Benefit from instant feedback through course resources and multiple-choice assessments
    • Gain a complete understanding of Microsoft Excel
    • Accessible, informative modules taught by expert instructors
    • Get 24/7 help or advice from our email and live chat, WhatsApp teams with the Microsoft Excel
    • Study the Microsoft Excel in your own time through your computer, tablet or mobile device
    • Improve your chance of gaining professional skills and better earning potential by completing the Microsoft Excel

Course Content

Course Introduction
  1. 01-01-An introduction to Excel
Course Resources
  1. Download all Course Resources
  2. Download all Course Exercise files
Excel Basic Skills
  1. 02-01-Launching Excel
  2. 02-02-Introduction to the Excel Interface
  3. 02-03-Ribbons and Tabs
  4. 02-04-The Backstage Area
  5. 02-05-The Quick Access Toolbar
  6. 02-06-Useful Keyboard Shortcuts
  7. 02-07-Getting Help
  8. 02-08-Contextual Menus and the Mini Toolbar
  9. 02-09-Status Bar
  10. 02-10-Exercise 02 and Solution
Creating your first excel spreadsheet
  1. 03-01-Working with Templates
  2. 03-02-Working with Workbooks and Worksheets
  3. 03-03-Saving your Excel Spreadsheet
  4. 03-04-Custom Lists and Series Fill
  5. 03-05-Entering and Editing Data
  6. 03-06-Basic Number Formatting
  7. 03-07-Navigating and Selecting Cells and Ranges
  8. 03-08-Exercise 03 and Solution
Excel formulas and functions
  1. 04-01-Introduction to Functions and Formulas
  2. 04-02-The Order of Calculation
  3. 04-03-Counting Items in a List
  4. 04-04-Finding Averages
  5. 04-05-Finding the Minimum and Maximum Value
  6. 04-06-Using Multiple Functions in a Formula
  7. 04-07-Errors in Calculations
  8. 04-08-Relative, Absolute and Mixed Referencing
  9. 04-09-Exercise 04 and Solution
Named Ranges
  1. 05-01-Creating Named Ranges
  2. 05-02-Managing Named Ranges
  3. 05-03-Using Named Ranges in Formulas
  4. 05-04-Named Ranges Tips and Tricks
  5. 05-05-Exercise 05 and Solution
Formatting Numbers, Cells and Worksheets
  1. 06-01-Formatting Numbers
  2. 06-02-Formatting Dates
  3. 06-03-Applying Formatting to Cells
  4. 06-04-Formatting Columns and Rows
  5. 06-05-Alignment
  6. 06-06-Deleting and Clearing Formatting
  7. 06-07-Themes and Styles
  8. 06-08-Using the Format Painter
  9. 06-09-Exercise 06 and Solution
Working with Excel Lists
  1. 07-01-How to Structure a List
  2. 07-02-Sorting a List (Single-level sort)
  3. 07-03-Sorting a List (Multi-level sort)
  4. 07-04-Sorting using Custom Lists
  5. 07-05-Using Auto-Filter to Filter a List
  6. 07-06-Format As a Table
  7. 07-07-Creating Subtotals in a List
  8. 07-08-Flash Fill
  9. 07-09-Exercise 07 and Solution
Moving and Linking Data
  1. 08-01-Cut Copy and Paste Basics
  2. 08-02-Paste Options
  3. 08-03-Using the Clipboard
  4. 08-04-Linking to cells in other Worksheets
  5. 08-05-3D Referencing
  6. 08-06-Inserting Hyperlinks to Worksheets
  7. 08-07-Exercise 08 and Solution
Useful Functions
  1. 09-01-The VLOOKUP Function (Exact Match)
  2. 09-02-The VLOOKUP Function (Approx Match)
  3. 09-03-The HLOOKUP Function
  4. 09-04-Error Handling in Formulas
  5. 09-05-Logical Functions - Part 1
  6. 09-06-Logical Functions - Part 2
  7. 09-07-COUNTIF and SUMIF
  8. 09-08-Text Functions
  9. 09-09-Date and Time Functions
  10. 09-10-Exercise 09 and Solution
Analyzing Data with Charts
  1. 10-01-Creating Charts to Present Data
  2. 10-02-Formatting a Chart
  3. 10-03-Other Useful Charts
  4. 10-04-Updating Charts
  5. 10-05-Exercise 10 and Solution
Sorting and Filtering Data
  1. 11-01-Sorting Data
  2. 11-02-Filtering Data
  3. 11-03-Exercise 11 and Solution
Conditional Formatting
  1. 12-01-Highlight Cell Rules
  2. 12-02-Data Bars
  3. 12-03-Color Scales
  4. 12-04-Icon Sets
  5. 12-05-Exercise 12 and Solution
Inserting Items into Spreadsheets
  1. 13-01-Inserting Pictures
  2. 13-02-Inserting Shapes
  3. 13-03-Inserting Icons and 3D Models
  4. 13-04-Inserting SmartArt
  5. 13-05-Inserting Screenshots
  6. 13-06-Inserting Comments and Notes
  7. 13-07-Exercise 13 and Solution
Working with Views and Zoom
  1. 14-01-Workbook Views
  2. 14-02-Zooming in and Out of a Worksheet
  3. 14-03-Arranging Workbooks and Worksheets
  4. 14-04-Freezing Panes
  5. 14-05-Exercise 14 and Solution
Page Layout and Printing Options
  1. 15-01-Margins and Orientation
  2. 15-02-The Print Area
  3. 15-03-Page Breaks
  4. 15-04-Print Titles and Background
  5. 15-05-Headers-and-Footers
  6. 15-06-Printing a Workbook
  7. 15-07-Exercise 15 and Solution
Finalising your Spreadsheet
  1. 16-01-Protecting Workbooks and Worksheets
  2. 16-02-Spell Checking
  3. 16-03-Inspecting the Workbook
  4. 16-04-Saving in Different Formats
  5. 16-05-Sharing a Workbook
  6. 16-06-Exercise 16 and Solution
Course closure and Whats next
  1. 17-01-Course Close

About The Provider

Vnnergy LLC
Vnnergy LLC
Mundelein

We (Vnnergy LLC) are a Chicago, USA based training and consulting organization, which has been s...

Read more about Vnnergy LLC

Tags

Reviews

+ Add Review