filmov
tv
Excel 3 Simple Ways to Count and Calculate Sum of Values per Month
Показать описание
* EXERCISE 60: 3 Simple Ways to Count and Calculate Sum of Values per Month
Learn how to calculate the total count and sum of values per month in 3 different ways. You may choose among the 3 which you are comfortable with to use.
1. Pivot
2. Formula
3. Power Query
Pivot is probably the easiest way to achieve this, however, using formula has some greater flexibility esp if you need to consider several conditions/criteria to meet. For advanced users, consider using Power Query. Not only it will help you to get familiar with this advanced feature, but also this is the latest trends in data analytics.
"You can have data without information, but you cannot have information without data."
— Daniel Keys Moran
*************************************************
Want to learn more about Excel?
SUBSCRIBE NOW:
YouTube Playlist:
See you there!
Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert
"To EXCEL in the workplace, one must know how to use excel!"
- Romeo
Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial
#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy
Learn how to calculate the total count and sum of values per month in 3 different ways. You may choose among the 3 which you are comfortable with to use.
1. Pivot
2. Formula
3. Power Query
Pivot is probably the easiest way to achieve this, however, using formula has some greater flexibility esp if you need to consider several conditions/criteria to meet. For advanced users, consider using Power Query. Not only it will help you to get familiar with this advanced feature, but also this is the latest trends in data analytics.
"You can have data without information, but you cannot have information without data."
— Daniel Keys Moran
*************************************************
Want to learn more about Excel?
SUBSCRIBE NOW:
YouTube Playlist:
See you there!
Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert
"To EXCEL in the workplace, one must know how to use excel!"
- Romeo
Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial
#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy
Комментарии