Tutembe

ADJUSTING COLUMNS #excel #exceltips #tutembe #appexcelanalytics #upscaleyourskills

Text to column Command

Using the MATCH function to find the RELATIVE POSITION of an item in a list.

Using "Conditional Formatting" to Visualize performance using "Data Bars".

Use the XLOOKUP function to merge two lists based on an Identifier.

Excel Magic: Making Random Letters Easy with CHAR Function

AI Data Analysis

TRANSFORM DATA FOR EASY ANALYSIS Unpivot & Convert Wide to Long Format

Quick Pivot Table Tricks for 360-degree analysis of data.

Goal Seek Reel

Using Conditional formatting to paint a BMI chart

What-if-analysis for business decisions and Insights: Goal seek and Excel Data Table

Create a closet in excel using the power of the group command

Using the Datedif function to compute the difference Between two dates.

Identifying Unique/Duplicate items in a List in Excel made easy with Conditional Formatting.

Fill Series

Hyperlink your data in excel

Lookup series: Using the INDEX MATCH function combination to merge two Lists

Use VLOOKUP to grade student scores and also match student table to age table

Ever used the Nfunction in Ms. Excel? Combine it with the COUNTIFS to identify and remove duplicates

Copy and paste formats in excel using the Format Painter Command

Explore the offset function to lookup a cell or a range of cells dynamically.

ADJUSTING COLUMNS

Use Conditional formating formula to highlight a section data.

ROW, ROWS, COLUMN, COLUMNS, ROUNDDOWN and MOD functions and their application

Intro: Quickly generate random numbers in excel using the "Randbetween" function.

Apply VLOOKUP to grade marks of Students in excel

Center across selection command in excel

Explore the offset function to lookup a cell or a range of cells dynamically.