Course Description

Keen to enhance your Microsoft Excel skills? Then you’ve come to the right place! 

This Microsoft Excel Fundamentals online course is an excellent starting point for those wanting to learn the fundamentals or to fill in your knowledge gaps with Excel. 

 

Designed to provide you with a foundational understanding of the basics of Excel, including format cells, understanding formulas and functions and how to sort and filter data. You'll also learn how to easily create charts/graphs and formatting insights to professionally present your data.

 

Your instructor, Donna Hanson will guide you through a range of topic videos, providing you with real world examples and easy to understand explanations and to make the learning more relevant. Plus, you'll have access to a downloadable workbook, exercise file and access to the resources for twelve months from purchase to enable you to fully embed what you learn.

 

Regardless of if you work for yourself or an organization, or are just looking to consolidate your Excel skills, this Microsoft Excel Fundamentals online course is a terrific way to get started. Sign up now and start your journey to Excel mastery!

 

Topics covered:

  • Understanding how spreadsheets work
  • Creating, naming, hiding and copying worksheets
  • Formatting tips
  • Converting Text to Numbers
  • Understanding formulas and functions
  • Viewing worksheets
  • Printing worksheets
  • Understanding Excel Data Lists
  • Sorting & Filtering Excel Data
  • Custom Sorting
  • Conditional Formatting
  • Plus many more tips and shortcuts designed to make working with Microsoft Excel easy!


Course fee is per user.

If you wish to purchase access for more than 10 staff, contact :

enquiries @primesolutions.net.au for multi-user rates.

Course curriculum

    1. eContent Disclaimer

    2. Course Welcome & Set Up

    3. Excel Fundamentals - Course Workbook

    4. Excel Fundamentals - Demonstration File

    5. Microsoft Excel Fundamentals Framework

    1. Spreadsheet Basics - Set Up

    2. Excel 365 - Mouse Pointers

    3. Excel 365 - Understanding How Excel Treats Data

    4. Excel 365 - Selection Techniques

    5. Excel 365 - How to select all data on a worksheet

    6. Excel 365 - Copying & Pasting Options - Excel to Word

    7. Excel 365 - Copying & Pasting Options - Excel to Excel

    8. Excel 365- Renaming and Coloring Worksheets

    9. Excel 365 - Duplicating or Copying a Worksheet

    10. Excel 365 - Grouping Worksheets

    11. Excel 365 - Display a list of all worksheets

    12. Excel 365 - Page Break Preview

    13. Excel 365 - How to put a phone number in a cell.

    14. 2. Spreadsheet Basics Quiz

    1. Formatting Basics - Set Up

    2. Excel 365 - Format Painter

    3. Excel 365 - Formatting Cells, Changing Fonts and Alignment

    4. Excel 365 - Formatting Numbers in Excel

    5. Excel 365 - Date Formats

    6. Excel 365 - Understanding the # (Hash) Symbols

    7. Excel 365 - How to insert and widen rows & columns

    8. Excel 365 - Converting Numbers Displaying as Dates

    9. Excel 365 - Applying Borders & Shading

    10. Excel 365 - Rotating Text

    11. Excel 365 - Fit to a Page

    12. Excel 365 - Print Titles

    13. 3. Formatting Basics Quiz

    1. Graph/Chart Basics - Set Up

    2. Excel 365 - Understanding Graphs/Charts

    3. Excel 365 - Different Types of Graphs/Charts

    4. Excel 365 - How to create a Graph or Chart

    5. Excel 365 - Modifying Graphs/Charts

    6. Excel 365 - Graphing/Charting Specific Content

    7. 4 . Graphs/Charts Quiz

    1. Formulas & Functions Basics - Set Up

    2. Excel 365 - Formulas vs Functions

    3. Excel 365 - Formula Basics

    4. Excel 365 - Relative vs Absolute Cell Referencing

    5. Excel 365 - Calculating Percentages

    6. Excel 365 - SUM Function

    7. Excel 365 - AVERAGE Function

    8. Excel 365 - Proper Function

    9. Excel 365 - Upper Function

    10. Excel 365 - Lower Function

    11. Excel 365 - TRIM Function

    12. 6. Formulas & Functions Quiz

    1. Data Lists in Excel Basics - Set Up

    2. Excel 365 - Data Lists

    3. Excel 365 - Sorting Data

    4. Excel 365 - Custom Sort

    5. Excel 365 - Filtering Data Using Autofilters

    6. Excel 365 - Remove Duplicates

    7. Excel 365 - Freeze Panes

    8. 5. Data List Set Up Quiz
  • $127.00
  • 61 lessons

Frequently Asked Questions

  • What does lifetime access mean?

    It means access for the lifetime of the course, so you have access to the course and any updates for as long as the course exists.

  • What level is this course?

    The course is designed to cover a range of topics Microsoft Excel users who are either new to Excel, or have never had any formal training need in day to day business operations. It is designed to provide a foundational set of tools and skills everyday users need to work with Excel. If you have been using Excel for a long long time and are familiar with functions such as VLOOKUP, then this course is probably NOT for you.

  • Can I purchase this for more than one member of all my team?

    Absolutely, just email enquiries @ primesolutions.net.au with some details and we will reach out to you. For a small additional fee, we can also offer options such as monthly progress reports and/or topic discussion sheets for building skills in team meetings.

  • Can I complete the program all at once?

    Yes you can complete the program all at once. Although we encourage you to complete it over a few weeks to enable you to try out and embed what you learn.

  • Will I get access to all the course modules straight away?

    Yes, all course modules are available immediately for you to access. Any additional or updated videos and resources will be added from time to time and these will automatically be added to the course when you log in.

  • How much time should I allocate to doing the course?

    Research shows adults learn best in small chunks rather than big blocks. Ideally you should allocate 1-2 hours a week to go through a practical module, try things out and make them part of your Excel tool kit.

  • How long will it take to complete the course

    Because there are 5 practical steps in the Excel Fundamentals Framework, ideally you should aim to go through the program over a 5 week period. This allows time to watch the videos, make notes in the workbook, try topics out in the sample file and test them on copies of your own data.

  • Does the course cover formulas or functions?

    The course covers understanding how formulas work in Excel along with some entry level functions for day to day use as well as some remedial functions useful for analysing data lists.

Productivity Expert Donna Hanson

For the past 20 years, Donna has helped thousands of organisations around the world save time, money, stress and frustration with Microsoft Office products. She is passionate about helping people get things done so they can get back to enjoying life.