Microsoft Excel Advanced Formulas And Functions

  1. Home
  2. Excel-formulas-and-functions
  3. Microsoft Excel Advanced Formulas And Functions

Tags: Excel Formulas and Functions

Advanced Microsoft Excel Formulas And Functions - Take Your Excel Skills To The Next Level

Last updated 2022-01-10 | 4.5

- Take Your Excel Skills To The Next Level

What you'll learn

Take Your Excel Skills To The Next Level

* Requirements

* Microsoft Excel 2010 or Excel 2013
* Windows

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.

Who this course is for:

  • Intermediate To Advanced Users

Course content

12 sections • 58 lectures

Welcome 4 lectures

Important - Excel - Working Files - Download These First Preview 00:01

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

Getting The Basics Right 5 lectures

0201 Excel - Sum And Count Syntax Preview 06:18

0202 Accessing Unknown Function Syntax Within Excel Preview 07:57

0203 Referencing Entire Rows/Columns Preview 04:32

0204 Excel - Function Processing Order Preview 07:48

0205 Convert Formulas To Values In A Split Second Preview 04:22

Extend Your Formula Usage 4 lectures

0301 Naming Cells To Improve Formula Appearance Preview 06:48

0302 Excel - 3D Referencing Preview 08:58

0303 Full Absolute Referencing Preview 04:36

0304 Making Only Part Absolute Formula Preview 06:23

If And If Type Functions 5 lectures

0401 The If Logical Test Preview 08:15

0402 Nested If Statements Preview 03:56

0403 Using The And, Or, And Not Functions Within If Preview 06:58

0404 CountIf, SumIf, And AverageIf Preview 10:11

0405 Multiple Criteria With CountIfs, SumIfs, And AverageIfs Preview 06:33

Lookup And Reference Type Functions 6 lectures

0501 Looking Up Information With VLookup Preview 09:10

0502 Excel - HLookup Preview 04:11

0503 Nearest Match With VLookup Preview 06:30

0504 Nested Lookup Functions Preview 04:29

0505 Choose And Match Functions For Locating Data Preview 05:10

0506 Index And Match Functions For Retrieving Data Preview 08:38

Mathematical Functions 6 lectures

0601 Varying Rounding Functions Preview 07:39

0602 MRound, Ceiling, And Floor For Rounding Also Preview 05:18

0603 Int And Mod For Integer And Remainder Values Preview 04:20

0604 Generating Random Numbers And Values In Excel Preview 05:14

0605 Password Generating Workbooks Preview 06:02

0606 Display Different Number Types With Roman And Arabic Preview 05:17

Statistics 4 lectures

0701 The Middle Value With Median Preview 05:07

0702 Ranking Data Without Sorting Preview 04:57

0703 Large And Small For Retrieving Biggest And Smallest Values Preview 04:39

0704 A Choice Of Count Functions Preview 05:39

Text Functions 7 lectures

0801 Extracting Data With Left, Right And Mid Preview 05:45

0802 Locating Data With Find, Search, Exact Preview 07:18

0803 Use Trim And Clean To Remove Unwanted Gaps Preview 05:49

0804 Combine Data From Different Cells Preview 06:18

0805 Changing The Case Of Text Using Proper, Upper, And Lower Preview 03:17

0806 Replace And Substitute In Action Preview 04:54

0807 Format Number Content Within Strings With Text Preview 05:52

Date And Time Functions 7 lectures

0901 Using Today And Now Functions Preview 03:34

0902 How Does Excel Deal With Dates And Time Preview 05:52

0903 What Day Of The Week Is It? Preview 04:14

0904 Difference Between Network Days And Work Day Preview 06:58

0905 DatedIf For Time Differences Preview 07:12

0906 EDate And EOMonth Preview 04:57

0907 DateValue And TimeValue Functions Preview 07:43

Information And Referencing Functions 6 lectures

1001 Extracting Information With Cell And Info Functions Preview 08:12

1002 Using IsBlank, IsOdd, IsEven, IsText, And IsNumber Preview 04:37

1003 IsErr, IsError, IfError, IsNA, And IfNA For Error Checking Preview 08:25

1004 The New IsFormula Function And FormulaText Preview 03:41

1005 Use Offset To Obtain Data From Related Cells Preview 08:42

1006 InDirect And Its Uses Preview 07:12

Array Formulas And Functions 3 lectures

1101 What Is An Array Formula? Preview 08:26

1102 Use An Array Formula To Count Unique Entries Preview 05:18

1103 Flipping Rows Or Columns With Transpose Preview 03:56

Conclusion 1 lectures

1201 Excel - Advanced Formula Summary Preview 02:45