Analitika Consulting Ltd

Analitika Consulting Ltd We help unlock the potential of finance teams so leaders can regain control of their business.

Our FREE Microsoft   Tips will help you dominate in   with superior skills!✅ MS Excel Tip ➡️ Automate Text to ColumnsTex...
29/07/2024

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 Micros...
26/07/2024

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...
24/07/2024

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 n...
22/07/2024

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...
19/07/2024

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 ...
17/07/2024

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 Man...
15/07/2024

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...
12/07/2024

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 ne...
10/07/2024

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...
08/07/2024

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 Manip...
05/07/2024

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...
04/07/2024

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.

Address

71-75 Shelton Street, Covent Garden
London
WC2H9JQ

Opening Hours

Monday 9am - 5pm
Tuesday 9am - 5pm
Wednesday 9am - 5pm
Thursday 9am - 5pm
Friday 9am - 5pm

Telephone

+447305111454

Alerts

Be the first to know and let us send you an email when Analitika Consulting Ltd posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Analitika Consulting Ltd:

Share