Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.
https://chandoo.org/wp/category/podcast/
CP056: So which formulas you should care to learn?
In the 56th episode of Chandoo.org podcast, let me answer the chicken and egg question of Excel users. How many formulas should you care to learn?
What is in this session?In this podcast,
- Two personal updates
- 3 legs of formula writing
- Function knowledge
- Operators
- Referencing
- 6 categories of must-know functions
- Basic math
- Conditions
- Lookups
- Text
- Date & time
- Work specific
- Closing remarks & resources for you
Click here to download the MP3 file.
Resources for learning FormulasPodcast episodes on formulas
- All about Excel $@#%%#^^
- Mastering aweSUM() formulas of Excel
- Writing business logic in Excel formulas
- VTALKUP – learn all about VLOOKUP function
- VLOOKUP FAQs
Articles to learn important formulas
- Top 10 formulas for aspiring analysts
- Beyond IF & SUM, 15 formulas for everyone
I am happy to announce that I have a Patreon page now. If you love my podcast, head to my Patreon page to pledge a little to Chandoo.org. Thanks for your generosity and love.
The post CP056: So which formulas you should care to learn? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.