Microsoft Excel Basics: For Home & Office

person icon Zahed Zisan

Microsoft Excel Basics: For Home & Office

Learn the basics and take your career to the next level

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Zahed Zisan

architecture icon Office Productivity,Microsoft


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course 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 [1]

Introduction to Interface: get to know the interface

Microsoft Excel Tutorial [2]

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 [3]

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

Microsoft Excel Tutorial [4]

Introduction to Formula SUM: learn the sum function.

Microsoft Excel Tutorial [5]

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

Microsoft Excel Tutorial [6]

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 [7]

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

calculate subtotal and grand total group wise

Microsoft Excel Tutorial [8]

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


Microsoft Excel Tutorial [9]

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

Microsoft Excel Tutorial [10]

QAT (quick access toolbar) in Microsoft Excel: learn all about QAT.

Microsoft Excel Tutorial [11]

Error Messages in Microsoft Excel: learn about Error messages.

Microsoft Excel Tutorial [12]

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

Microsoft Excel Tutorial [13]

Copying worksheets in Excel: copying sheets from workbook to


Microsoft Excel Tutorial [14]

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

Microsoft Excel Tutorial [15]

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

Microsoft Excel Tutorial [16]

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

Microsoft Excel Tutorial [17]

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

Microsoft Excel Tutorial [18]

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

Microsoft Excel Tutorial [19]

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

Microsoft Excel Tutorial [20]

Named ranges in Excel: learn about named ranges.

Microsoft Excel Tutorial [21]

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 [22]

Conditional formatting: learn conditional formatting.

Microsoft Excel Tutorial [23]

Using conditional formatting to trace a customers purchase history

Microsoft Excel Tutorial [24]

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

Microsoft Excel Tutorial [25]

Number formats in Excel: learn about number formats.

Microsoft Excel Tutorial [26]

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

Microsoft Excel Tutorial [27]

Custom sorting: learn custom sorting.

Microsoft Excel Tutorial [28]

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

Microsoft Excel Tutorial [29]

Text to Column: learn to spread text.

Microsoft Excel Tutorial [30]

Flash Fill: learn the magic of Flash Fill.

Microsoft Excel Tutorial [31]

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

Microsoft Excel Tutorial [31, A]

Data Validation (part 2

Microsoft Excel Tutorial [32]

Nested if: learn to put if inside if!

Microsoft Excel Tutorial [33]

Countif in Excel: learn countif function.

Microsoft Excel Tutorial [34]

Charts in Excel: learn more about charts.

Microsoft Excel Tutorial [35]

Composite chart and Printing charts: as the name suggests.

Microsoft Excel Tutorial [36]

Making a mental math Practice sheet in Excel: practice

whatever you have learned


What will you learn in this course:

  • 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

  • Quick Access Toolbar

  • 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


What are the prerequisites for this course?

  • Have a Computer

  • Microsoft Excel 2013 or higher
Microsoft Excel Basics: For Home & Office


Check out the detailed breakdown of what’s inside the course

6 Lectures
  • play icon Introduction 09:07 09:07
  • play icon Introduction to Interface 03:16 03:16
  • play icon View, Range, Color fill, Border 05:03 05:03
  • play icon Alignment In Excel 07:54 07:54
  • play icon Worksheet and Input data 02:30 02:30
  • play icon Introduction to Formula SUM 07:57 07:57
4 Lectures
3 Lectures
8 Lectures
12 Lectures
9 Lectures

Instructor Details

Zahed Zisan

Zahed Zisan

Civil Engineer, Instructor, Educational content creator

I am a Civil Engineer. I have worked on more than 11 Academic Projects during my Undergraduate days. I had to use multiple Software and analytic skills to complete those projects. I have also worked and assisted on  Practical projects and research papers. I have also done many Courses from many training institutes and online learning platforms. Instead of making courses to earn money, I make courses to share everything I know and also what I have learned from my experiences so anyone doing my courses will be able to tackle problems with ease that took me a lot of effort to solve.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us