#MsExcel
In this tutorial we are using a complex case in Excel that had some challenges along the way:
The Excel version used was 2016
The data was extracted from an external source, but no matter what we tried the date could only be formatted as a text
We had five years of data but yet, we needed only one month and one year
The final report needed to be classified by date, age, registrations per age and total counts
We did multiple advanced conditional formatting and the best part was that we applied an Excel Pivot table to summarize evrything, fast.
❤️🔥You can enjoy the free Excel tutorials at
https://iknowledgeschool.com/
📚 We offer Live and remote Excel Training for Businesses and Organizations nationwide
Check our website for free tutorials and more tips https://www.iknowledgeschool.com
😎 Do you need to learn technology in a flash? ❤️🔥Our courses are on fire! and will help you achieve just that!
Related Excel Videos:
👀 Excel Pivot Table Tutorial: • #MsExcel How to Create a Pivot Table ...
💪 Excel Tips You Can’t Live Without: • #MsExcel #LearnExcel Top 7 Excel Tips...
🎉 Let's connect and get social:
📸 / iknowledgeschoo. .
🖼️ / iknowledgeschool
💼 / iknowledg. .
🧭 / learnwebdesign
🐥 / kisab
#excel flash fill #iknowledge school #microsoft excel
Watch video #MsExcel online without registration, duration hours minute second in high quality. This video was added by user iKnowledge School 11 May 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,039 once and liked it 107 people.