Skip to Content
King Enterprise
  • Home
  • Course Library

    finance


    Microsoft Excel Indirect Tax (GST)

    aI FOR medical 


    AI for Medical Documentation & ReportingAI for Patient CommunicationAI in Presentation & Teaching for Doctors

    LEADERSHIP


    Contemporary Executive Leadership Program

    aI tools


    Canva AI
  • Privilege Shop
  • 0
  • Sign in
  • Contact Us
King Enterprise
  • 0
    • Home
    • Course Library
    • Privilege Shop
  • Sign in
  • Contact Us
  1. Courses
  2. Microsoft Excel: Advanced Excel and Formulas
  3. Introduction Excel Formulas 101
Nav
Home └Microsoft Excel: Advanced Excel and Formulas └Introduction Excel Formulas 101

Microsoft Excel: Advanced Excel and Formulas

0 %

Completed

Course content
  • Excel Formulas 101
    • Introduction Excel Formulas 101
    • Excel Formula Syntax
    • Writing Efficient Formulas with Fixed & Relative References
    • Common Excel Error Types
    • Formula Auditing Trace Precedents & Dependents
    • Formula Auditing Evaluate Formula & Error Checking PC Only
    • Navigating Excel Worksheets with Ctrl Shortcuts
    • Saving Time with Function Shortcuts
    • Accessing Tools with Alt Key Tips
    • PRO TIP Creating Drop Down Menus with Data Validation
    • Congrats, You're a Developer!
  • Conditional Statements & Logical Operators
    • Conditional Statements & Logical Operators Introduction
    • Anatomy of the IF Statement
    • Nesting Multiple IF Statements
    • Adding Conditional ANDOR Operators
    • Using NOT & Conditionals
    • Fixing Errors with IFERROR
    • Common IS Statements
  • Common Excel Statistical Functions
    • Common Excel Statistical Functions Introduction
    • Basic Excel Statistical Functions
    • Extracting Values with SMALLLARGE & RANKPERCENTRANK
    • Randomization with RAND & RANDBETWEEN
    • Row Level Calculation with SUMPRODUCT
    • DEMO Calculating Shipping Costs with SUMPRODUCT
    • Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
    • Building a Basic Dashboard with COUNTIFS & SUMIFS
    • DEMO Counting Duplicates with COUNTIF & SUMPRODUCT
    • PRO TIP Data Profiling with COUNT & SUMPRODUCT
  • Lookup & Reference Functions
    • Lookup & Reference Functions Introduction
    • Working with Named Ranges
    • Counting Rows & Columns with ROWROWS & COLUMNCOLUMNS
    • Introduction to VLOOKUPHLOOKUP
    • Joining Data with VLOOKUP
    • Fixing Errors with IFERROR & VLOOKUP
    • VLOOKUP Reference Array Options
    • Approximate Match Lookups
    • Navigating Cell Ranges with INDEX
    • Matching Text & Values with MATCH
    • Combining INDEX & MATCH to Dynamically Search Ranges
    • Combining MATCH & VLOOKUP for More Flexible Lookups
    • TROUBLESHOOTING VLOOKUP with Duplicate Keys

Introduction Excel Formulas 101

Prev Next
Fullscreen Share
  • About
  • Comments (0)
Rating
0 0

There are no comments for now.

Join this Course
to be the first to leave a comment.

Useful Links
  • Home​​
  • Policies
  • Contact us
About us

King Enterprise Privilege Platform is managed and operated by Nirmal Holdings Limited (GST:19AAACN9538P1ZM). It is a unique initiative that combines upskilling courses with a reward store to help our customers grow and enjoy exclusive benefits.  

Connect with us
  • Contact us
  • kingenterprise.shop@gmail.com
  • 9674728857
Follow us
Copyright © King Enterprise
Powered by Odoo - The #1 Open Source eCommerce