Microsoft Excel - Excel with The Ultimate Excel Course from Udemy

What's inside

Learning objectives

Become more productive at using excel which will save you hours per day & eliminate stress at work!
We teach you how to use excel with confidence that will lead to greater opportunities like a higher salary and promotions!
Increase your excel skills and knowledge within hours which will get you noticed by top management & prospective employers!
Master the basics of excel: how to navigate excel, create a spreadsheet and save your work
Gain confidence with the usage of top 50 excel formulas
Discover multiple ways on how you can maximize vlookup
Learn about the text, mathematical, date and time, logic, financial, informational excel formulas
Use excel tables to give color & analytical power to your boring lists
Use pivot tables to analyze thousands of excel rows & create interactive reports with key business metrics in a flash!

Create interactive excel dashboards that will get you noticed by top management & prospective employers
Create bar, column, pie and line charts in excel
Create 3d maps and use 1-click forecasting in excel 2016
Understand how excel macros and vba work
Learn excel macros and vba through project based scenarios
Create excel macros from scratch using the excel macro recorder
Modify excel macros with custom vba in order to create more dynamic automation
Show more
Show less

Become more productive at using excel which will save you hours per day & eliminate stress at work!
We teach you how to use excel with confidence that will lead to greater opportunities like a higher salary and promotions!
Increase your excel skills and knowledge within hours which will get you noticed by top management & prospective employers!
Master the basics of excel: how to navigate excel, create a spreadsheet and save your work
Gain confidence with the usage of top 50 excel formulas
Discover multiple ways on how you can maximize vlookup
Learn about the text, mathematical, date and time, logic, financial, informational excel formulas
Use excel tables to give color & analytical power to your boring lists
Use pivot tables to analyze thousands of excel rows & create interactive reports with key business metrics in a flash!
Create interactive excel dashboards that will get you noticed by top management & prospective employers
Create bar, column, pie and line charts in excel
Create 3d maps and use 1-click forecasting in excel 2016
Understand how excel macros and vba work
Learn excel macros and vba through project based scenarios
Create excel macros from scratch using the excel macro recorder
Modify excel macros with custom vba in order to create more dynamic automation
Show more
Show less

Syllabus

You'll learn what to expect from the course.

Course Overview

At the end of this section you will be familiar with the Excel dashboard, the tabs and the Excel ribbon, and how to use different Excel templates.

This lecture introduces you to what you're going to learn in the first few sections of the course.

This lecture is a complete tour of the various Excel dashboards and interfaces. It will show you how to use the tabs and ribbons at the top of an Excel workbook, how to navigate the file menu to save, print and customize documents in Excel. And it gives you a tour of the many features and tools available to you in Excel 2016.

Using Excel Templates to Save Time and Effort

The first step to successfully creating your first spreadsheet is opening and saving a document. This lecture will show you how to do that and how to save it to a place where you can find it later.

Quickly learn how to enter data into cells in your worksheet and move from cell to cell.

Learn how to create simple but powerful addition and multiplication formulas. These will prepare you to do the calculations neccessary for the Kitchen Remodeling Cost worksheet later in the course.

In this lecture I'll show you the difference between a workbook and a worksheet. I'll also teach you various ways of moving, copying, renaming and managing your worksheets within, and between different workbooks.

In this lecture I'll show you how to print your work. I'll also show you how to adjust your page layout, page orientation, margins, centering and more so you can make your printed work appear just how you would like it.

Activity. Now it's time to put what you have learned into practice.

Review what you've learned about the basics of Excel.

At the end of this section you will be able to create a Kitchen Remodel Worksheet from scratch, including addition and multiplication formulas and simple formatting to make your spreadsheet look good.

First, in this lecture I'll give you a quick tour of the finished product of the Kitchen Remodel Costs Worksheet. Then I'll show you how to create and format your heading.

Note: You can download the finished worksheet here so you can practice creating and changing the formatting and formulas used in this section.

In this lecture, first, you'll learn how to add subheadings to your columns and format them. Then you'll learn how to enter your list of materials into your first column and sort the list alphabetically.

Now it's time to enter your quantities and costs and format them to look like numbers and dollar amounts.

In this lecture I'll show you how to use the multiplication and addition formulas that we learned earlier to calculate your total costs for each of your materials, as well as a grand total for the entire remodeling project.

In this lecture I'll show you how to do some final formatting to your worksheet. I'll show you how to add a few more colors and add grid lines to your worksheet to define your data a little bit more.

Let's review what you've learned.

At the end of this section you will be able to transform your Excel spreadsheet into a pie chart, a bar chart and a column chart.

Charts take boring data and turn it into a visual story. In this lecture I'll show you some of the possibilities of what you can do with charts and then we'll dive right into creating a chart from our Kitchen Remodel Costs worksheet.

