Microsoft Excel: Learn Excel from Scratch with Formulas

Oak Academy

Reed courses certificate of completion

Digital certificate - Included

• Welcome to Becoming Excel Superstar Course 02:43

  • 1: intro 01:01
  • 2: What You Will Learn in This Excel 365 Course? 01:42

• What Is Spreadsheet ? 01:26

  • 3: Why Do We Use Spreadsheet? 01:04
  • 4: What Can Be Done by Spreadsheets? 00:22

• Downloading Office 365 06:07

  • 5: How to download Office 365? 02:14
  • 6: Download Options for Office 365 03:53

• Here We Go! Are You Ready To Become Excel Superstar? 09:58

  • 7: Excel 365 - Landing Page Buttons and Blank Workbook 03:29
  • 8: Ribbon and Tabs 01:06
  • 9: Quick Access Toolbar and Status Bar 03:17
  • 10: Workbook, Worksheet 02:06

• Fundamentals of Excel 365 09:31

  • 11: Rows, Columns and Grid Lines, Headings 01:27
  • 12: Cell, Name of Cell 01:28
  • 13: Data Entry 02:28
  • 14: Basic Calculations and Cell References 04:08

• Formatting Cells 13:05

  • 15: Number 03:01
  • 16: Alignment 04:02
  • 17: Font 01:58
  • 18: Border 01:42
  • 19: Color of the Cells (Fill) 02:22

• Supermarket Example 17:38

  • 20: Insert Function and Use Formulas ( Sum, Average, Count Functions ) 07:46
  • 21: Percentage Calculation 02:34
  • 22: Usage of Cursor Types and Auto Fill 04:21
  • 23: Insert, Delete, Hide and Unhide Rows and Columns 02:57

• Fast Formatting - Cells From Ribbon 06:57

  • 24: Number 01:30
  • 25: Alignment (Merge and Center) 02:11
  • 26: Font, Border and Color 03:16

• Fast Formatting - Styles 14:34

  • 27: Conditional Formatting 04:39
  • 28: Format as Table 03:48
  • 29: Cell Style and Format Painter 03:21
  • 30: Move or Copy Sheets and Create Your Template 02:46

• Quick Analysis Feature of Excel 365 08:56

  • 31: Formatting 01:25
  • 32: Charts 05:45
  • 33: Total, Tables, Sparklines 01:46

• Quick Analysis Feature of Excel 365 08:46

  • 34: Online/Offline Picture and Format 01:59
  • 35: Shapes, Icons 02:26
  • 36: Smart Art 02:19
  • 37: Three Dimensional Models and Screenshots 02:02

• Print an Excel Sheet (Page Setup) 05:14

  • 38: Page Tab and Margins Tab 01:59
  • 39: Header/Footer 01:32
  • 40: Print Area 01:43

• Online Spreadsheets 14:23

  • 41: Excel Online 02:44
  • 42: Google Spreadsheets 07:46
  • 43: Main Differences Between Google Spreadsheets and Excel Online 02:39
  • 44: Which One Should I Use? 01:14

• What We Have Learned? 03:43

  • 45: Here Is What We Covered in Excel 365 Course? 03:43

Hello there,

Welcome to my Microsoft Excel: Learn Excel from Scratch with Formulas

In this course, you will learn Excel 365, Microsoft Excel and Google Sheets.

• If you are new on Microsoft Excel and Google Sheets,

• If you know a little about Microsoft Excel and want to take a comprehensive look at it or

• If you also want to learn online spreadsheets, then this course is a great fit for you!

In this course, you will learn Microsoft Excel, Excel Online and Google Sheets and find useful daily life examples that will make you feel comfortable about implementing the course topics in real life.

That`s why you are at a great place to start with Excel 365.

What you will learn?

• Downloading Office 365

• Fundamentals of Excel

• Format Cells Button

• Data Types and Data Entry

• Font, Border, and Color of the Cells

• Copy of Cell Format ( Format Painter )

• Supermarket Example (Some Important Features)

• Creating Formula or Use of Automatic Functions

• Percentage Calculation

• Quick Analysis Feature of Excel 365

• Insert Illustrations

• Online and Offline Picture

• Change Format of Inserted Picture

• Three Dimensional Models

• Screenshots

• Page Layout

• Page Setup

• Adding Background and more...

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy's seasoned instructors' expertise.

This course starts with very basics. You will learn everything with hands-on practices. I'll also teach you the best practices and shortcuts.

Step-by-Step Way, Simple and Easy With Exercises

By the end of the course, you’ll have a firm understanding of Excel 365 and hungry to learn more.

Video and Audio Production Quality

All our videos are created/produced as high-quality video and audio to provide you the best learning experience.

You will be,

• Seeing clearly

• Hearing clearly

• Moving through the course without distractions

You'll also get:

Lifetime Access to The Course

Fast & Friendly Support in the Q&A section

Are you ready to dive in now to my Microsoft Excel: Learn Excel from Scratch with Formulas

We offer full support, answering any questions.

See you in the course!

• Anyone who wants learn Excel
• Anyone who wants to have a firm understanding of Excel 365
• Anyone who wants to become an Excel Superstar
• Anyone who wants to learn the most common Excel functions used in the Office

• A computer or laptop with Internet
• Windows Operating System
• MS Office 365 Installation
• There is no prerequisite for the course. You do not need to know anything in advance to understand the course insights.

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