Microsoft Excel Beginner Course - Introduction Excel
3.9 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
388 students enrolled

Microsoft Excel Beginner Course - Introduction Excel

Learn Microsoft Excel skills that will give you a solid foundation throughout your Excel career.
3.9 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
388 students enrolled
Created by Deepali Sharma
Last updated 10/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 3 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • After completion of this Microsoft Excel Beginner Course you will have mastered the above Excel concepts and will be able to complete the fundamental day to day tasks of an Excel worker.
  • Also Two project based examples are provided in the course where you will be able to build and learn along, also practice files are provided so that you can practice every lecture along.
  • Working With Microsoft Excel Fundamentals
  • Excel Shortcut
  • Working with Numeric Data in Excel
  • The structure of an Excel Function SUM, AVERAGE, COUNT and More
  • Using the AutoSum Command
  • Changing the Width and Height of Cells
  • Format Data in an Excel Worksheet
  • Inserting Images and Shapes
  • Creating Basic Charts in Excel
  • How to Printing an Excel Worksheet
  • Excel Templates
  • Creating Templates
  • Calculating Monthly Budget Project
  • Student Performance Project
  • And lot more
Requirements
  • You will need Excel loaded on your computer in order to follow along and complete the exercise files provided in each section.
  • Videos have been recorded using Excel 2016, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.
  • No prior knowledge is required ill be teaching you from scratch.
Description

Quickly Learn Excel Basics Get Working with Excel.

-------------------------------------------------------------------------------

During this Microsoft Excel Beginner Course - Introduction Excel you will build a solid foundation on which you will be able to learn, grow more and be able build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, exercise files included, through the basics of working with the most powerful spreadsheet tool on the market. In very little time you will master the basics of Excel that'll provide a foundation for more advanced Excel techniques (Course: Microsoft Excel beginner Course - Introduction Excel, (Microsoft Excel Intermediate Course - More Excel, Microsoft Excel Advance Course - Master Excel and Microsoft Excel Expert Course - Expertise Excel  (Up Next)).

Each section in this course will introduce you to a key foundational Excel concept that you will quickly master.

  • Understanding the Excel Interface and Document Structure

  • Entering and Working with Data in an Excel Worksheet

  • Working with Formulas and the most common Excel Functions

  • Formatting Your Excel Data to make it more Presentable

  • Creating and Working with Excel Charts to Visually Present Data

  • Preparing Your Excel Documents to be Printed

  • Connecting with cloud service.

  • Creating an Excel Template for Easy Reuse


At completion of this Microsoft Excel beginner Course - Introduction Excel you will have mastered the above Excel concepts and able to complete the fundamental day to day tasks of an Excel worker.

Each section also includes quiz to test the knowledge you will gain and exercise files for you to download and practice with. These are the same files that are used in the video lectures. So that you can work along while watching the video lectures.

So, what are you waiting for, enroll now and build a solid foundation within Microsoft Excel.

Who this course is for:
  • Microsoft Excel Beginner Course was designed for those who are just starting out in Excel or for those that are looking to refresh their own skills and pick up some shortcuts Excel. This course is best for beginners.
Course content
Expand all 79 lectures 05:11:52
+ Microsoft Excel Course Introduction
1 lecture 01:52

This lecture provides you information about Microsoft Excel 2016. Its an Introduction towards the latest features of Microsoft Excel 2016.

Preview 01:52
+ Working With Microsoft Excel Fundamentals
4 lectures 05:36

In this lecture I have provided you practice files so that you can work along with me as the lecture progresses. you can also build the document along way. Also I have provided you link to download the trial version of Ms Excel.

Introduction to Course Exercise Files
00:29
Contacting Your Instructor
00:49

In this lecture you will learn how to open Excel or Launch excel on you computer system.

Launching Microsoft Excel 2016
01:20
Important Message About Udemy Reviews
02:58
+ Microsoft Excel Beginner Course Introduction
6 lectures 22:21

