Excel formulas are like bread and butter for anyone being in PMO. Summarising the important formulas one should be aware of, along with examples. It was a good recap for me. The below is the list of functions we are going learn together. AND(), OR(), NOT() IF() and IFS() SWITCH() SUMIF() SUMIFS(), AVERAGEIF() / AVERAGEIFS()Continue reading “Excel Advanced Formulas”
Tag Archives: Advanced Excel
Tit-Bits of Excel
I’m sure you might be using these Tit-Bits in Excel! A sudden thought triggered to compile all the interesting features and information about Excel as and when I come across so that it will be etched in my mind forever. Let’s get started to learn together. 1. Must have options enabled in Quick access toolbar.Continue reading “Tit-Bits of Excel”
7 Awesome Excel Hacks!
Recently, I can across amazing Excel tips on LinkedIn which are worth sharing. You will be amazed by these shortcuts. I started to learn how Google Sheets works as well. As a first step, thought to document and share them with you all for ease of reference. Stay tuned for top features in Google SheetsContinue reading “7 Awesome Excel Hacks!”
Top 6 FREE Add-Ins for Excel 2019
Microsoft Excel is by far the most used application for data analysis. Mastering Excel is a must-have skill in many companies. It can also be a huge time-saver. Add or remove an Excel add-in. Click the File tab, click Options, and then click the Add-Ins category. Click Insert Menu – Get Add-Ins. In this video,Continue reading “Top 6 FREE Add-Ins for Excel 2019”
10 Excel Hacks + 3 Bonus Tips
Sometimes, the smallest features bring out the best when using Excel. These 20 Excel hacks are worth not being missed. Let’s check out one by one. Next time, you do something in Excel, check if you can use any of these 20 Excel tricks that can make anyone an excel expert. Excel Hack 1 –Continue reading “10 Excel Hacks + 3 Bonus Tips”
Excel Automation using Power Query
Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities. A biggest advantage of Power Query & Power Pivot is, you can have large amounts of data compressed and stored in memory to transform and analyze anytime for creatingContinue reading “Excel Automation using Power Query”
A-Z of Power Query
Create Low Code Automated Dashboard Are you finding difficult to learn VBA – Macros like me? Are you taking more time to clean & transform your data like me? Are you looking for “Low code options to perform ETL process like me? Bored of doing repetitive tasks in Excel? Power Query & Power Pivot isContinue reading “A-Z of Power Query”
Do you know these features in Pivot Tables
Excel is the most commonly used tool for data storage, data analysis, accounting, budgeting, reporting, visualizations and the list goes on. Pivot table is one of the key feature of the Excel and used to various activities like summarize, sort, reorganize, group, count, total or average data stored in the excel. Irrespective of any industry,Continue reading “Do you know these features in Pivot Tables”
LR Virtual Classroom 