Excel 3 Simple Ways to Count and Calculate Sum of Values per Month

preview_player
Показать описание
* 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
Рекомендации по теме
Комментарии
Автор

Ito ang kailangan ko sa mga Sales Reports ko para hindi na ko mahirapan.

giahairstyles
Автор

Salamat sa TIPS sir. Jan ako nahihirapan sa pag formulate .

kapitanisbo
Автор

now i know kanino lalapit sa excel problems haha. thanks for this! :)

dianefigueroa
Автор

Thank You for sharing, gamit na gamit ko to, hehehe

cheftsano
Автор

Keep it up friend
And take care sub.like

hulikachannel