Microsoft Excel for the ABSOLUTE and UTTER beginner

Name: Microsoft Excel for the ABSOLUTE and UTTER beginner
Rating: 4.5 (149 reviews)

Learn from the ABSOLUTE basics to lay a strong foundation in Microsoft Excel

Created byJobin Thomas

Last updated 1/2019

English

What you'll learn

The ABSOLUTE basics to get you started on Microsoft Excel

Course content

7 sections • 32 lectures • 1h 8m total length

Getting started with Microsoft Excel1:30
Learn:
what Microsoft Excel is all about,
what it is used for,
the basic building blocks of Excel
Parts of an Excel window1:57
Learn:
the various parts/ sections of an Excel window
what each section contains
Ribbon - the wardrobe of Excel commands4:18
Ribbon houses all the commands in Excel.
Learn:
where Ribbon is located
what does it contain
how it is organised
how to hide or unhide it
Backstage view or File tab1:50
File tab is the first tab in the Excel Ribbon, just like any other Microsoft Office applications.
Learn:
what backstage view is
what all commands it contains
Quick access toolbar1:37
Quick access toolbar lets us quickly access the Excel commands of our choice.
Learn:
what quick access toolbar is
how to customize QAT by adding and removing commands
Creating a new workbook2:13
Learn how to create a new Excel file, also called a Workbook.
Saving workbook1:00
Learn to save a workbook after you have done some tasks in Excel.
Navigating workbook1:28
Learn how to navigate through the workbook using the mouse or keyboard.
Undo and Redo changes1:01
Learn how to undo the mistakes you made while working on some task in Excel.

Selecting cells3:33
To do anything in Excel – be it entering data, doing any formatting, or anything else - you need to first select one or more cells.
In this lesson you will learn how to:
select individual cells
select multiple cells lying next to each other
select multiple cells that are not next to each other
how to use the mouse or keyboard to accomplish the above
Selecting columns and rows2:27
In the last section, we learned how to select cells and ranges. In this lesson, we will learn:
how to select single columns and rows
how to select multiple columns and rows lying next to each other
how to select multiple columns and rows which are not next to each other
Adjusting column width and row height2:55
Sometimes the data we have entered might be more that the visible space of cells. In this lesson, we will learn:
how to adjust column width,
how to adjust row height,
how to auto-adjust column width or row height,
how to simultaneously adjust width/ height for multiple columns/ rows
how to auto-fit data by changing only the row height, but not the column width (wrap text)
Merge cells1:32
Learn how to merge two or more cells, located across multiple columns and rows, into a single large cell.
Also learn:
how to merge and centre
how to merge cells across columns, but not rows
how to unmerge previously merged cells
Hide columns and rows1:13
Don't want to see a few columns or rows on the screen, but still want to keep them without deleting? Hide them!
Inserting and deleting columns and rows1:55
Learn how to add new columns and rows. Also learn how to delete them.

Entering text in excel2:03
In excel, data can be in many forms – text, number, date, currency, percentage, or something else. In this lesson, we will learn how to enter text data in Excel, using the keyboard.
Entering numbers, currencies, percentages3:32
In the previous lesson, we learned how to enter text in Excel. In this lesson, we will learn how to enter numbers, currencies and percentages. While the basics are same as that of entering text, there are some important things you need to be aware of.
Entering dates1:22
Learn how to correctly enter dates in Excel.
Editing data1:04
Now that you know how to enter data in Excel, let's learn how to edit the data you have already entered.
Delete data0:48
Learn how to delete data you have already entered.

Freezing panes and View options2:49
When you handle large sets of data in a worksheet, some parts of the worksheet might not be visible. Learn how to adjust workbook views in order to see the relevant parts of the workbook.
Sorting data3:04
Learn how to sort the data in order to make it visually easier to look at it.
Filtering data2:55
In large data sets, it will be tough to find the information you need. In this lesson, let's learn how to narrow down the number of rows to see only the information we need.
Creating basic charts1:34
Charting is the simplest form of data visualization. In this lesson, let's learn how to create a simple column chart and line chart.
Conditional formatting2:06
Conditional formatting is a form of data visualization, just like charts. In this lesson, learn how to add conditional formatting to a range of cells.

Cell references1:19
Each cell in the Excel worksheet has a unique address. Learn how to identify cells using cell references.
Introduction to formulas4:11
Formulas are Excel’s in-built calculators. Learn the absolute basics of creating formulas.
Complex formulas4:28
So, now you know how to create a simple formula. Let's learn how to create more complex ones, with multiple operators. Learn the order of operations.

Requirements

Patience to learn from the ABSOLUTE basics

Description

*** One of the most highest rated Microsoft Excel courses on Udemy for beginners! ***

When you learn something, you should learn from the ABSOLUTE basics. Through this course, I'll help you learn Microsoft Excel right from the first principles in the simplest possible way, and build a strong foundation.

Did someone scare you off by saying that it takes months or even years to learn Excel?

Don't lose heart. That's totally wrong.

In this course, every video lesson is delivered in capsule format – just 2 to 3 minutes long - so that you can finish watching the entire course in just over an hour! Or else just watch one video a day and complete the course in 30 days!

But remember - practice a lot more to hard-wire these lessons into your brain. Practice! Practice! Practice!

And then come back and tell me your success story :)

Here are the top skills that you will gain from joining this course:

Understand in depth, the Excel file structure and parts of the Excel window. [This is absolutely, absolutely essential!]
How to navigate through the Excel workbook [Priority number 2!]
Working with cells, columns and rows - including adjusting width & height, merging, inserting & deleting
Entering data - text, numbers, currencies, percentages and dates - and editing as well as deleting data [Dos and don'ts]
Working with data - sort & filter, charts, conditional formatting [These help you dig deep into the data, spot trends, and perform a ton of other analysis.]
Formatting - fonts (style, size, color), cells (fill color, borders) [How you present data to your boss is super-critical!]
Basics of formulas - cell references, formula rules, complex formulas [Learn how to perform computations on data, master the PEMDAS rule, and build complex formulas.]

[This course is useful for all Excel versions - 2007, 2010, 2013, 2016 & 2019]

Who this course is for:

ABSOLUTE and UTTER beginners in Microsoft Excel

Microsoft Excel for the ABSOLUTE and UTTER beginner

What you'll learn

Explore related topics

Course content

Introduction9 lectures • 17min

Working with cells, columns and rows6 lectures • 14min

Entering data in Excel5 lectures • 9min

Font formatting2 lectures • 4min

Formatting cells2 lectures • 3min

Working with data5 lectures • 12min

Introduction to formulas3 lectures • 10min

Requirements

Description

Who this course is for: