Analitika Consulting Ltd

Our FREE Microsoft Tips will help you dominate in with superior skills!

✅ MS Excel Tip ➡️ Automate Text to Columns

Text to Columns is a great excel function, however it doesn't automatically refresh when you add new data.

✨ Try this instead! ✨

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will elevate your skills and get you noticed!

✅ MS Excel Tip: Text Manipulations ➡️ Lock Microsoft Excel cells you don't want people to accidentally change!

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will help you create opportunity in your career!

Start your MS Excel mastery right now! Excel Tip ➡️ Text Manipulations: LEN will elevate your skills and get you noticed!

fx = LEN ( text)

▪️ Counts the numbers of characters in the text of a selected cell.

▪️ Very versatile when combined with other text manipulation formulas.

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will help you become indispensable in your career!

✅ Our MS Excel tips are exactly what you need ➡️ Data Validation

▪️ If other people will be adding data to the file, use data validation to make sure that information is added appropriately.

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will keep your skills from plateauing so you can elevate your career!

✅ Our detailed MS Excel Index Match X2 Excel Cheat Sheet is exactly what you need!

➡️ INDEX is an Excel function that retrieves the value found at the intersection of a specific row and column.

▪️ Index 2 Criteria

➡️ fx = INDEX (array, MATCH ( lookup_value, lookup_array,[match_
type]), MATCH ( lookup_value, lookup_array, [match_type])

▪️ Index Multiple Criteria

➡️ fx = INDEX (array, MATCH ( 1, (criteria = criteria range) * (criteria = criteria range),0), MATCH ( lookup_value, lookup_array, [match_type])

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will help you dominate in with superior skills!

✅ This detailed MS Excel Tip is exactly what you need ➡️ Summarise tabs with the same format!

⬇️ Who knew that the Sum formula could be so powerful?

▪️ Create 2 blank sheets called Start and End
▪️ Add all the tabs with identical structure in between the Start and End tab
▪️ Create a Total tab and use the formula structure SUM(Start:End!B2)

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will help you dominate in with superior skills!

This detailed MS Excel Tip ➡️ Date & Text Manipulations Cheat Sheet is exactly what you need!

Check it out!

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will help you create opportunity in your career!

MS Excel Tip ➡️ Text Manipulations: TRIM

fx = TRIM ( text )

▪️ Eliminates spaces at the beginning and ending of the text.

▪️ Also removes extra spaces in between words.

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will help you become indispensable in you career!

✅ Our MS Excel tips are exactly what you need ➡️ Alt Enter

Break Down Long Formulas In Multiple Rows

▪️ Click Alt + Enter to go one row below

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will elevate your skills and get you noticed!

MS Excel Tip: Text Manipulations ➡️ MID

▪️ Extract a given number of characters from the right hand side of the cell

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will keep your skills from plateauing so you can elevate your career!

Excel Tip ➡️ Text Manipulations: MID & FIND

fx = MID (text, start no, no of characters)

➡️ Extract a given number of characters from the right hand side of the cell.

fx = FIND (find_text, within_text, start number)

➡️ Find a given character and return it’s position within the text in a cell. You can choose the starting character number.

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.

Our FREE Microsoft Tips will help you become indispensable in you career!

✅ Our Microsoft Excel tips are exactly what you need ➡️ Never hardcode numbers!

▪️ Use ctr + ¬ to quickly search for hardcoded numbers in one tab. Press it again to turn the functionality off

➡️ Become Unfireable: future-proof your finance career!
➡️ Check out our website for current and future courses and daily inspiration:
www.analitika.co.uk
➡️ Use this link to sign up to my daily free Excel course:
https://members.analitika.co.uk/programs/7226/register/daily-excel
➡️ If this resonates with you, I would love it if you could share and follow for more.