Skip to content

Microsoft Excel 2019 Basics -

Best Microsoft Courses Office 2019 Excel | Unlimited Support | Completion Certificate included


e-courses4you

Summary

Price
£12 inc VAT
Study method
Online, On Demand What's this?
Duration
2.8 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
Additional info
  • Tutor is available to students

404 students purchased this course

Add to basket or enquire

Overview

E-Courses4you are here to bring you our Microsoft Excel Basics Crash Course!

Learn how to get chart recommendations based on your data, easily spot trends and patterns with data bars, navigate and select cells, open a Workbook, and much more!

With 5 hours of content to take you from a beginner to advanced level, you will be mastering Excel in no time with this crash course.

Sign up now and become a Microsoft Excel pro with E-Courses4you!

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Curriculum

4
sections
54
lectures
2h 51m
total
    • 1: What is Excel 06:32
    • 2: Workbooks 02:46
    • 3: Ribbons 01:22
    • 4: File Menu 03:33
    • 5: Cells & Formatting Data Types 02:33
    • 6: Formula Bar 01:15
    • 7: Name Box 00:56
    • 8: Navigating & Selecting Cells 02:34
    • 9: Getting Started Excel 2019 00:43
    • 10: Opening a Workbook 01:40
    • 11: Manually Entering Data 00:34
    • 12: Autofill 02:18
    • 13: Saving to OneDrive 02:10
    • 14: Closing Workbooks 00:59
    • 15: Using Tell Me or Help 03:27
    • 16: Selecting Non-Adjacent Cells & Entire Sheet 01:40
    • 17: Intro to Cut Copy & Paste 00:36
    • 18: Cut Copy Paste Keyboard Shortcuts 03:41
    • 19: Selecting Non-Adjacent Cells 02:31
    • 20: Cut Copy Paste Ribbon Tools 01:43
    • 21: Cut Copy Paste Context Menu 02:35
    • 22: Selecting using Shift & Arrow Keys 03:05
    • 23: Using Flash Fill 03:00
    • 24: Multiple Columns of Info 03:23
    • 25: Tidying Data 01:45
    • 26: Intro to Autofill 01:49
    • 27: Using Autofill for Sequential Lists 04:55
    • 28: Using Autofill for Spaced Series 04:30
    • 29: Copying with Autofill 05:00
    • 30: Creating a Custom Autofill List 05:19
    • 31: Intro to Find & Replace 00:51
    • 32: Using Find & Replace 12:50
    • 33: Spellcheck in Excel 06:29
    • 34: Undo & Redo in Excel 03:15
    • 35: Inserting & Deleting Worksheets 02:30
    • 36: Inserting Rows & Columns & Hid & Unhide 05:01
    • 37: Adjusting Column Width & Row Height 04:40
    • 38: Intro to Relative & Absolute Cell References 02:14
    • 39: Relative Cell References 02:10
    • 40: Absolute Cell References 06:58
    • 41: Intro to BODMAS 01:34
    • 42: Brackets within a Formula - BODMAS 03:03
    • 43: Additional Brackets - BODMAS 02:12
    • 44: Orders - Summing & Cubing - BODMAS 04:27
    • 45: Multiply & Division - BODMAS 02:09
    • 46: Autocalculate 02:41
    • 47: Add & Subtract - BODMAS 01:44
    • 48: Intro to Functions & Formulas 01:13
    • 49: Insert Functions 05:09
    • 50: Copy Formulas 03:38
    • 51: Intro to Formatting an Excel Worksheet 01:41
    • 52: Fonts & Borders 05:52
    • 53: Fill Colours & Cell Alignment 03:16
    • 54: Number Format & Cell Styles 05:47

Course media

Description

Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Excel is typically used to organize data and perform financial analysis. It is used across all business functions and at companies from small to large.

Level up your Excel skills, with this Microsoft Excel Basics Crash Course!

In just 5 hours, you will delve deep into Excel learning the ins and outs of the program and tips and tricks to help you master it!

Course Topics Covered:

  • Introduction
  • What is Excel
  • Workbooks
  • Ribbons
  • File Menu
  • Cells & Formatting Data Types
  • Formula Bar
  • Name Box
  • Navigating & Selecting Cells
  • Getting Started Excel 2019
  • Opening a Workbook
  • Manually Entering Data
  • Autofill
  • Saving to OneDrive
  • Closing Workbooks
  • Using Tell Me or Help
  • Selecting Non-Adjacent Cells & Entire Sheet
  • Intro to Cut Copy & Paste
  • Cut Copy Paste Keyboard Shortcuts
  • Selecting Non-Adjacent Cells
  • Cut Copy Paste Ribbon Tools
  • Cut Copy Pate Context Menu
  • Selecting using Shift & Arrow Keys
  • Using Flash Fill
  • Multiple Columns of Info
  • Tidying Daya
  • Intro to Autofill
  • Using Autofill for Sequential Lists
  • Using Autofill for Spaced Series
  • Copying with Autofill
  • Creating a Custom Autofill List
  • Intro to Find & Replace
  • Using Find & Replace
  • Spellcheck in Excel
  • Undo & Redo in Excel
  • Inserting & Deleting Worksheets
  • Inserting Rows & Columns & Hide & Unhide
  • Adjusting Column Width & Row Height
  • Intro to Relative & Absolute Cell References
  • Relative Cell References
  • Absolute Cell References
  • Intro to BODMAS
  • Brackets within a Forumla – BODMAS
  • Additional Brackets – BODMAS
  • Orders – Summing & Cubing – BODMAS
  • Multiply & Division – BODMAS
  • AutoCalculate
  • Add & Subtract – BODMAS
  • Intro to Functions and Formulas
  • Insert Functions
  • Copy Formulas
  • Intro to Formatting an Excel Worksheet
  • Fonts & Borders
  • Fill Colours & Cell Alignment
  • Number Format & Cell Styles

Who is this course for?

This course is for anyone who wants to improve their Microsoft Excel skills!

You might be a student, someone going into a new role who wants to learn how to use Excel for your job, or someone who just wants to brush up their skills!

This course will have you understanding everything that Excel has to offer and is open to anyone who wants to improve their skills.

Requirements

All you need is a device to access the course content from and an Internet connection!

(Not essential, but if you have Microsoft Excel to practise on that would be beneficial to you.)

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2025. All rights reserved.