Now that you've created a chart, let's do some formatting to make it look awesome!

In this lecture I'll show you how to resize your chart, change the color and width of your columns, add and delete different elements from your chart and how to change the title. At the end of this lecture you'll be able to create a beautiful, professional looking chart from your spreadsheet.

Use this download to compare what is happening in the lectures with the real thing in Excel.

A bar chart in Excel is basically a column chart turned on it's side. The benefit of a bar chart is that it adds emphasis to differences in values because the bars stretch farther across the page.

In this lecture we'll create a bar chart and we'll do some additional formatting to it to make the data really stand out.

Pie charts are great for showing percentages and how each individual part relates to the whole. In this lecture I'll show you how to create a pie chart in Excel from scratch. I'll also show you how you can easily convert an existing chart, such as the bar chart we created in the previous lecture, into a pie chart to save on formatting.

Line charts are best used to represent the change in a value over time. A good example of this is monthly sales numbers for a whole year. In this lecture I'll first show you how to quickly change our existing bar chart into a line chart. Then I'll show you how to use a new spreadsheet containing dates and sales numbers so you can see the best use of a line chart in Excel.

Let's review what you've learned about charts.

This section introduces you to formulas and functions to prepare you to learn how to use VLOOKUP, SUM, SUMIF, IF Statements, COUNTIF, and more to perform powerful calculations with your data.

This lecture defines a formula and shows you how a formula can help you do calculations in Excel.

A function is a piece of predefined code that you can use as part of your formula to increase the power of your calculations. This lecture shows you the power that a function has over simple formulas. It also shows you where to find functions and how to use them.

In this lecture I break down a basic formula into 6 main parts and show you how each part behaves as part of a formula.

The anatomy of an Excel formula is all of the numbers, words and symbols that make up a formula. These are all very important to understand because it enables you to create, modify or correct formulas to do the big calculations for you, saving you lots of time and effort.

This lecture will answer these questions:

What is the equals sign for in an Excel formula?
What do the parentheses do in an Excel formula?
How do you write the cell reference as a range of cells?
What is an operator?
What order of operations does Excel follow?

This lecture will show you some strategies and shortcuts to quickly and easily select cells for use in your formulas.

Most formulas that you create in Excel reference relative cells by default. However, by creating absolute cell

references you can incorporate a fixed cell into your equation while

still being able to copy the formula to other cells. This lecture

will show you the difference between absolute and relative cell

references, and it will show you

useful ways to use them in formulas.

Let's review what you've learned about formulas and functions.

You should be able to understand the essence of these formulas and use them on a daily basis without memorizing them.

A quick introduction on the Excel Formulas and Vlookup topics with your instructor Bryan Hong.

Download this Exercise File

Quick Tips on how to master these formulas with no need to memorize them.

You will learn the essence of the Top Text Excel Formulas

TEXT: Concatenate Formula

TEXT: Find Formula

TEXT: Left Formula

TEXT: Len Formula

TEXT: Lower Formula

TEXT: Mid Formula

TEXT: Proper Formula

TEXT: Rept Formula

TEXT: Substitute Formula

TEXT: Trim Formula

TEXT: Upper Formula

TEXT: Value Formula

You will learn the essence of the Top Mathematical Excel Formulas

MATHEMATICAL: Average Formula

MATHEMATICAL: Int Formula

MATHEMATICAL: Mod Formula

MATHEMATICAL: Rand Formula

MATHEMATICAL: Round Formula

MATHEMATICAL: Sum Formula

You will learn the essence of the Top Date and Time Excel Formulas

DATE AND TIME: Day Formula

DATE AND TIME: Hour Formula

DATE AND TIME: Minute Formula

DATE AND TIME: Month Formula

DATE AND TIME: Networkdays Formula

DATE AND TIME: Now Formula

DATE AND TIME: Second Formula

DATE AND TIME: Today Formula

DATE AND TIME: Weekday Formula

DATE AND TIME: Year Formula

You will learn the essence of the Top Logic Excel Formulas

LOGIC: And Formula

LOGIC: Countblank Formula

LOGIC: Countif Formula

LOGIC: If Formula

LOGIC: Large Formula

LOGIC: Max Formula

LOGIC: Min Formula

LOGIC: Not Formula

LOGIC: Or Formula

LOGIC: Small Formula

LOGIC: Sumif Formula

LOGIC: Vlookup Formula

You will learn the essence of the Top Financial Excel Formulas

FINANCIAL: Fv Formula

FINANCIAL: Npv Formula

FINANCIAL: Pmt Formula

FINANCIAL: Ppmt Formula

You will learn the essence of the Top Informational Excel Formulas

