MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Microsoft Excel - Advanced Formulas And Functions

### Course Summary

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

• +

### Course Syllabus

• Welcome
• 0102 Using The Excel Working Files
• 0103 When Is A Formula A Function?
• Getting The Basics Right
• 0201 Excel - Sum And Count Syntax
• 0202 Accessing Unknown Function Syntax Within Excel
• 0203 Referencing Entire Rows/Columns
• 0204 Excel - Function Processing Order
• 0205 Convert Formulas To Values In A Split Second
• 0301 Naming Cells To Improve Formula Appearance
• 0302 Excel - 3D Referencing
• 0303 Full Absolute Referencing
• 0304 Making Only Part Absolute Formula
• If And If Type Functions
• 0401 The If Logical Test
• 0402 Nested If Statements
• 0403 Using The And, Or, And Not Functions Within If
• 0404 CountIf, SumIf, And AverageIf
• 0405 Multiple Criteria With CountIfs, SumIfs, And AverageIfs
• Lookup And Reference Type Functions
• 0501 Looking Up Information With VLookup
• 0502 Excel - HLookup
• 0503 Nearest Match With VLookup
• 0504 Nested Lookup Functions
• 0505 Choose And Match Functions For Locating Data
• 0506 Index And Match Functions For Retrieving Data
• Mathematical Functions
• 0601 Varying Rounding Functions
• 0602 MRound, Ceiling, And Floor For Rounding Also
• 0603 Int And Mod For Integer And Remainder Values
• 0604 Generating Random Numbers And Values In Excel
• 0606 Display Different Number Types With Roman And Arabic
• Statistics
• 0701 The Middle Value With Median
• 0702 Ranking Data Without Sorting
• 0703 Large And Small For Retrieving Biggest And Smallest Values
• 0704 A Choice Of Count Functions
• Text Functions
• 0801 Extracting Data With Left, Right And Mid
• 0802 Locating Data With Find, Search, Exact
• 0803 Use Trim And Clean To Remove Unwanted Gaps
• 0804 Combine Data From Different Cells
• 0805 Changing The Case Of Text Using Proper, Upper, And Lower
• 0806 Replace And Substitute In Action
• 0807 Format Number Content Within Strings With Text
• Date And Time Functions
• 0901 Using Today And Now Functions
• 0902 How Does Excel Deal With Dates And Time
• 0903 What Day Of The Week Is It?
• 0904 Difference Between Network Days And Work Day
• 0905 DatedIf For Time Differences
• 0906 EDate And EOMonth
• 0907 DateValue And TimeValue Functions
• Information And Referencing Functions
• 1001 Extracting Information With Cell And Info Functions
• 1002 Using IsBlank, IsOdd, IsEven, IsText, And IsNumber
• 1003 IsErr, IsError, IfError, IsNA, And IfNA For Error Checking
• 1004 The New IsFormula Function And FormulaText
• 1005 Use Offset To Obtain Data From Related Cells
• 1006 InDirect And Its Uses
• Array Formulas And Functions
• 1101 What Is An Array Formula?
• 1102 Use An Array Formula To Count Unique Entries
• 1103 Flipping Rows Or Columns With Transpose
• Conclusion
• 1201 Excel - Advanced Formula Summary

Course Fee:
USD 24

Self-Study

### Course Status:

Active

1 - 4 hours / week

Related Posts: