Chandoo.org Podcast - Become Awesome in Data Analytics

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/

subscribe
share






CP047: Best Excel tools for Entrepreneurs


In the 47th session of Chandoo.org podcast, let’s see how Excel can make you an awesome entrepreneur.

What is in this session?

In this podcast,

  • Why Excel for entrepreneurs
  • Key areas of a business owner’s work
    • Projects & to dos
    • Finances
    • Customers & marketing
    • Planning & strategy
    • Processes & workflows
  • 5 features of Excel that help
    • Tables
    • Financial formulas
    • Pivot tables
    • Forecasting techniques
    • VBA & formula driven workbooks
  • Conclusions
Listen to this session

Click here to download the MP3 file.

Excel resources for entrepreneurs

If you are an entrepreneur or small business owner, check out these links and become awesome at your work.

On projects & to dos:

  • Introduction to Excel tables
  • Introduction to structured references and awesome ways to use tables
  • Project management using Excel – 6 part tutorial

On finances:

  • Basic financial formulas and analysis concepts in Excel – podcast
  • Case study: Cost vs benefit analysis using Excel
  • Financial modeling using Excel – 6 part tutorial

On Marketing & customer data analysis:

  • Introduction to pivot tables
  • Don’t be a pivot table virgin – podcast
  • More on Excel pivot tables

On forecasting & planning:

  • Introduction to trend analysis and forecasting using Excel – 3 part tutorial
  • Trend analysis using Excel – podcast

On processes and workflows:

  • Top 10 formulas for analysts & managers (entrepreneurs can use them too!)
  • Introduction to Excel VBA – podcast

Scott Adam’s book – How to fail at almost everything and still win big

 

Transcript of this session:

Download this podcast transcript [PDF]

Are you an entrepreneur? Tell me how you use Excel…

Now it’s your turn. If you are an entrepreneur or small business owner, please tell me how you use Excel. Share your story in the comments section.

Subscribe to our podcast and get latest episodes automatically

Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.

Other options to subscribe

The post CP047: Best Excel tools for Entrepreneurs appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


fyyd: Podcast Search Engine
share








 October 22, 2015  34m