Learn and Use Excel Functions the easy way From An Expert
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.
4 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn and Use Excel Functions the easy way From An Expert to your Wishlist.

Add to Wishlist

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.
4 students enrolled
Last updated 10/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 16 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • You should be farmiliar with using a PC or Mac
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

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 74 Lectures Collapse All 74 Lectures 15:59:30
+
Cell and Cell Ranges
5 Lectures 54:40

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
Preview 15:20

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
Cells and Ranges continue
16:52

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
11:12

More on Cells and Ranges Continue
08:01
+
The Count Function
5 Lectures 51:44

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 count function
09:01

Use of the counta function
07:37

Use of the countblank function
08:25

Use of the countif function
10:42

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.

Use of the countifs function
15:59
+
String Functions
11 Lectures 02:27:41
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
+
Intersection Functions
5 Lectures 01:15:40

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

Use of the Match function
14:46

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

Use of the Index function
14:31

Offset Function
16:27

Offset Function continues
15:53

The Range Intersection command
14:03
+
The Lookup Functions
6 Lectures 01:00:43
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
+
Ranking Functions
4 Lectures 53:33
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
+
Logical Functions
4 Lectures 54:37
The IF function
15:33

The AND function
14:31

The Or Function
18:11

More on the OR function
06:22
+
Average Functions
5 Lectures 53:49
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
+
Sum Functions
7 Lectures 01:31:32
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
+
The Date and Time Functions
15 Lectures 04:00:23
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
1 More Section
About the Instructor
Browning L Fondo (MSc)
0.0 Average rating
0 Reviews
4 Students
1 Course
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.