Free Online Microsoft Excel 2013 Intermediate Training Course | Alison

The New Alison App has just launched Download Now

Microsoft Excel 2013 - Intermediate Course

Master using formulas and functions to make Excel work for you with this free online Excel Intermediate course.

Software Tools
Free Course
This free online Microsoft Excel 2013 intermediate course starts where our Microsoft Excel 2013 for Beginners course finishes. It will introduce you to a number of basic Excel concepts such as commenting, navigating the workbook, and working with printing. You'll get an overview of the formulas and functions used in excel, learn the tips and tricks in working with multiple workbooks and finding errors, and study Excel as a Data Analysis tool.
  • Duration

    1.5-3 Hours
  • Certification

  • Mobile Friendly

  • Publisher

  • Accreditation






View course modules


This free online Excel 2013 Intermediate course starts by looking at the different views that Excel has, which is useful when you need to print specific parts of a spreadsheet or when you're looking at large files. The course then moves onto explaining how formulas work in Excel and how to work with multiple workbooks at a time.

Next, the course introduces you to incredibly useful functions in Excel like Find and Replace and Conditional Formatting. The course goes into depth on how to create great looking charts and graphs in Excel to help you bring your data to life - essential for any Excel user. You'll then learn about some of the most used Excel functions, specifically Lookup functions (VLOOKUP) and logical functions (IF).

Finally, the course starts you on your journey to really using Excel as a Data Analysis tool and you'll learn how to share and protect your workbooks for when multiple people are accessing them. Start this course today - You've learnt the basics, now it's time to take your Excel to the next level.

Start Course Now

Learning Outcomes

Having completed this course you will be able to:

  • Describe how to work with comments in Excel
  • Explain how to use all the different Excel views including Print Preview
  • Describe how formulas work
  • Create awesome looking charts and graphs in Excel
  • Explain how to use functions like VLOOKUP, Text functions and Logical functions like IF
  • Describe how to use Excel to perform data analysis
  • Discuss working with multiple workbooks


All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire an official Certificate, which is a great way to share your achievement with the world. Your Alison Certificate is:

Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning

Alison offers 3 types of Certificates for completed Certificate courses:

Digital Certificate - a downloadable Certificate in PDF format, immediately available to you when you complete your purchase
Certificate - a physical version of your officially branded and security-marked Certificate, posted to you with FREE shipping
Framed Certificate - a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with FREE shipping

All Certificates are available to purchase through the Alison Shop. For more information on purchasing Alison Certificates, please visit our FAQs. If you decide not to purchase your Alison Certificate, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certificate pricing, please visit our Pricing Page.


    You have received a new notification
    Click here to view them all