Excel: From beginner to intermediate [Free Online Course] - TechCracked

Learn the skills that Microsoft want you to know in Excel.

What you'll learn

• Create, configure and save Excel worksheets and workbooks.
• Navigate through and format worksheets and workbooks.
• Customise options and views for worksheets and workbooks.
• Configure Excel worksheets and workbooks to print (e.g. page setup).
• Insert data into and format cells and ranges, and create and modify tables.
• Highlight, filter, sort and group cells, ranges and tables.
• Create and format Excel charts.
• Insert and format objects, including modifying images.
• Create formulas in Excel, including using conditional logic and modifying text.

Description

In this 11 hour course, learn how to:

Create and manage worksheets and workbooks

• Create and navigate in Excel worksheets and workbooks,
• Format worksheets and workbooks,
• Customize options and views, and
• Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

• Insert data into and format cells and ranges, and
• Summarise and organize data in Excel .

Create tables

• Create and manage tables,
• Manage table styles and options, and
• Filter and sort a table.

Perform operations with Excel formulas and functions

• Summarize data,
• Perform conditional operations, and
• Format and modify text.
• Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

• Create charts,
• Format graphic elements, and
• Insert and format objects in Excel .

The course will take about 10 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

Also See : Excel Data Analysis Masterclass with Excel Dashboards

Enroll Now