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.

Ask a question

Reviews

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

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Business administration courses, Microsoft Excel courses, Online courses