Learn and Use Excel Functions the easy way From An Expert

The perfect hands-on guide to understanding and using Excel Functions using real world examples.
0.0 (0 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.
3 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 74
  • Length 16 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

This course uses a series of videos and downloadable materials to explain the use of statistical, logical,text etc functions in Microsoft Excel. No previous knowledge is needed as the basics are covered.

The Student will need a desktop of laptop computer with Microsoft Excel installed to get the best out of the course.

The course takes about 10 hours to complete if you just want to watch the videos but (and this is a big but) this is definitely not the approach that i encourage. Instead, the student is advised to download the Excel workbooks that i have included in the course and use them to follow through the videos with. This would give the student the hands-on approach that is most needed and in doing so get the best out of the course. This approach would take 10 days approximately. Remember the old saying that: The best teacher is practice.

I have broken down the course into summation, string, logical and statistical functions.

Understanding Excel Functions is the heart-beat to becoming a top level Data Analyst or Excel Developer

What are the requirements?

  • You should be farmiliar with using a PC or Mac

What am I going to get from this course?

  • Use a great number of Functions found in Microsoft Excel
  • Use the functions to develop Excel Spreadsheets for themselves as well as for others
  • Analyse data using microsoft Excel
  • Summarize data using MS Excel
  • Become very comfortable using MS Excel to solve real world problems

What is the target audience?

  • This course is perfect for people who are new to Excel formulars and functions
  • It is also the perfect strating point for anyone who wishes to develope spreadsheets for others to use.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Cell and Cell Ranges
Intro
Preview
03:15
15:20

This lecture will demonstrate the following :

  • What an Excel Cell is
  • The address of a Cell of made up of
  • What a Cell can contain (Text, number, formular, hyperlink, image)
  • The Active Cell
  • The difference between a Cell and a range
16:52
We will look at the following in this lecture:
  • Selecting complete Rows
  • Selecting complete Columns
  • Selecting the complete Row of the Active Cell
  • Selecting the complete Column of the Active Cell
  • How to select a whole worksheet
  • The difference between a worksheet and a workbook
  • Methods of selecting non-continuous Ranges
11:12

Here, we will look at the different methods of naming cells and Ranges. These would include:

  • Using the name box,
  • Using the define name dialog box and
  • Using the Create from selection method.
  • The lecture would also discuss the importance of scope in the naming of cells and ranges
More on Cells and Ranges Continue
08:01
Section 2: The Count Function
09:01

This video will cover the use of the count function in MS Excel. You will be able to use the function effectively in Excel after completing the course and following on with the downloadable material

Use of the counta function
07:37
Use of the countblank function
08:25
Use of the countif function
10:42
15:59

This function is used when you need to count rows in a given worksheet which meet more than 1 condition or criteria.For example to count the number of women (sex=female) and country of birth USA using data in a spreadsheet which has amongst other columns those of sex and nationality.

Section 3: String Functions
Use of the Upper,Lower,Concatenate and Proper function
07:45
Use of the Search and MID functions
15:24
Use of the LEN, LEFT,RIGHT and Rept functions
10:25
Use of the substitute function
12:50
Use of the Choose function
09:18
Use of the Trim function
13:20
Data Manipulation
18:39
Data manipulation continues
16:00
Data Manipulation Continues
11:39
Data Manipulation Continues
14:30
More On the Choose function
17:51
Section 4: Intersection Functions
14:46

The syntax and use of the Match function would be discussed exhaustively with many real world examples.

14:31

The syntax and use of the index function would be exhaustively discussed

Offset Function
16:27
Offset Function continues
15:53
The Range Intersection command
14:03
Section 5: The Lookup Functions
The Vlookup Function
14:31
The Vlookup Continues...
10:49
Two-Column Vlookups..
08:13
Multiple-Table Lookups
10:14
Short Quiz
06:38
The HLookup Function
10:18
Section 6: Ranking Functions
The Rank Function
15:23
The Rank Function Continues
07:23
The Round, Product, Max and Min Functions
15:14
The Large, Small and Dollar functions
15:33
Section 7: Logical Functions
The IF function
15:33
The AND function
14:31
The Or Function
18:11
More on the OR function
06:22
Section 8: Average Functions
The Average Function
05:57
The AverageIf Function
12:20
The AverageIfs Function
19:20
The Avedev Function
10:35
The Averagea Function
05:37
Section 9: Sum Functions
The Sum Function
04:52
The Sumif Function
17:00
The Sumifs Function
18:58
The Sumproduct Function
06:31
Real World Scenarios
13:35
The SUMSQ, SUMX2PY2, SUMX2MY2 and the SUMXMY2 Functions
16:04
The SUBTOTAL Function
14:32
Section 10: The Date and Time Functions
Date function_1
19:14
Date_function_2
16:24
Date_function_3
17:55
Date_function_tutorial_1
18:07
Date_function_tutorial_2
16:01
Date_function_tutorial_3
18:54
Date_function_tutorial_4
17:51
Date_function_tutorial_5
12:17
Time Functions
13:25
Time_functions_tutorial_1
15:42
time_function_tutorials_2
11:35
time_function_tutorials_3
15:28
Use the Text function
18:43
More use of the Text Function
13:24
Even More use of the Text Function
15:23
Section 11: Bonus Lectures
Dynamic Vertical Range
09:14
Horizontal Dynamic Range
08:35
Dynamic Ranges
11:04
Absolute and Relative Referencing Revisited
11:24
The Value Function
03:25
The N function
12:51
Paste Special
18:35

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Browning L Fondo (MSc), Microsoft Certified Personal (MCP) in Excel Expert

I am an electrical engineer and an IT professional. I hold a masters degree Computer Networks security and Programming. I am also a Microsoft Certified Personal (MCP) in a number of courses including Microsoft Excel at the Expert Level. I also hold the ECDL as an examiner.

I have worked as a Data Analyst for more than five years and in the process have developed all kinds spreadsheets / reports such as dashboards, using Excel as a backend to develop financial applications etc.

I have a solid understanding of mathematics and that has allowed me to be able to make the seemingly difficult concepts in Excel to be quite understandable to many of my colleagues that i have worked with over the years.

My experience in real life situations using microsoft Excel is certainly a key skill that my students will benefit from when they take my course.

Ready to start learning?
Take This Course