Microsoft Excel For Beginners - Easy Examples - 40 Minutes

Excel Essential Skills Course covering basic understanding of excel workbook/worksheet, basic formulas and shortcuts

What you'll learn

Basic Microsoft Excel Formulas

Basic Microsoft Excel Shortcuts

Learning about Workbook/Worksheet

Learning about Standard Ribbons

Requirements

No specific skills required, just be able to type in excel.

Description

Welcome to the Excel beginner level skills course. I have more than 9 years of experience in Microsoft Excel and a leading Microsoft Office educational channel so i decided to design a course for excel beginner and intermediate level knowledge individuals.After completion of this course you will gain a variety of essential excel skills as listed below in the content of the course. Included in this course are 10 simple and easy to follow videos.In this tutorial you will learn the most commonly used functions, shortcuts and basic formulas which are required for performing day to day tasks:-Understanding of Workbook and Worksheet-SUM, Division, Percentage, MIN/MAX, IF and other basic formulas-Important Basic Shortcuts-Flash Cell-Net Working Days Calculation-Charts-Protect Excel File-Sort and Filter-Formatting of Data-Understanding of RibbonsAll functions and formulas taught on the course are explained in a simple manner with easy to follow examples and scenarios to make the most of your learning. At the end of the course, you will proficient enough to work in excel.This course is for excel beginner or intermediate level user and will help to understand Microsoft Excel application with simple and easy examples.

Overview

Section 1: Introduction

Lecture 1 Workbook/Worksheet

Section 2: Basic Formulas

Lecture 2 Basic Formulas

Section 3: 15 Useful Shortcuts

Lecture 3 15 Useful Shortcuts

Section 4: Flash Cell

Lecture 4 Flash Cell

Section 5: Net Working Days Formula

Lecture 5 Net Working Days Formula

Section 6: Chart Creation

Lecture 6 Chart Creation

Section 7: Protect Workbook/Worksheet

Lecture 7 Protection of Workbook/Worksheet

Section 8: Sort and Filter

Lecture 8 Sorting and Filtering

Section 9: Formatting of Data

Lecture 9 Formatting of Data

Section 10: Ribbons of Microsoft Excel

Lecture 10 Ribbons of Microsoft Excel

This course is ideal for candidate with beginner to intermediate level knowledge.