top of page
This site was designed with the
.com
website builder. Create your website today.
Start Now
Excel Tips & Tricks
by Tik Tok Business Queen @reallaurindak
create drop-down list (ex: yes/no)
03/23/2021
Go
CONDITIONAL FORMATTING (ex: copy only red-filled data to new worksheet?)
03/02/2021
Go
WhatIf
Analysis - ex: what 4th grade do I need to achieve 70%?
02/23/2021
Go
count DUPLICATES combine dupicates (pivot table)
02/08/2021
Go
highlight & remove DUPLICATE data
02/06/2021
Go
make SUM the default, instead of COUNT (pivot table settings)
02/04/2021
Go
MERGE & CENTER data in cells
01/30/2021
Go
TRANSPOSE (ex: swap row headers with column headers)
01/27/2021
Go
protecting certain cells
01/24/2021
Go
YEARFRAC (ex: subtract 2 dates and get number of years difference)
01/20/2021
Go
TABLE (ex: turn OFF table formatting)
01/17/2021
Go
RIGHT (ex: grab last 4 numbers), LEFT (ex: grab first 3 numbers)
01/13/2021
Go
VLOOKUP (ex: vertical lookup Item # for corresponding Description values)
01/11/2021
Go
$ (dollar sign) - Use value of ONE cell for a formula, instead of entire column of values
01/09/2021
Go
remove DUPLICATES
01/07/2021
Go
increment values in a column (ex: sequence numbers 1, 2, 3, 4, 5, etc)
01/05/2021
Go
Excel basics: workbook/sheets, zoom, menu bar
01/05/2021
Go
pivot table (ex: amt $ per year)
03/23/2021
Go
see the actual FORMULAS in the cells, not the data generated by the fomulas
02/26/2021
Go
selecting data in Excel, without clicking & dropping (keyboard shortcuts)
02/17/2021
Go
splitting columns (ex: split FirstName LastName into 2 columns)
02/08/2021
Go
change negative numbers to positive numbers
02/05/2021
Go
PIVOT TABLES - use to filter large datasets
02/03/2021
Go
resize a bunch of columns at once
01/28/2021
Go
CONDITIONAL FORMATTING (ex: highlight duplicate values in multiple columns/rows)
01/26/2021
Go
INSERT 4 blank rows. TRANSPOSE data in columns/rows
01/22/2021
Go
CHARTS - insert a chart for selected data
01/17/2021
Go
TABLE (ex: turn ON table formatting) Can sort each column of a table
01/15/2021
Go
MACROS (ex: define Ctrl-S to execute a column sort)
01/12/2021
Go
basic FUNCTIONS: SUM, AVERAGE, PRINT formatting
01/11/2021
Go
SUMIF, COUNTIF (ex: how much sales under 18 and how much over 18 yrs old?) Part 1
01/08/2021
Go
CONCATENATE (ex: add "50" to the beginning of each value in a column)
01/07/2021
Go
highlight DULICATES in red
01/05/2021
Go
search for available types of formulas: Formulas / Insert Function
01/03/202
Go
add numbers together from several worksheets within one workbook
03/08/2021
Go
work-around for password-protected document
02/25/2021
Go
add & update VALIDATIONS
02/12/2021
Go
PIVOT TABLE w/ filter
02/07/2021
Go
formatting while PRINTING
02/04/2021
Go
change First Last to Last First in single column
01/31/2021
Go
CONDITIONAL FORMATTING (ex: show me which dates expire soon)
01/28/2021
Go
delete blank cells from selected data
01/25/2021
Go
highlight row & column for selected cell =OR(CELL(“col”)=COLUMN(),CELL(“row”)=ROW())
01/21/2021
Go
PROPER (ex: fix various upper/lower case letters in my dataset of names)
01/17/2021
Go
ADD-INs (ex: Insert / Get Add-Ins / Data Analytics / People Graphs - to show data as a graph)
01/13/2021
Go
FORMULA basics (ex: SUM values)
01/12/2021
Go
most in demand: vlookup, data filters and sorting, data validation, sumif(s), countif(s), cell formatting, shortcut keys (aka hotkeys), if, pivot tables, macros
01/10/2021
Go
SUMIF, COUNTIF (ex: how much sales under 18 and how much over 18 yrs old?) Part 2
01/08/2021
Go
drag same value down entire column vs draging incremented values
01/06/2021
Go
hotkeys (aka shortcut keys): Ctrl-C copy, Ctrl-V paste, Ctrl-X cut, Ctrl-B bold, Ctrl-H find/replace, alt underlined letter)
01/05/2021
Go
CONDITIONAL FORMATTING (ex: copy only red-filled data to new worksheet?)
01/03/2021
Go
bottom of page