Microsoft Excel Tutorial for Beginners: Lesson 1

[soybean]

Learn MS Excel in 7 Days

Microsoft Excel Tutorial Summary​

---

Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process. This Excel for beginners course will help you learn Excel basics.

 

[soybean]

Nothing! This Free Excel training course assumes you are a beginner to Excel.

Microsoft Excel Syllabus​

Introduction​

Lesson 1 Introduction to Microsoft Excel 101 — Notes About MS Excel

Lesson 2 Excel Basic Formulas — Add, Subtract, Multiply & Divide in Excel

Microsoft Excel Tutorial for Beginners: Lesson 2

How to Do Addition, Subtraction, Multiplication & Division in Excel

carigold.com

Lesson 3 Excel Data Validation — Filters & Grouping in Excel

Microsoft Excel Tutorial for Beginners: Lesson 3

Data Validation in Excel: Filters, Grouping, Sorting Examples In this tutorial, we are going to cover the following topics. Data validation Data filters Group and Ungroup Adding images to spreadsheets

carigold.com

Lesson 4 Excel Formulas & Functions — Learn with Basic Examples

Microsoft Excel Tutorial for Beginners: Lesson 4

Excel Formulas & Functions: Learn with Basic EXAMPLES Formulas and functions are the building blocks of working with numeric data in Excel. This article introduces you to formulas and functions. In this article, we will cover the following topics. What is Formulas in Excel? Mistakes to avoid...

carigold.com

Lesson 5 Logical Functions in Excel — IF, AND, OR, Nested IF & NOT

Microsoft Excel Tutorial for Beginners: Lesson 5

IF, AND, OR, Nested IF & NOT Logical Functions in Excel Things will not always be the way we want them to be. The unexpected can happen. For example, let’s say you have to divide numbers. Trying to divide any number by zero (0) gives an error. Logical functions come in handy such cases. In this...

carigold.com

Lesson 6 How to Create Charts in Excel — Types & Examples

Microsoft Excel Tutorial for Beginners: Lesson 6

How to Create Charts in Excel: Types & Step by Step Examples A picture is worth of thousand words; a chart is worth of thousand sets of data. In this tutorial, we are going to learn how we can use graph in Excel to visualize our data.

carigold.com

Lesson 7 How to make Budget in Excel — Personal Finance Tutorial

Microsoft Excel Tutorial for Beginners: Lesson 7

Excel Personal Finance: How to Create Budget in Excel Template “Money is a tool. Used properly it makes something beautiful- used wrong, it makes a mess!” – Bradley Vinson It takes discipline to use money properly. In this tutorial, we are going to look at how to use Excel for personal finance...

carigold.com

 

[soybean]

Lesson 1

Introduction to Microsoft Excel 101 — Notes About MS Excel

​

Introduction to Microsoft Excel 101: Notes About MS Excel​

In this Microsoft Excel tutorial, we will learn the Microsoft Exel basics. These Microsoft Excel notes will help you learn every MS Excel concepts. Let’s start with the introduction:

 

[soybean]

What is Microsoft Excel?​

Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc. It is compatible with multiple OS like Windows, macOS, Android and iOS.

A Excel spreadsheet can be understood as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row.

 

[soybean]

Why Should I Learn Microsoft Excel?​

We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data. Let’s illustrate this using the following image.

 

[soybean]

Where can I get Microsoft Excel?​

There are number of ways in which you can get Microsoft Excel. You can buy it from a hardware computer shop that also sells software. Microsoft Excel is part of the Microsoft Office suite of programs. Alternatively, you can download it from the Microsoft website but you will have to buy the license key.

In this Microsoft Excel tutorial, we are going to cover the following topics about MS Excel.

• How to Open Microsoft Excel?
• Understanding the Ribbon
• Understanding the worksheet
• Customization Microsoft Excel Environment
• Important Excel shortcuts

 

[soybean]

How to Open Microsoft Excel?​

Running Excel is not different from running any other Windows program. If you are running Windows with a GUI like (Windows XP, Vista, and 7) follow the following steps.

• Click on start menu
• Point to all programs
• Point to Microsoft Excel
• Click on Microsoft Excel

Alternatively, you can also open it from the start menu if it has been added there. You can also open it from the desktop shortcut if you have created one.

For this tutorial, we will be working with Windows 8.1 and Microsoft Excel 2013. Follow the following steps to run Excel on Windows 8.1

• Click on start menu
• Search for Excel N.B. even before you even typing, all programs starting with what you have typed will be listed.
• Click on Microsoft Excel

The following image shows you how to do this

 

[soybean]

Understanding the Ribbon​

The ribbon provides shortcuts to commands in Excel. A command is an action that the user performs. An example of a command is creating a new document, printing a documenting, etc. The image below shows the ribbon used in Excel 2013.

Ribbon components explained​

Ribbon start button – it is used to access commands i.e. creating new documents, saving existing work, printing, accessing the options for customizing Excel, etc.

Ribbon tabs – the tabs are used to group similar commands together. The home tab is used for basic commands such as formatting the data to make it more presentable, sorting and finding specific data within the spreadsheet.

Ribbon bar – the bars are used to group similar commands together. As an example, the Alignment ribbon bar is used to group all the commands that are used to align data together.

 

[soybean]

Understanding the worksheet (Rows and Columns, Sheets, Workbooks)​

A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labelled with letters while rows are usually numbers.

A workbook is a collection of worksheets. By default, a workbook has three cells in Excel. You can delete or add more sheets to suit your requirements. By default, the sheets are named Sheet1, Sheet2 and so on and so forth. You can rename the sheet names to more meaningful names i.e. Daily Expenses, Monthly Budget, etc.

 

[soybean]

Customization Microsoft Excel Environment​

Personally I like the black colour, so my excel theme looks blackish. Your favourite colour could be blue, and you too can make your theme colour look blue-like. If you are not a programmer, you may not want to include ribbon tabs i.e. developer. All this is made possible via customizations. In this sub-section, we are going to look at;

• Customization the ribbon
• Setting the colour theme
• Settings for formulas
• Proofing settings
• Save settings