This lecture introduces you to the excel interface what all are there in the excel interface.

Introduction to the Excel Interface
07:28

This lecture is about Quick Access Toolbar. It is a tool bar where you can add and remove features that can be used as a quick access tool in your MS Excel Interface.

Customizing the Excel Quick Access Toolbar
03:09

This lecture tells you about the Structure of Excel Workbook and how you will be working on it.

Preview 04:40

As all the other software this Microsoft Excel also provides you the saving option. Have a look at it, and get to know how to save a Excel document.

Saving an Excel Document
04:26

this lecture shows how to open an existing excel document

Opening an Existing Excel Document
01:22

This is an article about Microsoft Excel Shortcut Keys. Using shortcut keys is a good habit as it speedups your work and make your work flow easy.

Common Excel Shortcut Keys article
01:16
Excel Fundamentals Quiz
5 questions
+ Entering and Editing Text and Formulas
7 lectures 47:46

This lecture provides you the guiding on how to create title of an excel document.

Preview 07:27

This is all about entering numeric data in an Excel Worksheet and what is the difference between a text data and a numeric data.

Preview 05:57

How to Enter date Value, learn about dates the important part in Excel Document Development.

Entering Date Values in Excel
05:43

This lecture provides you information on how to create cell references. and what is a cell reference? How to Create or change a cell reference. A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. 

Preview 04:35

Learn about Excel formulas start with a basic once.

Creating Basic Formulas in Excel
08:38

relative reference in Excel is a cell address without the $ sign in the row and column coordinates, like A1. When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns. By default, all references in Excel are relative

Relative Versus Absolute Cell References in Formulas
11:28

PEMDAS along with the phrase "Please Excuse My Dear Aunt Sally"  learn more about it.

Understanding the Order of Operation
03:58
Entering and Editing Text and Formulas Quiz
5 questions
+ Working with Basic Excel Functions
7 lectures 35:51

Here you will learn about the structure of an Excel Function.

=

Function Name

(Arguments)

Example:

=SUM(A5:A20)

The structure of an Excel Function
04:48

The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges or a mix of all three.

For example:

  • =SUM(A2:A10)

Working with the SUM() Function
09:33

Two of the more useful yet simple functions that Microsoft Excel offers are 'MIN' and 'MAX'. These two functions find the smallest and largest value in an array. It could be an array of constants (literal values) or an array of cells (range of cells). 

Working with the MIN() and MAX() Function
03:14

The Microsoft Excel AVERAGE function returns the average (arithmetic mean) of the numbers provided. The AVERAGE function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel

Working with the AVERAGE() Function
03:44

The COUNT function counts the number of numbers in supplied values. Values can be items, cell references, or ranges. For example, =COUNT(1, 2, "apple") returns 2. And COUNT(A1:A10) will count the number of numeric values in the range A1:A10. 

Working with the COUNT() Function
03:14

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSumExcel automatically enters a formula (that uses the SUM function) to sum the numbers. 

Using the AutoSum Command
06:54

Excel Auto fill - Save Time by Automatically Filling Excel Spreadsheets with Repeat Values or Sequences of Values Using the Fill Handle. 

Using the AutoFill Command to Copy Formulas
04:24
Basic Excel Functions Quiz
5 questions
+ Modifying an Excel Worksheet according to requirements
7 lectures 33:31

This lecture tells you about data moving process from one place to another.

Moving and Copying Data in an Excel Worksheet
07:32

learn the most interesting and exciting part in excel Inserting and Deleting Rows and Columns.

Inserting and Deleting Rows and Columns
09:02

How to change the Width and Height of Cell to make the data fix into the cell.

Changing the Width and Height of Cells
04:39

In this lecture you will learn how to hide and unhide the rows and columns in the excel sheet. It is used when you want to hide some data from any other person accessing the file.

