Lashmi Bai Ravindrapandian

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”

Why Am I Passionate about PMO

Someone asked why you are passionate about PMO…. I love talking…. Yes, I love talking to people. And in the PMO, I get to talk to many different people from all around the organization. It has given me a unique perspective on the business and how different teams are working together to achieve our goals.Continue reading “Why Am I Passionate about PMO”

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”