5.00
(1 Rating)

Excel Formulas: Advanced Level II

About Course

Advanced Online Excel Course


Our Advanced Online Excel Course improves data skills. This online advanced excel course covers many useful functions for various tasks. These functions ensure data accuracy, handle dates, perform financial calculations, analyze frequency, alter data conditionally, add links, apply logic, search for specific information, perform mathematics, find extreme values, manage remainders, manipulate data, round numbers, work with rows, replace text, add numbers, compute sums, merge data, extract text segments, and handle time.


Learning these advanced Excel functions empowers you to set data rules, handle complex date calculations, explore financial trends, study event frequencies, customize data based on conditions, create hyperlinks, employ logic for decision-making, extract detailed information.


We will also show you how to perform diverse math operations, identify extremes, address remainders, manipulate data flexibly, round numbers, work with rows, replace text, compute sums, aggregate data, extract specific text segments, and handle time-related information.


Mastering these advanced Excel functions enables you to handle intricate data, perform thorough analyses, and create dynamic reports. It’s invaluable for data-intensive tasks.


Advanced Excel Course

Our advanced online Excel course enhances data skills for data analysis, offering numerous functions. These functions ensure data accuracy, deal with dates, perform financial calculations, analyze frequency, apply conditional formatting, add hyperlinks, implement logical formulas, search for specific data, and perform mathematical operations.


Additionally, they identify extreme values, manage remainders, manipulate data, round numbers, manipulate rows, replace text, calculate sums, combine information, extract text segments, and process time-related data.


Better Analysis

This course on advanced Excel techniques will help you become better at working with data and analyzing it. It covers a bunch of useful functions that can be used for different things. These functions can help you do things like making sure your data is correct, working with dates, doing financial calculations, looking at how often things happen, changing how data looks based on conditions.


Show More

What Will You Learn?

  • Data validation: Setting up rules for input data conditions.
  • Date functions: Calculating date differences, day of the week, etc.
  • Finance calculations: Calculating compound annual growth rates.
  • Frequency analysis: Counting unique values and categorizing data.
  • Conditional formatting: Highlighting cells based on criteria.
  • Hyperlink function: Creating dynamic hyperlinks in cells.
  • INDEX & MATCH: Advanced lookup and matching operations.
  • MATCH: Finding values and performing actions based on matches.
  • INDIRECT: Referencing cells indirectly.
  • LOOKUP: Retrieving data based on matching criteria.
  • Mathematical operations: Performing calculations on data.
  • MAX & MIN: Finding highest and lowest values in data.
  • MOD: Calculating remainders using modulo.
  • OFFSET: Dynamically referencing ranges.
  • ROUND: Rounding numbers to specified decimal places.
  • ROW: Manipulating data based on row numbers.
  • SUBSTITUTE: Replacing text within cells.
  • SUM & SUMIF: Performing summations and conditional summations.
  • SUMPRODUCT: Array calculations involving multiple ranges.
  • RIGHT & LEFT: Extracting text portions from cells.
  • TIME: Working with time-related calculations and conversions.

Course Content

HIGHLIGHT Function

  • 738-A Highlight all cells in D5:D13 that include any of the following “Words”
    04:31
  • Highlight all cells in D5:D13 that include any of the following “Words”
  • 757-A How to Find and Highlight Specific Data in Excel with Ease!
    10:06
  • How to Find and Highlight Specific Data

HYPERLINK Function

MOD Function

OFFSET Function

ROW-COLUMN Functions

SUBSTITUTE Function I

MMLT Function

SUMPRODUCT Function

WORKDAY Function

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
1 year ago
I can't believe how much more efficient I am with Excel now.