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”
Tag Archives: Productivity Tips & Tricks
Email – An extension of your Identity
Often, in the corporate environment, Emails are overlooked and the sender also overlooks the content of the mail while sending without going deep into the reasons behind sending the mail. Many workplace problems arise due to emails. Email mistakes are difficult to correct and can be costly or damaging to your reputation. Many times, peopleContinue reading “Email – An extension of your Identity”
How often you use these in Corporate Emails – Building a “Toolkit of Phrases”
Often, Email communication if not phrased properly, it will lead to misunderstanding along with increase in email exchanges. Sometimes, you go out of words, use wrong tone which will eventually end up things complex. Though there are multiple leads of sites in open source which gives you enormous phrases, I have hand-picked the ones whichContinue reading “How often you use these in Corporate Emails – Building a “Toolkit of Phrases””
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”
Create Project Timeline in PowerPoint in 10 min | No Complex Editing and Formatting |
I strongly believe that, No Business Strategy Initiative will be fruitful without Roadmap in place…. No Project Management Plan is complete without a Timeline in place… Whether it is Portfolio Roadmap Strategy, Program Increment Release Planning or Project Timeline, it is important for anyone to develop skills to build and present a brief timeline. ItContinue reading “Create Project Timeline in PowerPoint in 10 min | No Complex Editing and Formatting |”
15 Powerpoint Presentation Tips
If you haven’t used PowerPoint lately, you haven’t used Powerpoint. Technology is changing so fast, so with this latest update, PowerPoint is packed with a variety of different features that leverage artificial intelligence to help us work smarter and design and visualize our ideas faster. Lets see some of the key features which will make you present your presentationContinue reading “15 Powerpoint Presentation Tips”
LR Virtual Classroom 