Excel

Course details

Cut Excel down to size with our personalised online course. Whether you are a beginner or have been using Excel for years, you can take your spreadsheeting skills to the next level with Skillsology.

Unlock the secrets of Excel and learn:

• How Excel works, how to navigate and design a spreadsheet.
• The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF.
• To use PivotTables, Pivot Charts and Basic Macros.
• To create beautiful looking graphs and charts.
• Formatting, including; conditional, cell and number formatting.
• How to print what you want.

This course is aimed at beginner to intermediate Excel users. If you are brand new to Excel or have a limited knowledge set you want to expand, then this course is for you. The course starts by covering the basics of Excel and then goes into essential formulas and functions. It then takes you through all the tools you will need to perform Data Analysis, including PivotTables and ends by looking at how you present and print your spreadsheets.

This course includes a Filter. This is a diagnostic tool that allows us to identify which parts of the learning are most relevant to you. We do this by stripping out what you know, and what isn't useful to you, using Filtered's US patent pending algorithm. It's optional to use, but if you have used Excel in the past and are not sure where your abilities lie, it will tailor the course to your specific needs.