Free Microsoft Excel Courses Online UK: Mastering Advanced Data Management and Charting

Are you looking to improve your skills in Microsoft Excel? Do you want to learn how to create professional-looking charts, manage large datasets, and utilize advanced features of the software? Look no further! This comprehensive guide will walk you through the basics of creating charts in Microsoft Excel, as well as provide tips and tricks for mastering advanced data management.

Creating Charts in Microsoft Excel

In this section, we'll cover the fundamentals of creating charts in Microsoft Excel. You'll learn how to:

* Insert pivot tables and charts into your Excel sheets

* Add and delete data series within a chart

* Change the design of a chart after it's been created

* Format and position the chart axis, title, and legend

Formatting Charts

Once you've created your chart, it's time to make it look professional. In this section, we'll cover various formatting options for charts, including:

* Linking cells, charts, etc.

* Combining data from various cells into a single cell

* Applying single or multiple filters to data

* Hiding and unhiding rows, columns, and worksheets

Advanced Data Management

In this section, we'll dive deeper into advanced data management techniques in Microsoft Excel. You'll learn how to:

* Repeating rows and columns on printed sheets for easy viewing

* Using different view options available and understanding their benefits

* Copying and moving charts within worksheets

* Formatting text, color, etc., within a chart

Macros and Logical Functions

In this section, we'll explore the world of macros and logical functions in Microsoft Excel. You'll learn how to:

* Understand and utilize advanced data management techniques

* Use macros and be able to use all logical and statistical functions

* Secure, protect, and customize your workbook

Course Objectives

By the end of this course, you'll be able to:

* Insert pivot tables and charts into your Excel sheets

* Consolidate data and format charts

* Use all advanced formatting and display options

* Use different viewing options

* Prepare and format Microsoft Excel sheets and work with multiple worksheets

In conclusion, mastering Microsoft Excel requires a combination of basic skills and advanced techniques. This course will provide you with the knowledge and expertise needed to take your Excel skills to the next level. Whether you're a beginner or an experienced user, this course is designed to help you improve your productivity and efficiency in using Microsoft Excel.

Free microsoft excel courses online uk