Manage data and create stunning spreadsheets and graphs in minutes

What you will learn

Design an Excel Spreadsheet for business or life style goals

Document layout and design skills

Calculation skills

Description

Are you a beginner when it comes to using spreadsheets in the workplace? Do you need to learn how to create basic spreadsheets to stay on top of your tasks? If so, our course is perfect for you!

No knowledge of Excel is required.

In this course, you will learn the basics of creating and editing spreadsheets using Microsoft Excel. You’ll start with the fundamentals, including:

  • Entering and formatting data
  • Using formulas and functions
  • Creating charts and graphs
  • Managing and sorting data.

    Easy tips show you how Excel can make your office work easier.  Then learn complex skills fast from scratch. The top features of Excel are also covered including Macro functions, VLOOKUP, Pivot Table, Table formatting and Slicers.

At the end of the course you can design spreadsheets to input data in an efficient way.

Create functions automatically using the Sigma icon.


Get Instant Notification of New Courses on our Telegram channel.


Understand different types of data.

Use simple formulae to add subtract multiply and divide cells.

By the end of this course, you’ll be able to apply your newly-acquired Excel knowledge to your everyday workplace tasks, such as tracking expenses, creating budgets, and managing data. You’ll be a valuable asset to any workplace that relies on spreadsheets!

Use your basic knowledge of word processing to gain an understanding of how an Excel Spreadsheet works.

Don’t miss out on this opportunity to add Excel to your skillset. Enroll in our Udemy course today and start streamlining your workplace tasks with ease!

English
language

Content

Introduction

Introduction
Setting up your Spreadsheet with Quick Access Toolbar
Opening Up Excel
Adding style to your Excel document
Adding Colour to a Spreadsheet

Using Filters and Writing Formulae

How to create simple formulae
How to write divide, subtract and multiply formulae
Basic Formulas in Excel
How to filter and sort data

VLOOKUP functions

How to use VLOOKUP
VLOOKUP questions
Formatting Cell Styles in Excel

Format Tables to Summarise Data

Advanced settings for viewing Excel Spreadsheets
How to format a table and use functions
Table format quiz

Advanced Snapshots of data – Using Slicer and PivotTable

How to use slicers and charts
How to Create a Pivot Table
Slicer and Pivot Table Quiz

Macro

How to Record a Macro
Macro Quiz