Intro to MS Excel: Learn Microsoft Excel from Scratch
4.5 (14 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,377 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Intro to MS Excel: Learn Microsoft Excel from Scratch to your Wishlist.

Add to Wishlist

Intro to MS Excel: Learn Microsoft Excel from Scratch

Microsoft Excel (2007, 2010, 2013, 2016)
New
4.5 (14 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,377 students enrolled
Created by Stan K
Last updated 9/2017
English
Price: Free
Includes:
  • 4 hours on-demand video
  • 35 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of the course students will learn how Launch MS Excel, Enter Data, Format a Worksheet, Use Basic Formulas and Functions, Perform Conditional Formatting, Use Linear Fill and Growth Functions, Sort and Filter Data, Summarize Data through Pivot Tables, Most Popular functions, Intermediate Concepts (VLOOKUP, HLOOKUP etc), how to work with Text
  • Practical Examples with Every Lecture
View Curriculum
Requirements
  • MS Excel 2007, 2010, 2013, or 2016 installed on your computer, Basic PC Skills
  • No knowledge of MS Excel is required
  • Only Practical and Most Useful Concepts are covered allowing you to save time
  • Taught by an Industry Professional
Description

• Learn from an Industry Professional: Only relevant and useful concepts are covered allowing you to save time and focus on what is important

• Clear and Concise Explanations: while other courses may over-explain concepts, this course focuses on hands-on practical examples that you can use in real life and on the job. Complete your course with confidence.

• Dozens of practical exercises 

• Beginner and Intermediate concepts covered

- How to open, close, and save files in MS Excel

- Basic calculations, functions, and formulas

- How to properly format your data

- Conditional formatting

- Sort and Filter data

- Pivot Tables

- IF function and Nesting

- Advanced functions including HLOOKUP and VLOOKUP

- Text formulas

- Charts

- Many other concepts and functions

Who is the target audience?
  • Anyone who wants to learn Excel for for day-to-day tasks, small business, personal planning, financial analysis, project management, management reporting
  • The course is also useful for financial industry professionals, project managers, and small business owners
Compare to Other Excel Courses
Curriculum For This Course
36 Lectures
03:47:25
+
Introduction
5 Lectures 17:18
Why you should take this MS Excel Course today!
01:05

• Learn how to open the application

Opening Excel
01:32

• Learn how to enter data into MS Excel Worksheet

Entering Data: Introduction to Data Entry in MS Excel
03:21

Opening, Saving, and Closing
04:53

• Learn addition, subtraction, multiplication, and division in MS Excel

Basic Calculations: Add, Subtract, Multiply, and Divide using Excel
06:27
+
Formatting Data
3 Lectures 18:04

• Learn how to adjust font and color in MS Excel

Font and Color: Change the Font and Color of Your Data
07:04

• Learn how to align data either horizontally or vertically

Alignment: Align your Data Horizontally and Vertically
07:08

• Students are introduced to number formatting options

Number Formats: Display Numbers in an Appropriate Way
03:52
+
Conditional Formatting
1 Lecture 09:23

• Automatically highlight rows or columns based on a certain criteria or condition (Conditional Formatting). The emphasis in on automated processing that does not require manual intervention once the conditional formatting is set (everything is highlighted automatically)

Intro to Conditional Formatting: Highlight Information If a Condition is Met
09:23
+
Working with Cells
1 Lecture 07:12
Insert/Delete/Hide Rows and Columns
07:12
+
Excel Functions and Series
4 Lectures 23:57

• Learn how to use MS Excel function including

- SUM, AVERAGE, MIN (Minimum), MAX (Maximum), and COUNT

Intro to Excel Functions: SUM, AVERAGE, MIN, MAX, COUNT
08:03

• Save time by copying formulas and data quickly and efficiently

• Copy your data and formulas right (Fill Right) or down (Fill Down)

Fill Function Basics: Save Time by Mass Copying Formulas and Text
08:08

• Number thousands of columns and rows in just a few seconds using the Fill Series Option

Fill Series - Linear: Number Your Columns and Rows Efficiently
03:50

• Project investment returns quickly and efficiently using Fill Series Growth function

Fill Series - Growth: Project Investment Returns
03:56
+
Sort and Filter
2 Lectures 16:30

• Sort data in a spreadsheet using various criteria

Sort Data: Sort Alphabetically or Numerically
10:08

• Filter data in a table using various criteria (only filtered data is visible)

Filter Data: Display Only Data that You Want
06:22
+
Pivot Tables: Summarizing Data
3 Lectures 17:39

• Create a summary of your data using a Pivot table

• Summarize your data using different criteria

Creating Pivot Tables: Summarize Your Data Quickly and Efficiently
07:59

• Make adjustments to your Pivot table (summarize data using a different criterion)

• Use the same Pivot table (no need to create a new Pivot table)

Changing a Pivot Table: Produce Different Summaries
04:57

• Filter summarized data within a Pivot Table

Adding Filters to a Pivot Table: Filter Your Summary Table
04:43
+
Working with Text
9 Lectures 33:01

• Convert client names to a proper format using PROPER Function

• PROPER capitalizes first and last name regardless of the initial entry

Correcting Name Entries: PROPER function
02:21

• Join two cells of text into one cell

Joining Text Together: CONCATENATE and Ampersand
05:34

• Find the position of text within another cell

• For example, what is the position of a space in a client's name? This information is required for one of the future lessons (separating a name into first and last name)

Find Position of Text or Character: SEARCH versus FIND
04:41

• Extract a certain number of characters from a client's name using LEFT function

Extract Characters from the Left of Your Text: LEFT Function
01:57

• Extract a certain number of characters from a client's name using RIGHT function

Extract Characters from the Right of Your Text: RIGHT Function
02:05

• Check the number of characters in a text string

Number of Characters in a Text String: LEN Function
01:26

• Separate a client's name into First and Last using LEN, SEARCH, LEFT, and RIGHT

Putting it all together: SEARCH, LEFT, RIGHT, LEN
08:35

• Capitalize a text string/ or make it lowercase

Capitalize Text/Make it Lowercase: UPPER and LOWER functions
01:45

• Delete unnecessary spaces in a text string

Delete Unnecessary Spaces: TRIM Function
04:37
+
Intro to Charts
1 Lecture 14:32

• In this lesson students are introduced to MS Excel Charts

• Learn how to create different charts using MS Excel, as well as change chart options including color, style, and others

MS Excel Charts: Create Charts and Adjust Chart Format and Style
14:32
+
IF Function: Evaluating Numbers, Text, and Logical Statements
4 Lectures 25:33

• Check if a certain condition is true or false using IF function

• Provide different output based on the logical outcome: True or False

Intro to IF Function: Test a Logical Statement and Return a Value
08:04

• Evaluate whether a date or a text is TRUE or FALSE (i.e. meets your condition)

• Provide and output based on whether the logical argument is TRUE or FALSE

IF Function: Evaluating Dates and Text - True or False?
05:49

• Evaluate multiple logical statements within IF using AND

• Check if both statements are TRUE at the same time using AND, and provide an appropriate output

Multiple Logic Tests: IF and AND: Both Logic Tests are True
08:04

• Evaluate multiple logical statements within IF using OR

• Check if at least one logical statement is TRUE using OR, and provide an appropriate output

Multiple Logic Tests: IF and OR: What If Either Statement is True?
03:36
2 More Sections
About the Instructor
Stan K
4.5 Average rating
14 Reviews
1,377 Students
1 Course
Financial Analyst and Excel Enthusiast

Hi Everyone, and thank for taking my course.

Over the last 10 years I have performed various financial analysis roles in the finance industry, and have extensively used MS Excel for financial modelling, management reporting, project analysis, and personal financial planning. I hope to share some of my knowledge with you.