Analytics with Excel

Most people like to save money by spending time. But not all the time; I believe in saving time at any cost. This is because time is the only thing we can't renew. A minute lost is a minute gone. So let me share with you top time-saving tricks in Excel. Use them wisely.  1. If we need to do it every 'x' days, then automate; I'm not a fan of automating everything . But when I see a repeating task, I take time to automate it. So here we disclose & spot you a piece of work that needs doing every week; just automate it. Here are my favorite tools for automation in 2026. POWER QUERY   That's it. This is the only thing we need to get started. Use it to collect, clean up, and maintain data automatically. If you don't know what Power Query is, then you must check out this blog .  Analysts used some hidden advanced Excel features . 2. Tables and pivots for most work While I enjoy writing formulas as much as the Incredible Hulk likes to smash things, I take a much mor...

Here we disclose some tips for quickly creating the awesome pivot charts in Excel in a while. In the module, we will learn that without extra effort in some cases when we have to create the chart or make the report for the stakeholders, we can use some tips for making the charts. So we are discussing the top 10 tips.   Tip #1: Press ALT+F1 to quickly make a chart (1) Click anywhere inside the data below, from cell B12 to B16. (2) Press ALT+F1 (make sure your F-lock is on). If you're using the laptop, try ALT+FN+F1. (3) Excel creates a simple chart for you. (4) Now change it to another type of chart on the design tab, click "Change Chart Type," and pick another chart that interests you. Tip #2: Select specific columns before creating a chart. (1) Click and drag to select cells B12 to B16 (from salesperson down to Sally). (2) Press and hold CTRL, and drag to select cells D12 to D16 (commission down to $10). Now let go of the CTRL key. (3) Press ALT+F1 (make sure your F-Lock...

What is a pivot table? Most of the analysts think that the pivot table takes row data and summarizes it. So you can make sense of it all without typing any formulas! Basically, we know how to use the pivot tables that we've already learned. A pivot table is a "bharmashtra" for analysts & learners of Excel. Pivot tables can summarize huge amounts of data.  How do you create a pivot table? The first step to creating a good pivot table is to make sure the data is in good shape. So, make sure you do the following before you create a pivot table. Lots of people use the word "column."  But in a pivot table, a column is a field. That first thing—try to remember this as you are creating the pivot table. After making a pivot table, the data needs to be dragged into fields (e.g., filters, columns, rows, and values). After the table is ready, we need to be ready for dashboard insight. For dashboard creation, we have to use pivot charts. Conclusion: In a simple way, for...

Demonstration of one of the most useful weapons in the tech industry. When we talk about lookup functions in Excel, then comes the most desirable VLOOKUP function. This is the core lookup function, used in every analytics task. So let's discuss this awesome function. And where we can use this function. If I would say... search/find the value on behalf of the name/value in large tables. So how would you search the right value on behalf of that value? In that case, we will use the VLOOKUP function. We listen to some of these things like that every day at our offices. But most of the professionals or learners are not aware of this function even now. VLOOKUP is the oldest function still in use now. The right syntax is below here with an explanation. =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) lookup value: what you want to search on behalf of that argument. table_array: - Select the range from the located lookup value to the endpoint. (e.g. A1:C10) col_index_num:...

What is the TRIM function in Excel? When we prepare the data, the first step is data cleaning. Data cleaning is the most important criterion for the analysis of any data. Here we will discuss the most hidden function called "TRIM."      The TRIM function does clean extra spaces from the selected cell. The specialty of this function is making cleaning of the data and ensuring that data is properly usable for analysis. This is the specialty to put the right spaces and remove some extra spaces. This is the core thing, to make this function standable in the data cleaning part.  The TRIM function syntax is here: =TRIM(text) text:- The text or cell, which you want to remove the extra spaces.

Data का विश्लेषण (analyse) प्रभावी निर्णय लेने के लिए किसी सूचना से उपयोगी जानकारी निकालनी की प्रकिया है। Spreadsheet एक अच्छा डेटा विश्लेषण सॉफ्टवेयर है। इसके अलावा Calc, Excel और Python भी अच्छा डेटा विश्लेषण सॉफ्टवेयर है जो pattern, trends और relationship की पहचान करने के लिए data को पुनः प्राप्त [retrieve] करने, correlate करने, search करने और कल्पना (visualise) करने के लिए उपयोग किए जाते है। Libre office calc में spreadsheet में data में हेरफेर करने के लिए उपयोग किए जाने वाले अनेक tool शामिल हैं। हम data का विश्लेषण कर सकते हैं और उनसे प्राप्त परिणामों की व्याख्या कर सकते हैं।  What if scenarios का Excel में क्या काम है? उदाहरण सहित आइए जानते हैं। What if scenarios, values का एक group है जो spreadsheet के अंदर Calculation में उपयोग किया जा सकता है। Scenarios को एक name दिया गया है और एक ही sheet पर कई scenarios बनाए जा सकते हैं। इसका उपयोग बदलती परिस्थितियों के आधार पर विभिन्न option का पता लगाने और तुलना करने के लिए किया जाता है। इसका उपयोग output के अनुकूलन (optimise) के लिए ...