Hiding and Unhiding Excel Rows and Columns
03:18

Be careful while deleting the worksheet because the deleted data in an excel worksheet might be undone but the deleted worksheet is never undone, once its deleted its gone.

Deleting an Excel Worksheet
02:27

In this lecture you will be able to learn about the renamining process of excel worksheet.

Renaming an Excel Worksheet
01:53

This is a process where you can learn how to move and copy an Excel Worksheet.

Moving and Copying an Excel Worksheet
04:40
Modifying Worksheets Quiz
5 questions
+ Learn to Format Data in an Excel Worksheet
9 lectures 35:07

Font Formatting in Excel deals with changing the size of the font of text or numbers in cells in Microsoft Excel. Have a look at the video lecture to know the process.

Working with Font Formatting Commands
04:22

This lecture tells you how to add a background color to a cell. Have a look at the video lecture.

Changing the Background Color of a Cell
03:45

At times we require to make the data look separate from the rest of the data to create a separation among the data borders are used. These borders create separation and also make the document look more presentable.

Adding Borders to Cells
03:45

Currency Values in an Excel Document is an important part as it differentiates the regular data the numeric once from the currency amount in the Excel Sheet.

Formatting Data as Currency Values
06:00

Here you will learn how to calculate percentages.

Formatting Percentages
02:18

What is the use of a Format Painter? Well, The Format Painter is one of the most underused features of Excel. The Format Painter copies formatting from one place and applies it to another. Take a look in the Video lecture.

Using Excel's Format Painter
02:34

Creating styles saves time, you just create style once and can re-use it number of times in your document.

Creating Styles to Format Data
06:42

Merging and Centering cells are required sometimes when you want to align your document heading along the data and make the spreadsheet look more presentable.

Merging and Centering Cells
02:40

Conditional formatting is a feature of Excel which allows you to apply a format to a cell or a range of cells based on certain criteria.

Using Conditional Formatting
03:01
Formatting Data Quiz
5 questions
+ Inserting Images and Shapes into an Excel Worksheet 4 Lectures
4 lectures 21:06

this lecture is all about learning how to insert image in an excel document.

Inserting Images
03:31

This allows us to use images in our excel document.

Inserting Excel Shapes
03:54

Add Shapes to your document and make it look more attractive.

Formatting Excel Shapes
06:00

To choose and insert a SmartArt diagram, follow these steps: On the Insert tab, click the SmartArt button in the Illustrations group. The Choose aSmartArt Graphic dialog box appears. Select a category in the navigation pane on the left followed by the list's or diagram's thumbnail in the center section. 

Working with Excel SmartArt
07:41
Shapes, images in Excel Quiz
2 questions
+ Creating Basic Charts in Excel
6 lectures 27:32

Column charts are used to compare values across categories by using vertical bars. 

Creating an Excel Column Chart
04:30

Ribbon provides various tool to access.

Working with the Excel Chart Ribbon
04:25

Learn how to modify chart according to Data.

Adding and Modifying Data on an Excel Chart
02:29

Format your excel chart make it look more amazing and Catchy.

Formatting an Excel Chart
05:09

How to move your chart form one place to another.

Moving a Chart to another Worksheet
04:44

Learn how to create pie chart and make your document more presentable and professional.

Working with Excel Pie Charts
06:15
Working with Excel Charts and Pie Charts Quiz
2 questions
+ How to Printing an Excel Worksheet
5 lectures 19:39

This section is all about printing learn how to view your document in a print preview.

Viewing your Document in Print Preview
01:44

Learn how to change margins, scale a document for printing

Changing the Margins, Scaling and Orientation
02:57

This lecture is all about working with the page layout view.

Working with Page Layout View
02:34

Learn How to add Header and footer content to your document.

Adding Header and Footer Content
06:09

Define an area to be printed in your document, and print it.

Printing a Specific Range of Cells
06:15
Printing and Excel Worksheet Quiz
1 question