A beginners guide to Excel

An absolute beginners overview of how to use Excel and what the software can do.
Rating: 4.3 out of 5 (74 ratings)
1,929 students
English
English [Auto]

A complete overview of how to use Microsoft Excel. I will take you through the software and explain all the menu options and what they do.

Requirements

  • This is for absolute beginners that have little or no experience in Excel

Description

I will take you through all the menu items in Excel and show you what they do and how to use them. This course is aimed at getting you familiar with the functionality of Excel in the shortest possible time. You need no prior knowledge of Excel, this is aimed at absolute beginners that would like to learn how to use Excel from scratch.


Course Overview:

•1. Introduction

      •Introduction PPT

      •Overview of Microsoft Excel

      •Overview of the sample data

•2. File Menu

     •How to open and save a workbook

     •How to print a workbook

•3. Home Menu

     •Cut, Copy and Paste

     •Formatting font, colours and alignment

     •Change formats to number, text, date etc

     •What is conditional formatting?

     •Insert and delete rows and columns

     •Intro to formulas •Sorting and filtering data

•4. Insert Menu

     •Tables and Pivot tables

     •Images and illustrations

     •Charts and sparklines

     •Other insert ribbon options

•5. Page Layout Menu

     •Themes

     •Page setup

     •Change formats to number, text, date etc

     •Other page layout ribbon options

•6. Data Menu

     •Data sources

     •Sorting and filtering

     •Data tools

     •Other data ribbon options

•7. Review Menu

     •Proofing

     •Comments and notes

     •Other review ribbon options

•8. View Menu

     •Workbook views

     •Freeze and split panes

     •Other view ribbon options

•9. Help Menu, Add ins & where to from here

     •Help

     •Add ins

     •Course review

     •Where to from here

Who this course is for:

  • Anyone new to Excel who wants to understand how to use the software. This is to get you comfortable using Excel in the shortest possible time

Course content

1 section9 lectures1h 0m total length
  • Introduction
    02:12
  • File Menu
    06:12
  • Home Menu
    22:02
  • Insert Menu
    08:51
  • Page Layout Menu
    04:22
  • Data Menu
    04:58
  • Review Menu
    03:16
  • View Menu
    04:47
  • Help Menu, Add ins & where to from here
    03:41

Instructor

Owner / Consultant at Featherbrooke Consulting Services
Warren Thomas
  • 4.5 Instructor Rating
  • 156 Reviews
  • 2,215 Students
  • 4 Courses

5 Years’ experience running my own IT consultancy. Consulting to all industries. Over 20 years experience working in systems development and business intelligence. Have worked for market leaders in South Africa and abroad.

Key fields of expertise are:

Project Management

System development

Business Intelligence Dashboard development

MIS and reporting automation

Data analysis

Process mapping and SOP Development

Business and systems analysis