INFORMATIONAL: Column Formula

INFORMATIONAL: Isblank Formula

INFORMATIONAL: Iserror Formula

INFORMATIONAL: Isnumber Formula

INFORMATIONAL: Istext Formula

INFORMATIONAL: Row Formula

Excel Formula Review

We'll at more advanced examples of VLOOKUP as one of the most used formulas in Excel

We will learn how to search across a Starbucks menu using vlookup

Two lists can be easily compared using vlookup to find out the differences between them.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Strengthen an existing foundation for intermediate learners

Builds a strong foundation for beginners

Taught by x, who are recognized for their work in x

Examines x, which is highly relevant to y

Develops x and y, which are core skills for z

Explores x, which is standard in industry y

Reviews summary

Reliable excel concepts

According to students, learning Excel concepts is clear and concise in this course, making it a reliable choice for Excel beginners.

Concepts are presented simply.

"information has been presented very clearly"

"very clear and easy to follow"

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Excel - Excel with The Ultimate Excel Course with these activities:

Attend the FREE LIVE webinar on Advanced Excel

Show steps

Guided tutorials provide a structured and supportive learning environment to delve deeper into advanced Excel features and techniques.

Browse courses on Advanced Excel

Show steps

Register for the webinar
Attend the webinar live or watch the recording
Take notes and ask questions during the webinar

Complete 10 practice exercises on VLOOKUP

Show steps

Practice drills provide focused repetition to reinforce understanding and improve proficiency in using VLOOKUP.

Browse courses on VLookup

Show steps

Find practice exercises online or in textbooks
Complete the exercises and check your answers
Review the exercises and identify areas for improvement

Complete 10 practice exercises on Pivot Tables

Show steps

Practice drills provide focused repetition to reinforce understanding and improve proficiency in using Pivot Tables.

Browse courses on Pivot Tables

Show steps

Find practice exercises online or in textbooks
Complete the exercises and check your answers
Review the exercises and identify areas for improvement

One other activity

Expand to see all activities and additional details

Show all four activities

Create a step-by-step guide on how to use a specific Excel function

Show steps

Creating content helps solidify understanding of Excel functions by requiring you to break down the steps and explain the process clearly.

Browse courses on Excel Functions

Show steps

Choose an Excel function to focus on
Write out the steps involved in using the function
Create visual aids or examples to illustrate the steps
Share your guide with others for feedback

Career center

Learners who complete Microsoft Excel - Excel with The Ultimate Excel Course will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts collect data and analyze it to help businesses understand their operations and customers. They use Excel to manage and organize data, perform calculations, and create visualizations. This course can help Data Analysts build a strong foundation in Excel, which is essential for success in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Data Analyst

Statistician

Statisticians use Excel to analyze data and draw conclusions. This course can help Statisticians develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Statistician

Operations Research Analyst

Operations Research Analysts use Excel to build models and analyze data to help businesses improve their operations. This course can help Operations Research Analysts develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Operations Research Analyst

Management Consultant

Management Consultants use Excel to analyze data, identify trends, and make recommendations to businesses. This course can help Management Consultants develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Management Consultant

Financial Analyst

Financial Analysts use Excel to build financial models, analyze data, and make recommendations to businesses. This course can help Financial Analysts develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Financial Analyst

Business Analyst

Business Analysts use Excel to analyze data, identify trends, and make recommendations to businesses. This course can help Business Analysts develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Business Analyst

Auditor

Auditors use Excel to analyze financial data and identify risks. This course can help Auditors develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Auditor

Market Researcher

Market Researchers use Excel to analyze data and identify trends. This course can help Market Researchers develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Market Researcher

Data Scientist

Data Scientists use Excel to clean and prepare data, build models, and analyze data. This course can help Data Scientists develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Data Scientist

Pricing Analyst

Pricing Analysts use Excel to analyze data and set prices. This course can help Pricing Analysts develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Pricing Analyst

Risk Analyst

Risk Analysts use Excel to analyze data and identify risks. This course can help Risk Analysts develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Risk Analyst

Quantitative Analyst

Quantitative Analysts use Excel to analyze data and make investment decisions. This course can help Quantitative Analysts develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Quantitative Analyst

Actuary

Actuaries use Excel to analyze data and calculate risks. This course can help Actuaries develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Actuary

Financial Planner

Financial Planners use Excel to create and manage financial plans. This course can help Financial Planners develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Financial Planner

Budget Analyst

Budget Analysts use Excel to create and manage budgets. This course can help Budget Analysts develop the Excel skills they need to succeed in this role. The course covers all of Excel's must-know features, including the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features, and keyboard shortcuts.

See salaries and explore the career path for Budget Analyst