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/
CP007: aweSUM() – Overview of SUM functions in Excel
In the 7th session of Chandoo.org podcast, lets make you aweSUM().
Before we proceed in to the session, let me remind you:
Subscribe to Chandoo.org PodcastDo you know that you can subscribe and receive latest episodes of our podcast right to your ears? Use one of the below links to get started.
- For iPhone or iPod or iPad: Click here to subscribe.
- Andriod Phones & Tabs: Click here to subscribe on Stitcher. (You can download Stitcher free app from that link)
- Windows Phone: For Windows phone, search your podcasts app for our show.
- Or… As always, you can get latest episodes, show notes & resources from our Podcast page.
Imagine for a second that Excel cannot add up numbers. And no it cant subtract them either. What would that look like?
A glorified Notepad. That’s right. Excel’s ability to add up numbers, along with features like formulas, charts, pivot tables & BHATTEXT() are what make it such a lovely software. May be not the BHATTEXT(), but we all agree that Excel is so versatile and useful because it can add up numbers (and perform other calculations) with ease.
But how well do you know the SUM formulas of Excel?
In this podcast, you will learn,
- Special personal fruit announcement
- + operator
- Status bar & total rows in tables
- Auto Sum feature
- SUM() function
- SUMIFS function
- When to use it
- Examples
- Special cases of SUMIFS function
- Sum of all positive numbers
- Sum of all numbers for March 2014
- Sum of all customers with name = taco bell
- SUBTOTAL & AGGREGATE functions
- Other summing functions
- SUMIF
- SUMPRODUCT
- DSUM
- Conclusions
Go ahead and listen to the show Links & Resources mentioned in this session: Resources to learn SUM functions
- Functions
- SUMIFS()
- SUMIF
- SUMPRODUCT
- SUBTOTAL
- SUM
- Top 10 formulas for Analysts
- Excel Tables
- Introduction to Tables
- Structural References & Tables
- Using Tables – Video 1, Video 2
- Examples
- SUMIF with multiple conditions
- SUMIF & 2D data
- Sum of values between 2 dates
- Exclude hidden rows in Conditional SUM
Download this podcast transcript [PDF]
How awesome are your SUM skills?SUM formulas are corner stone of any dashboard or report or meaningful model. So it no surprise that I use them often. My favorite sum formula is SUMIFS(). It is versatile and powerful. I am learning to love DSUM() too. I will share details about it in an upcoming article.
Meanwhile, tell me what is your favorite SUM formula? What are the tricks and techniques you use when writing SUM formulas? Please share your thoughts using comments.
The post CP007: aweSUM() – Overview of SUM functions in Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.