Microsoft Excel - Advanced Formulas And Functions

Advanced Microsoft Excel Formulas And Functions - Take Your Excel Skills To The Next Level
4.5 (65 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.
2,025 students enrolled
$50
Take This Course
  • Lectures 58
  • Contents Video: 5.5 hours
    Other: 1 min
  • 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 9/2013 English

Course Description

This Microsoft Excel Advanced Formulas and Functions training course from Infinite Skills takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel.


You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries.

By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.

What are the requirements?

  • Microsoft Excel 2010 or Excel 2013
  • Windows

What am I going to get from this course?

  • Take Your Excel Skills To The Next Level

What is the target audience?

  • Intermediate To Advanced Users

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: Welcome
Important - Excel - Working Files - Download These First
Preview
Article
0101 How Advanced Is Advanced?
Preview
03:23
0102 Using The Excel Working Files
Preview
01:55
0103 When Is A Formula A Function?
Preview
03:58
Section 2: Getting The Basics Right
0201 Excel - Sum And Count Syntax
06:18
0202 Accessing Unknown Function Syntax Within Excel
07:57
0203 Referencing Entire Rows/Columns
04:32
0204 Excel - Function Processing Order
07:48
0205 Convert Formulas To Values In A Split Second
04:22
Section 3: Extend Your Formula Usage
0301 Naming Cells To Improve Formula Appearance
06:48
0302 Excel - 3D Referencing
08:58
0303 Full Absolute Referencing
04:36
0304 Making Only Part Absolute Formula
06:23
Section 4: If And If Type Functions
0401 The If Logical Test
08:15
0402 Nested If Statements
03:56
0403 Using The And, Or, And Not Functions Within If
06:58
0404 CountIf, SumIf, And AverageIf
10:11
0405 Multiple Criteria With CountIfs, SumIfs, And AverageIfs
06:33
Section 5: Lookup And Reference Type Functions
0501 Looking Up Information With VLookup
09:10
0502 Excel - HLookup
04:11
0503 Nearest Match With VLookup
06:30
0504 Nested Lookup Functions
04:29
0505 Choose And Match Functions For Locating Data
05:10
0506 Index And Match Functions For Retrieving Data
08:38
Section 6: Mathematical Functions
0601 Varying Rounding Functions
07:39
0602 MRound, Ceiling, And Floor For Rounding Also
05:18
0603 Int And Mod For Integer And Remainder Values
04:20
0604 Generating Random Numbers And Values In Excel
05:14
0605 Password Generating Workbooks
06:02
0606 Display Different Number Types With Roman And Arabic
05:17
Section 7: Statistics
0701 The Middle Value With Median
05:07
0702 Ranking Data Without Sorting
04:57
0703 Large And Small For Retrieving Biggest And Smallest Values
04:39
0704 A Choice Of Count Functions
05:39
Section 8: Text Functions
0801 Extracting Data With Left, Right And Mid
05:45
0802 Locating Data With Find, Search, Exact
07:18
0803 Use Trim And Clean To Remove Unwanted Gaps
05:49
0804 Combine Data From Different Cells
06:18
0805 Changing The Case Of Text Using Proper, Upper, And Lower
03:17
0806 Replace And Substitute In Action
04:54
0807 Format Number Content Within Strings With Text
05:52
Section 9: Date And Time Functions
0901 Using Today And Now Functions
03:34
0902 How Does Excel Deal With Dates And Time
05:52
0903 What Day Of The Week Is It?
04:14
0904 Difference Between Network Days And Work Day
06:58
0905 DatedIf For Time Differences
07:12
0906 EDate And EOMonth
04:57
0907 DateValue And TimeValue Functions
07:43
Section 10: Information And Referencing Functions
1001 Extracting Information With Cell And Info Functions
08:12
1002 Using IsBlank, IsOdd, IsEven, IsText, And IsNumber
04:37
1003 IsErr, IsError, IfError, IsNA, And IfNA For Error Checking
08:25
1004 The New IsFormula Function And FormulaText
03:41
1005 Use Offset To Obtain Data From Related Cells
08:42
1006 InDirect And Its Uses
07:12
Section 11: Array Formulas And Functions
1101 What Is An Array Formula?
08:26
1102 Use An Array Formula To Count Unique Entries
05:18
1103 Flipping Rows Or Columns With Transpose
03:56
Section 12: Conclusion
1201 Excel - Advanced Formula Summary
02:45

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course