Microsoft Excel 2013/6 Intermediate Level

What are the key skills and concepts taught in ZandaX's intermediate Microsoft Excel course?

ZandaX's Intermediate Excel course will teach you key skills in a variety of areas, including file management, formulas and functions, tables, data tools, charts, and sparklines. Here are some of the key concepts covered:

Advanced File Tasks: You will learn how to adjust file properties and security settings to effectively manage your workbooks1. This includes saving and file management, converting and encrypting files, understanding file properties and digital signatures, and ensuring file accessibility and compatibility.

Working with Formulas and Functions: The course covers a range of functions and formulas, including how to use formula controls1. You will learn about formulas with absolute references, autosum functions (SUM & AVERAGE), IF and nested functions, working with named ranges, array functions (SUMIF & AVERAGEIF), formula auditing, and text functions.

Managing Tables in Microsoft Excel: You will learn how to format spreadsheet data as a table and work with its added functionality1. This includes creating Excel tables, working with records and filters, and using advanced filters.

Data Tools in Excel: The course will teach you how to use various data tools, including data validation, consolidating files, and removing duplicates. You will also learn about Text to Columns, Flash Fill, and consolidate.

Doing More with Charts in Excel: You will gain skills in inserting charts, adding elements, and customising chart styles and themes. Additionally, you will explore trendlines, error bars, working with axis options, and advanced chart formatting techniques.

Sparklines: The course will introduce you to sparklines, which allow you to analyze figures and trends within your spreadsheet. You will learn how to create and customise sparklines effectively.

The course is designed for users who already have a basic understanding of Microsoft Excel and want to develop their skills further. The course uses a variety of methods including video lessons, interactive content, quizzes, downloadable exercises, a workbook, and a course certificate.

What type of support materials are included with this course?

Here are the support materials included in the Microsoft Excel 2013/2016 Intermediate course:

Downloadable workbook: The course includes a workbook designed to help you learn and practice the concepts covered. The workbook features:

Demonstrations of how to perform the tasks covered in each lesson.

Space for you to take notes alongside the lessons.

"Skill Sharpeners" to practice and improve your skills.

Downloadable exercise files: The course provides downloadable files that you can use to practice the skills taught in the lessons.

Interactive content: The course uses interactive elements to enhance learning. This includes short quizzes and questions related to the course material.

Course certificate: Upon completion of the course, you receive a certificate as evidence of your professional development.

We highlight the workbook as a particularly valuable resource, emphasising its practical and results-focused approach.

Click here for more Details on ZandaX's Intermediate Excel Course

Click here for our Podcast Discussing the benefits of this Course