Essential Excel: Go From Beginner to Intermediate
4.1 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,770 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Essential Excel: Go From Beginner to Intermediate to your Wishlist.

Add to Wishlist

Essential Excel: Go From Beginner to Intermediate

Get up-and-running with Excel in a quick and practical way.Learn the essentials and get confident with your Excel skills
4.1 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,770 students enrolled
Created by Kareem Elmasry
Last updated 3/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the fundamentals of Excel workbooks.
  • Formatting and styling worksheets.
  • Get working with Functions in Excel.
  • Add charts to workbooks.
  • Use Pivot Tables to gain insights from data
  • Securing workbooks.
  • Feel confident with Excel skills.
View Curriculum
Requirements
  • You need to have Microsoft Excel 2010 or later to follow this course.
  • The course is based on the Windows version of Excel, however, most fundamental features should work fine with the Mac version.
  • This course would start from the very beginning and assumes no prior knowledge of Excel.
Description

Are you a total beginner who haven't used Excel before? Or a beginner who tried to follow tutorials or books, but got confused by the level of details you need to cover? Or even been using Excel at work for some time, but often get stuck at some tasks due to some gap in your knowledge?

You've come to the right place! This course was designed with everyone in mind! Even if you haven't used Excel before, this course is for you!

This course will start from the beginning, covering the fundamentals, and equip you with the tools you need to get up-and-running working with Excel. 

By the end of this course, you'll be able to accomplish most tasks you would face at your work, and at the same time, you will be ready to take more advanced level Excel tutorials should you wish to.

Who is the target audience?
  • This course is designed for anyone with little to no prior Excel knowledge who wants to reach an intermediate level of Excel proficiency.
Compare to Other Excel Courses
Curriculum For This Course
26 Lectures
02:37:11
+
Introduction to the Course
3 Lectures 02:53


This text lecture will cover the technology requirements for this course.

Preview 00:18
+
Worksheet Basics
7 Lectures 39:18

In this lecture let's have a walkthrough around the Excel user interface.

Preview 03:17

Cells are the building blocks of an Excel worksheet, let's take a look at how to work with it.

Cells 101
03:50

In this lecture we will explore the options we have to format cells.

Formatting Cells
09:48

Here we will explore one more quick and powerful formatting tool. It allows us to quickly format a range of data as a table.

Formatting a Range as a Table
05:54

In this lecture, we will discover the options to customize the layout of the worksheet.

Page Layout
04:49

In this lecture, we will take a quick look at the reviewing and proofing option.

Reviewing Workbooks
04:27

Let's take a quick look at the options available under the View tab in the ribbon.

View Options
07:13
+
Formulas and Functions
7 Lectures 50:06

It's time for formulas and functions! Let's first start by learning how to type simple formulas.

Preview 04:52

Functions are built-in formulas in Excel which we can use to quickly get calculations done on our data.

Inserting functions
04:50

Now, let's explore some of the important and very useful functions we have to manipulate text.

Text functions
08:17

If function is a very powerful tool to use in Excel. Let's get started with it!

IF Function
09:40

SUMIF is a function that allows us to calculate the total of some cells in a range only when a certain criteria is met.

Using SUMIF
05:27

Let's now explore the popular and very powerful function VLookup. It allows us to find a value in a column, then return another value in a different column on the same row.

VLookup Function
09:03

In this lecture, we will learn the difference between a relative reference and an absolute reference in a formula. It's a very important concept that you need to learn in order to work better with formulas and functions.

Relative and Absolute References
07:57
+
PivotTables
2 Lectures 21:10

Now let's explore PivotTables. PivotTable is a nifty tool that allows us to summarize a large dataset into a table that we can customize the way data is summarized and shown in it and at the same time we can get meaningful insights from our data.

Inserting PivotTables
11:03

In this video, we will explore some of the formatting options we have for PivotTables.

Formatting PivotTables
10:07
+
Charts
2 Lectures 12:21

Time to work with Charts! Charts can add a visual representation for your data and a professional touch as well!

Inserting Charts to Worksheets
04:33

Here we will explore some of the formatting options we have for Charts.

Formatting Charts
07:48
+
Securing Workbooks
1 Lecture 06:15

Protecting workbooks is very important if you're going to share it with other users. In this lecture, we will explore the options we have in Excel to protect our workbooks.

Protecting Workbooks/Cells and Formulas
06:15
+
Working with Data
3 Lectures 24:40

Filters allows us to narrow down data based on a certain criteria. Let's see how it works!

Using Filters
09:14

Another powerful tool to work with data is Sorting. It allows us to rearrange the data based on the criteria we set.

Sorting Data
08:32

Have you received some data that you copied to Excel only to find that it all appear on a single column/cell? Text to Column gives you the power to break this data into multiple cells.

Using Text to Column Feature
06:54
+
Conclusion!
1 Lecture 00:28

Congratulations! You've made it to the end of the course!

Thank You! and Suggesting New Content
00:28
About the Instructor
Kareem Elmasry
4.1 Average rating
10 Reviews
1,770 Students
1 Course
Financial Analyst with passion for Excel.

Hi, my name is Kareem. I’ve been working with Excel for the last 20 years, and I’ve always enjoyed teaching people around me how to work with Excel and helping them get better results out of it.

I'm coming from a financial and accounting background, and Excel have always been a vital part of my everyday work.