Microsoft Excel For Beginners



Learn the important fundamentals of Microsoft Excel

What you will learn

What is Microsoft Excel

Understanding Excel Workbooks

Navigating in a File

Understanding Worksheets

Rows and Columns

Formatting in Excel

Functions in Excel

Understanding Quick Analysis

Description

In this course, you will learn the important fundamentals of Microsoft Excel, as well as how charts work and how to use them.

Microsoft Excel is one of the most widely used programs for organizing information and data using spreadsheets. This is due not only to the ease of learning and use of the program, but also to the wide range of customization options that it offers.

Excel is used around the world in both professional and private environments, and during this course you will understand why Excel is still one of the most popular and powerful applications.



I use short lectures during the course, giving you the ability to stay focussed and really remember what was taught in each lecture at the end of the lecture.

By taking this course, you will be learning the following aspects of Microsoft Excel:

  • What is Microsoft Excel
  • Understanding Workbooks
  • How to type text and numbers into a worksheet
  • How to use simple formulas in a worksheet
  • Filling a series
  • Inserting and deleting worksheets
  • Copying a worksheet
  • Renaming a worksheet
  • Moving or copying a worksheet to another workbook
  • Worksheet formatting
  • How to freeze rows and columns
  • How to select ranges, rows and columns
  • How to use general formatting
  • Wrapping and merging text
  • Quick Formatting
  • Quick Charting
  • Quick Totals
  • Quick Tables
  • Quick Sparklines
  • Finalizing Workbooks
  • A free bonus lesson for completing the course

I hope you enjoy and happy learning 🙂

English
language

Content

Course introduction

Welcome to the Microsoft Excel for Beginners Course
What you will need and course outline

What is Microsoft Excel

What is Microsoft Excel

Workbooks and Worksheets

Microsoft Excel Workbooks
How to navigate in a file
Typing in a Microsoft Excel Worksheet
How to use simple formulas in a worksheet
Filling A Series
Inserting And Deleting Worksheets
Copying A Worksheet
Renaming A Worksheet
Changing Worksheet Tab Colours
Freezing Rows And Columns
Selecting Ranges, Rows and Columns

Formatting

Understanding Formatting
Applying General Formatting
Changing Fonts and Font Sizes
Borders
Wrapping And Merging Text

Functions

Understanding Functions
Average Functions
Min and Max Functions
Common Error Messages

Quick Analysis

Understanding Quick Formatting
Quick Formatting
Quick Charting
Quick Totals
Quick Sparklines
Quick Tables

Finalizing Workbooks

Finalizing Workbooks

Bonus Section

Bonus Lecture 1

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO

Check Today's 30+ Free Courses on Telegram!

X