Excel Level 1 Secrets

Our Excel Level 1 course teaches smart selection, navigation and shortcut techniques to speed up tasks. You’ll learn essential skills to create and manage your own spreadsheets, plus the five key formulas everyone needs. Enjoy expert led training live online via Microsoft Teams with a Microsoft Certified Trainer, and receive a full video recording to revisit every tip anytime, which you may find incredibly useful later on.

Description

Getting started

 

Entering and editing data

 

Modifying a worksheet

 

Using functions

 

Formatting

 

Printing

 

Charts

 

Managing large workbooks

 

Graphics and screenshots

Prerequisites

There are no prerequisites for this course, but you should have used a computer keyboard before, and have basics Windows knowledge.

Similar courses

Become an Excel Ninja as you master working with multiple files and sheets, 3D formulas, links, special formats, collapsing large workbooks, advanced charts, and one‑click tables with built‑in formulas. Enjoy expert‑led online training via Microsoft Teams with a Microsoft Certified Trainer, plus a full session recording to revisit every tip anytime.

More Information

On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! Learn the new XLOOKUP function.

More Information

Knowing your numbers - your core metrics - is absolutely critical to your success. Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one. Let's make one for your business too.

More Information

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use Business Intelligence tools.

More Information

A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

More Information