Quick Analysis tool allows you to quickly create graphs, sparklines, PivotTables, PivotCharts, and statistical functions by just clicking on a button. Conditional formatting allows you to apply a format to a cell or a range of cells based on certain criteria such as highlight duplicate records, highest values and lowest values. A Sparkline is a tiny chart in a worksheet cell that allows you to quickly visualize the overall trend of a set of values or to indicate maximum and minimum values.

• Use Quick Analysis tool to convert selected data range quickly into a chart or table.
• Use Data Bar to spot larger and smaller numbers quickly.
• Use Color scales to show data distribution and variation, such as investment returns overtime.
• Use icons to present data in three to five categories that are distinguished by a threshold value
• Use Sparklines to show the trend of data

Conditional logical functions allow you to sum, average and count cells that meet multiple criteria. Database functions work with an Excel database to sum, average and count based on a given set of conditions. VLOOKUP function lookup a value in a table by matching on the first column and retrieve the data (result values) in any column to the right. INDEX, MATCH and XLOOKUP functions lookup a value in a table by matching value in any column and retrieve the data from any column in the table.

• Insert automatic subtotals for related data
• Use Custom List in AutoFill
• Sort data by multiple levels
• Sort data based on custom list
• Use Search box criteria to filter data list
• Use Advanced Filter to filter data list
• Use Advanced Filter to copy records to another worksheet
• Use Advanced Filter to copy only selected columns to another worksheet
• Use absolute references and relative references
• Use defined names to create meaningful formulas
• Use Logical functions: IF, AND, OR and IFS
• Use Statistical functions: COUNTIFS, AVERAGEIFS, SUMIFS, MAXIFS and MINIFS
• Use Database functions: DSUM, DCOUNT, DCOUNTA, DMIN, DMAX and DAVERAGE
• Use Lookup functions: VLOOKUP, XLOOKUP, INDEX and MATCH

Flash Fill is a time-saving feature which fills in data automatically when a pattern is provided. You can use it to extract data, insert data, format text and concatenate text. Power Query is a user-friendly business intelligence tool that that simplifies the process of importing data from different source files and sorting them into an Excel sheet in the most convenient and usable format.

• Use Flash Fill to split text, change text cases, combine text, format numbers and dates
• Use TEXT, LEFT, RIGHT, MID, LEN, FIND function to format and split data
• Use Text To Columns Wizard to split text string and format dates
• Use CONCAT, TEXTJOIN function to combine data
• Load Table Data into Power Query Editor
• Use Power Query Editor to Change Data Types
• Combine Multiple Files from a Folder using Power Query
• Use Power Query Editor to merge and split columns