Sum of Sales by Time & Weekdays in Excel 2010 functions | ExcelGuru
Learn how to calculate the sum of sales for specific times and weekdays using Power Query in Excel 2010.
In this step-by-step tutorial, you’ll see how to transform your data, filter by time, select weekdays, and quickly get your total sales.
Perfect for data analysts, Excel learners, and anyone who works with sales reports.
What you’ll learn:
Load data into Power Query in Excel 2010
Filter by particular time (e.g., after 12 PM)
Select specific weekdays (e.g., Tuesday & Thursday)
Group and sum sales efficiently
Export the result back to Excel
📌 No complex formulas – only Power Query!
#Excel2010 #PowerQuery #ExcelTips #ExcelTutorial #SalesAnalysis #DataAnalysis #ExcelTraining #PowerQueryTips #ExcelShorts #ExcelFormulaFree
Excel 2010, Power Query, Excel Power Query, sum sales in Excel, sales analysis Excel, Excel filter by time, Excel weekdays sum, group by in Power Query, Excel beginner tutorial, Excel data analysis, Excel tips and tricks, Excel tutorial 2010, Excel report automation, Power Query Excel 2010
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from ExcelGuru · ExcelGuru · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Total Sumproduct Session By Excel Expert Mr.Sanjeev kaushik
ExcelGuru
Uses and Technics of Transpose in 3 Methods
ExcelGuru
Query Solved ExcelExpert
ExcelGuru
counting numbers and text with creteria lenngth
ExcelGuru
For Reverse Looking Fing age By Using Database Function
ExcelGuru
MIS INTERVIEW QUESTION EXTRACTING FIRST AND LAST NAME WHICH IS NOT HAVING DELIMETER
ExcelGuru
finding Unique count of sales between Dates
ExcelGuru
counting 2 lookup values as per dupicates
ExcelGuru
Reverse Vlookup to get DOB
ExcelGuru
17-04-2022 Sridevi Marriage Celebrations
ExcelGuru
INTERVIEW QUERIES WITH ANOTHER QUERY
ExcelGuru
finding maximum sales of product when duplicate products
ExcelGuru
QUERY ASKED IN GROUP
ExcelGuru
MIS TEST WITH AMAZING SOLUTION BY JR.BILLGATES(ANAND)
ExcelGuru
query to count not saled products after saled products
ExcelGuru
Explanation about birla mandir at Hyderabad
ExcelGuru
counting specific weekday in between dates
ExcelGuru
Extract Data As per Creteria with power Query
ExcelGuru
Extracting data as per creteria in different sheets
ExcelGuru
SOLUTION FOR INPHOSYS MIS-1(1-4)
ExcelGuru
solution for inphosis mis 2(12-13)
ExcelGuru
INPHOSIS MIS SOLUTION-3(5-10)
ExcelGuru
LOGICAL MIS INPHOSIS-4(17-18)
ExcelGuru
MIS INTERVIEW QUESTION
ExcelGuru
MIS INPHOSIS -5(19-21)
ExcelGuru
MIS INPHOSIS - 6(23-25)
ExcelGuru
extracting pin codes or number from text string
ExcelGuru
finding maximum sales in one value
ExcelGuru
finding how many months are there between months
ExcelGuru
Quarter sales by month
ExcelGuru
Finding rate with 2 conditions by using vlookup
ExcelGuru
how to find max length word from text string
ExcelGuru
Group query To find sales and Quantity With 2 conditions by using VLOOKUP
ExcelGuru
my angels birthday celebrations
ExcelGuru
Group Query Adding total sales when it is having random delimiter like inches,kgs,Ton
ExcelGuru
Seperating first and last Name by space using function
ExcelGuru
Finding Total Goals from different tables Team members
ExcelGuru
Group Query To Extract Team members Names
ExcelGuru
Extracting data in a single column
ExcelGuru
converting one column data into table interview question
ExcelGuru
MIS INTERVIEW QUESTION-100
ExcelGuru
MIS INTERVIEW QUESTION -101 FINDING VALUE AS PER CHARACTERS LENGTH BY VLOOKUP
ExcelGuru
chi.shreyansh
ExcelGuru
MIS INTERVIEW QUESTION-102(SORT BY LENGTH)
ExcelGuru
query to extract last words from sentence
ExcelGuru
MIS INTERVIEW -103(EXTRACT MAXIMUM CHARACTERS WORD IN A CELL)
ExcelGuru
group query
ExcelGuru
without len function count of characters
ExcelGuru
MIS QUERY
ExcelGuru
mis interview questions part -1
ExcelGuru
Real MIS Query-1
ExcelGuru
real mis interview questions-1
ExcelGuru
finding the value as per length of characters
ExcelGuru
real mis -2
ExcelGuru
real MIS -3
ExcelGuru
REAL MIS -4(PART A)
ExcelGuru
group query
ExcelGuru
tech mahindra mis
ExcelGuru
courier company MIS
ExcelGuru
tech Mahindra (UPDATED)
ExcelGuru
More on: Data Literacy
View skill →
🎓
Tutor Explanation
DeepCamp AI