What Will I learn?

This course package contains all you need to know about MS Excel 2013, so as you work through it you will become proficient in spreadsheet creation and management. Learners will cover creating worksheets, entering and formatting values, and calculating formulas. As you reach the more advanced course you’ll get to grips with cell properties and styles, sorting and filtering data, and analysing data through created charts.

Who Is This For?

This course is ideal for anyone who works with figures and data entry in their work or personal life. It will benefit learners looking for new job or business opportunities, as well as being useful for personal and business budgeting or calculations. As a package of courses it’s ideal for anyone who wants to quickly cover different levels of MS Excel 2013, and who will benefit from the learn at your own pace, wherever you are ethos.

KEY LEARNING POINTS

Take your knowledge of MS Excel 2013 from beginner through to advanced level.

MS Excel 2013 Introduction

• Get to grips with the MS Excel 2013 user interface.
• Learn how to create tables using easy step by step methods.
• Try entering values into cells correctly.
• Look at cell formatting, including conditional formatting.
• Begin manipulating cells and cell range.
• Become familiar with working in a worksheet and an entire file.
• Learn how to turn your data into a chart.
• Try making calculations using basic MS Excel formulas.

MS Excel 2013 Intermediate

• This course delves further into making calculations.
• Look into logical and text functions.
• Broaden your knowledge of referencing principles.
• Try entering a series of data into worksheet cells.
• Get to grips with advance filter and sort data options.
• Use the search function to find specific values in bigger tables.
• Learn how best to split longer text entries into separate columns within a table.

MS Excel 2013 Advanced

• Learn more about creating charts and how to use them.
• Look at how to automate your work in Excel by using macros.
• Become familiar with inserting graphics into worksheets.
• Look at SmartArt Graphics and shapes and how to use them.
• Prepare a table or work sheet for printing.
• Examine the different ways you can share and protect workbook data.
• Go more in-depth into using macros, especially how to create and edit them.
• Look at the different options for macro security.

ADVANTAGES OF THIS COURSE

• It’s an Official Microsoft Excel course, so you are learning from the best material.
• Each course has a virtual tutor guiding you through the exercises and lessons through written and audio instructions.
• Make the most of the different teaching tools, designed to stimulate through exercises, illustration and quizzes.
• Three automated help options are available if you need assistance completing tasks.
• All your progress and results are stored on the system, so you can easily pick things up where you left off next time you login in for a study session.
• Make use of the search function if you want to tailor your own study sessions.
• If you’re applying for jobs in administration, business, or setting up your own project, then this course will be a great addition to your CV.