Expired

# Microsoft Excel Basics: For Home & Office

Deal Score+1
Deal Score+1

## Description

In just 4 Hours learn all the Basics of Microsoft Excel through examples and practice problems that took me Months to learn!!!!!!

This Course is for Complete beginners & people who have some idea of the Excel work interface and are able to carry out simple formula tasks.

If you have lied in your Resume and now you need to learn Excel as fast as possible with proficiency then you have come to the right place!!!

Anyone who completes this course will have knowledge of the following things:

Introduction to interface, view, range, color fill, border, alignment, worksheet, input data, formulas, functions,

Duplicating data & formula, moving & copying data, making copying hiding sheets, sorting, sub

total, grand total, Adding currency sign to data, plotting charts, filter, quick access toolbar, error messages, freezing panes,

Search & find, custom tab, textbox & shape, gridlines, merging cells, find & replace, named ranges, save as types,

Conditional formatting, pictures & icons, number formats, printing area in Excel, custom sorting, Tables,

Text to columns, flash fill.

the formulas that are talked about in this course are:

Sum, average, integer, lookup, maximum, minimum, AutoSum, count, round, if, nested if, count if

Almost every lesson is taught through some example and practice problem for a more clear and advanced understanding of how to use them accordingly.

Also, a few Sheets were developed in this course which will give students of this course an idea of how to make sheets for themselves for their daily work whether it be for personal use or for commercial.

the intro video holds a significant purpose as well the message of that video is:

“Welcome to the Microsoft Excel Full Tutorial series. the intro video is about what to expect from the series and what you can learn from it so you may know what you are getting into and if it’s worth your time or not. I do hope you find the series to be useful for you and decide to see all the lessons I have prepared. and if you think it’s not for you there are other sources you can look from and I am happy that this video saved your time.”

Then the course list of videos will help the students of this course to navigate the course according to their needs. also, the returning students can benefit from the list as well. the list is as follows:

Microsoft Excel Tutorial 

Introduction to Interface: get to know the interface

Microsoft Excel Tutorial 

View, Range, Color fill, Border: learn about view range color fill and border

Microsoft Excel Tutorial [2, A]

Alignment In Excel: learn to fix and adjust alignment.

Microsoft Excel Tutorial 

Worksheet and Input data: learn about types of data that can be inputted.

Microsoft Excel Tutorial 

Introduction to Formula SUM: learn the sum function.

Microsoft Excel Tutorial 

Duplicating data & formula: learn about duplicating data and formula.

Microsoft Excel Tutorial 

More on Duplicating data & formula

Microsoft Excel Tutorial [6, A]

moving and copying data in excel: how to copy and move data in Excel

Microsoft Excel Tutorial [6, B]

Moving around and activating cells using the keyboard in excel.

Microsoft Excel Tutorial 

Making a simple Salary sheet in Microsoft Excel: how to do sorting, how to

calculate subtotal and grand total group wise

Microsoft Excel Tutorial 

Water bill calculation area-wide with chart: learn to apply charts to display

analysis

Microsoft Excel Tutorial 

Making a mark sheet: learn to do average, integer, lookup, and filter

Microsoft Excel Tutorial 

Microsoft Excel Tutorial 

Error Messages in Microsoft Excel: learn about Error messages.

Microsoft Excel Tutorial 

Freeze panes, Max & Min value, Find in Excel: as the name suggests.

Microsoft Excel Tutorial 

Copying worksheets in Excel: copying sheets from workbook to

workbook.

Microsoft Excel Tutorial 

How to create a custom Tab in Excel .: make your own personal TAB.

Microsoft Excel Tutorial 

Textbox & Shape in Excel: learn to use textbox and shape.

Microsoft Excel Tutorial 

How to remove gridlines in Excel .: learn to remove gridlines.

Microsoft Excel Tutorial 

Merging cells & AutoSum: learn to merge cells and AutoSum.

Microsoft Excel Tutorial 

Count & Round Function in Excel: as the name suggests.

Microsoft Excel Tutorial 

Using find and replace: how you can use find and replace.

Microsoft Excel Tutorial 

Named ranges in Excel: learn about named ranges.

Microsoft Excel Tutorial 

Save as Types In EXCEL: learn about a few save as types.

Microsoft Excel Tutorial [21, A]

Introduction to if function: we will learn about the if function.

Microsoft Excel Tutorial 

Conditional formatting: learn conditional formatting.

Microsoft Excel Tutorial 

Using conditional formatting to trace a customers purchase history

Microsoft Excel Tutorial 

Insert pictures and icons: learn about inserting pictures & icons.

Microsoft Excel Tutorial 

Number formats in Excel: learn about number formats.

Microsoft Excel Tutorial 

Print Area in Excel: learn to set up print area.

Microsoft Excel Tutorial 

Custom sorting: learn custom sorting.

Microsoft Excel Tutorial 

Tables in Excel: all about Tables in excel (probably).

Microsoft Excel Tutorial 

Text to Column: learn to spread text.

Microsoft Excel Tutorial 

Flash Fill: learn the magic of Flash Fill.

Microsoft Excel Tutorial 

Data Validation in Excel: learn the powerful & useful data validation.

Microsoft Excel Tutorial [31, A]

Data Validation (part 2

Microsoft Excel Tutorial 

Nested if: learn to put if inside if!

Microsoft Excel Tutorial 

Countif in Excel: learn countif function.

Microsoft Excel Tutorial 

Microsoft Excel Tutorial 

Composite chart and Printing charts: as the name suggests.

Microsoft Excel Tutorial 

Making a mental math Practice sheet in Excel: practice

whatever you have learned

## What you’ll learn

• The Basics of Microsoft Excel
• Formulas such as if, sum, countif, lookup….etc.
• Duplicating data and formula
• Salary sheet making
• Water bill sheet
• Mark sheet making
• Error messages & how to fix them
• Conditional formatting
• Data Validation
• Flash Fill
• Nested if
• Copying worksheets
• Custom Tab creation
• Use of Find and Replace
• Named ranges
• different save as types
• Number formats
• Print area
• Insert pictures and icons
• Custom sorting
• Tables
• Text to column
• Charts and composite chart making

## Requirements

• Have a Computer
• Microsoft Excel 2013 or higher

## Who this course is for:

• Anyone who wants to Learn
×

Tags: