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
      • Important - Excel - Working Files - Download These First
      • 0101 How Advanced Is Advanced?
      • 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
    • Extend Your Formula Usage
      • 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
      • 0605 Password Generating Workbooks
      • 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

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top