Top 25 Excel Formulas

0
Certificate

Paid

Language

Level

Advanced

Access

Free

Last updated on March 20, 2025 5:49 pm

Master the advanced logical, functional, text, lookup and reference functions, formulas and applications of MS Excel with this free online Excel course.

Add your review

Improve your ability to analyze numerical data with this free online Excel course that teaches you how to use this Windows, Android, MacOS and iOS spreadsheet program. This Excel tutorial will teach you how to use the logical, financial, text, lookup and reference functions along with how to track changes, modify templates, macros and external data sources. This course allows you to get the most out of this powerful program in a practical way.

What You Will Learn In This Free Course

  • Identify the main logical and financ…
  • Compute values using the ?if? functi…
  • Indicate arguments as true or false …
  • Compare the uses of logical function…
  • Identify the main logical and financial functions in a spreadsheet
  • Compute values using the ?if? function
  • Indicate arguments as true or false using the ?and? function
  • Compare the uses of logical functions ?and/if?, ?iferror? and ?xor?
  • List the uses of financial functions: present Value, future value, payment, price and yield
  • Analyze data and information with the use of financial functions
  • Identify and use the financial functions applicable in accounting
  • Identify the applications of ?text?, ?lookups? and ?reference? functions in Excel
  • Arrange data in a user-friendly format
  • Classify data according to specified categories or values
  • Summarize findings for meaningful reporting
  • Compare the features of ?lookup? functions
  • Select the right tabs and perform different tasks in Excel
  • Logical and Financial Functions

    Microsoft Excel is used by many people around the globe. It has many features and functions that enable quick analytics for business and research. In this module, you will be introduced to some of the key logical and financial functions. You will learn how to display text in these functions and how to use these functions to calculate values on spreadsheets. You will also understand the meaning of arguments for a function.

    Text, Lookup and Reference Functions, Bonus Selection

    Excel has several powerful functions that enable efficient and user friendly management and presentation of a large range of data. In this module you will be introduced to the basic functions in text and lookups. These functions are useful for analysts, report making, data verification, auditing and in many other fields. This nodule also offers a bonus selection of some useful functions of Excel such as creating and modifying templates, working with different workbooks and external data sources.

    Course assessment

    User Reviews

    0.0 out of 5
    0
    0
    0
    0
    0
    Write a review

    There are no reviews yet.

    Be the first to review “Top 25 Excel Formulas”

    ×

      Your Email (required)

      Report this page
      Top 25 Excel Formulas
      Top 25 Excel Formulas
      LiveTalent.org
      Logo