👇🏼 Get Miss Excel courses here!*
✨ Who is Miss Excel?
Kat Norton, the founder of Miss Excel shares helpful tips, and in-depth courses on how to use Microsoft Excel.
About Kat 👇
- Kat grew up in New York and studied business and Education at Binghamton University.
- She worked in a consulting firm for 4 years, creating Excel training programs.
- Kat has hosted workshops in the US and virtual training sessions using these programs.
- During the pandemic, Kat created Miss Excel to as an outlet to share her passion and help others.
⭐️ What does Miss Excel Do?
Miss Excel shares content and training courses online to help others boost their Microsoft Excel skills.
She believes in helping others progress in their current employment, land their dream job, get that raise and save time day to day!
Kat knows all the tips and tricks for optimising your excel spreadsheet, managing tasks quickly, an impressing your boss!
You can find her on TikTok sharing short easy-to-follow clips, Via LinkedIn to learn more about her business, and on Instagram to see fun educational posts and a little more about her life.
✅ 5 Super Useful Excel Tips
We have chosen some popular TikToks from Miss.Excel to kick start your Excel spreadsheet learning!
How to Quickly Format a Sheet ⬇️
Save hours by using this quick formula to format any sheet!
- Ctrl + A (Select All)
- ALT + HOI (Autofit Column)
- ALT + HOA (Autofit Row)
- DONE!
Quickly Sum Sheets! ⬇️
Quick maths with this tip to speed up the SUM process!
- Start with =SUM(
- Add name of first tab into the bracket.
- Add colon :
- Add last tab into the bracket.
- Add exclamation mark.
- Then cell reference.
Should end up with something like this: =SUM(first tab:last tab!CellRef)
How to Update Numbers Automatically ⬇️
Automate number lists to save time organising your spreadsheets!
- Select the cell where you want your numbered list to start.
- Add =SEQUENCE(COUNTA(
- Add the column your count is referencing.
- Choose the formula.
- DONE!
Excel Mobile Hack! ⬇️
Don’t worry about typing up data, use the mobile app to take a photo and create a sheet for you!
- Open mobile app.
- Click home, the insert.
- Choose Data from picture.
- Data is automatically extracted!
- DONE!
Quickly Make Barcodes ⬇️
A quick way to turn numbers into barcodes!
- Type into cell =”*”&CELLREF&”*”
- Change font to Libre Barcode 39.
- Copy down.
- DONE!
📲 How To Find Miss Excel
You can find Miss Excel on social media, and through her website! 💻
On the Web 👇
TikTok 👇
Via LinkedIn 👇
Or on Instagram! 👇