Our Pricing

We create our own training manual workbooks, exercise files, educational videos and assessments and provide them directly to you, the student. As a result our overheads and prices are low. Learn more.

At this website we offer the Microsoft Excel COMPLETE training course package, it's ONE price for all 9 Excel courses: see our course prices.

You can access EVERY new Excel course we create during your course access period or FOR LIFE if you choose our popular Lifetime Access option.

Do you have a group of 3 or more people who need to learn Excel (and other courses) at the same time? Take a look at our Group Discount Pricing.

Individual Microsoft Excel Training Courses from $29 each

If you only want to purchase selected, "individual" courses, please see the prices at our New Course Catalogue website. 

Purchasing course-by-course this way can be ideal for CPD training courses and study.

To Recap: WHAT DO YOU GET?

(CLICK HERE FOR YOUR FREE SAMPLE)

The Excel training course contents in detail:

Microsoft Excel (Course 301) — Open and Understand Spreadsheets

Our Microsoft Excel Course 301 will teach you the following about Excel spreadsheets:

• The Excel screen toolbars, formula bar, name box, column and row headings, sheet tabs
• Uses for Excel (Worksheet, Database & Charting)
• Navigating an Excel spreadsheet using keyboard & mouse
• Moving between Excel workbooks
• Selecting (or highlighting) cells, columns and rows & entire spreadsheets within Excel
• Entering information into workbooks and resizing columns using Excel.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Beginners’ Courses (and receive your free sample)

Microsoft Excel (Course 302) — Create & Edit Spreadsheets

Our Microsoft Excel Course 302 expands on your knowledge of Excel spreadsheets by teaching you how to:

• Select cells, columns, rows & ranges using mouse & keyboard within Excel
• Copy / Paste: Drag and drop, from range to range and to other worksheet & different software programs
• Edit cells: entering and modifying, submitting changes, using status bar, escaping formula errors
• Change column width, row height for single and multiple columns & make all columns uniform
• Use the Excel Database: Creating a simple database, database structure, basics for mail merge with Microsoft Word), Inserting and deleting columns, using Undo and redo options
• Manage Excel Autofill: fill numbers, dates, number patterns, days, months and years and much more
• Understand date formatting.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Beginners’ Courses (and receive your free sample)

Microsoft Excel (Course 303) — Formulas, Functions, Formatting

In the Microsoft Excel Course 303 you will learn about:

• Formulas: Entering formulas using keyboard, arrow keys and mouse
• Relative cells references, common formula errors, using multiplication, division and combine two formulas
• AutoCalculate: Create additions and basic functions quickly
• Functions: Intro to functions & function syntax, Autosum, Autosum multiple ranges, intro to basic functions (Maximum, Minimum, Average)
• Functions in more detail: Sum, formula bar, editing functions, F2 key, Autofill to quickly copy functions
• Formatting: How your spreadsheets look, lines, colours, shading, text and number size, font, colour
• Currency formatting, date & text formatting
• Merging cells, centring, alignment formatting fill colour, font colour and borders
  Advanced formatting,  Autoformats, repeat regular actions quickly, format painter.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Beginners’ Courses (and receive your free sample)

What’s in the Microsoft Excel Intermediate Courses:

Microsoft Excel (Course 304) — Viewing & Printing

In Microsoft Excel Course 304, learn all about:

• Views:  Zoom (set and custom), Print preview and Page Break preview versus Normal view
• Page Setup: Page orientation, scaling & margins
• Print areas: Setting & clearing defined print areas, differences with default & set page breaks; inserting & moving page breaks
• Changing the print order of pages; centring the spreadsheet when printing; showing/hiding gridlines & headers
• Introduction to headers and footers, using preset & custom headers & footers; using file information & common fields
• Freezing panes when viewing to keep headers visible while scrolling; repeating rows to keep headings printed on every page, and other printing options.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Intermediate Courses

Microsoft Excel (Course 305) — Charts & Graphs

Our Microsoft Excel Course 305 takes you through using Charts and Graphs, including:

• Charting: Creating a simple chart see charts change (dynamic) based on information entered in cells
• Inserting labels for heading, the x & y axis, values
• Charting multiple rows and columns; organising sheet tabs for new chart sheets
• Changing data ranges in the chart wizard; charting several separate data ranges; charting options & charts types (eg. pie charts)
• Chart formatting: understand chart objects for formatting; chart toolbar buttons and using right-click to format
• Formatting a data series and parts of a pie chart; having two different data formats within the one chart and how to get charts into Microsoft Word documents.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Intermediate Courses

Microsoft Excel (Course 306) — Intermediate Functions & Cell Referencing

After the Microsoft Excel Course 306, you’ll be proficient in:

• Number & percentage formatting: Use percentage formatting to better use them in formulas and functions
• Understand cells formatting (even without data in them)
• Relative & Absolute Cell references: How relative cell referencing works when copying formulas & functions quickly (and when they don’t work and why)
• Use Absolute cell referencing to reduce the amount of calculations in a spreadsheet
• Learn and understand fundamental mathematical functions (skills that make more complicated functions easier to understand)
• Combine two formulas into one and write better formulas and get to know the order of mathematical calculations
• Using Functions like Maximum, Minimum and average
• Understand the “Insert Functions dialog box”,  search for functions and understand “arguments” (or syntax) in functions and function categories such as financial, Date and time, maths and trig
• Understanding and constructing an IF Statement
• Comments: Uses for comments. Insert comments to explain the purpose of a cell, choose size and location of the comments and control the way they appear on the spreadsheet; edit comments & change comment formatting
• Show/Hide Columns/Rows: hide columns or rows with confidential information. Print the spreadsheet without the confidential information.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Intermediate Courses

What’s in the Microsoft Excel Advanced Courses:

Microsoft Excel (Course 307) — Databases, Filter/Sort, Named Ranges

Microsoft Excel Course 307 takes you further into:

• Excel program options, automatic calculation, error checking rules, customising the ribbon and quick access toolbar
• Format & structure of databases: delimiters, headers, records, fields, flat file vs relational data
• Filtering and sorting data and different data formats like Comma Separated Values (CSV), TXT, Tab separated values and how to open data in different programs
• Naming Ranges and using Named Ranges in formulas. Data validation and drop down lists and mastering find and replace.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Advanced Courses

Microsoft Excel (Course 308) — Pivot tables, 3D Formulas, Advanced Formulas and Protection

The Microsoft Excel Course 308 will teach you how to:

• Understand 3D formulas between worksheets
• Clean up data using advanced filter
• Create a pivot table and change the value field settings, create a pivot chart to visually show the stats
• Use advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX
• Navigate advanced functions within functions (Nested Functions) and how to protect the worksheet and workbooks.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Advanced Courses

Microsoft Excel (Course 309) — Goal Seek, Data Consolidation and Solver

Microsoft Excel Course 309 advances you in how to:

• Find out how much you can afford to pay for a house using goal seek and financial functions
• Consolidate the information from several sheets
• Use data grouping
• Use solver to explore possible outcomes depending on input variables.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Advanced Courses

Want to know even more?

Read the FULL STORY about our Excel training courses