Skip to content
Site logo white shadow
  • Efficiency Workshop
  • Customers
  • Adoption
  • Testimonials
  • About Dr. Nitin
  • Blog
    • Teams
    • Power BI
    • Excel
    • Word
    • PowerPoint
    • Outlook
    • OneDrive
    • OneNote
    • Office 365
  • Efficiency Workshop
  • Customers
  • Adoption
  • Testimonials
  • About Dr. Nitin
  • Blog
    • Teams
    • Power BI
    • Excel
    • Word
    • PowerPoint
    • Outlook
    • OneDrive
    • OneNote
    • Office 365
Search
  • Efficiency Workshop
  • Customers
  • Adoption
  • Testimonials
  • About Dr. Nitin
  • Blog
    • Teams
    • Power BI
    • Excel
    • Word
    • PowerPoint
    • Outlook
    • OneDrive
    • OneNote
    • Office 365
When and How to Remove Top and Bottom Rows options in Power Query to Remove Top and Bottom Rows in Power Query

Here is a quick post to show the practical scenario when the Remove Top and Bottom Rows options are useful while cleaning up data using Power Query. Remove Top Rows

Read »
Learn from the past to improve future using Excel Power BI

Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here. [youtube https://youtu.be/W2sP3n7LYMo]

Read »
How to use Word: Simple to Magical

View this short video to see how Word can be used to modernize your  work and increase efficiency dramatically.  In just five minutes, you will learn how to: Reuse existing

Read »
Hide unwanted columns in Pivot Table with Power Pivot

Redundant or unwanted columns can confuse the users of Pivot Table. Here is how you can hide unwanted columns from appearing in the Pivot Table field list. This setting is

Read »
Powerpoint: Agenda slide from any slide

Agenda slide is usually the second or third slide. During the course of the PowerPoint presentation, we may have to refer to that slide frequently, especially when the next agenda

Read »
How to generate random data with known percentage distribution

Let us say I want to create sample data for my analytics class for a customer. I dont have access to the actual customer data. But I want the data

Read »
Create reports using Power BI for free – without Excel

We have seen many methods of using Excel and related Power BI tools for analyzing data. Now, all that can be done WITHOUT using Excel – using a stand-alone tool

Read »
The Real use of Follow Up Flag in Outlook

We misuse the the Follow up flag in Outlook. Most of us think of it as a method of marking mails which actually are Tasks. Read this article to know

Read »
PowerPoint SmartArt: Knowledge Pack

Here is a list of all the articles I have written about PowerPoint SmartArt. This is a LIVE list. I will update it whenever I write more articles about SmartArt.

Read »
« Previous Page1 Page2 Page3 Page4 Page5 Next »

Popular Articles

  • How to customize annoying Teams Notifications
  • Conduct meetings with two monitors
  • Teams Live Events Dos and Don’ts
  • Conducting Online Conferences using Teams
  • Training Vs Adoption
  • Who can see my OneDrive files
  • Reduce eyestrain using Dark Mode

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

Excel Power BI Course Poster
1100+ in-depth blog articles
Adoption (21) Analytics (139) Animation (25) Best Practices (31) BI (44) Big Data (41) Charts (22) Collaboration (57) Consumption (26) copilot (18) data cleanup (35) Data quality (22) Dr Nitin Paranjape (97) Editing (42) Efficiency (51) efficiency 365 (82) Excel (241) Formatting (43) Formulas (18) graphic design (33) graphics (42) Inbox (20) Knowledge Pack (18) Mail (20) Microsoft 365 (82) microsoft 365 copilot (20) microsoft copilot (21) Office (106) Office 365 (220) OneDrive (33) OneNote (56) Outlook (102) Pivot Tables (23) Power BI (76) PowerPoint (160) Power Query (37) Power View (18) Presentation control (19) security (23) SharePoint (47) Tables (26) Teams (35) Teamwork (25) Word (121) worst practices (20)
Subscribe to Blog

Join 1,761 other subscribers
  • Privacy Policy
  • Contact Us
  • Privacy Policy
  • Contact Us
Linkedin Twitter Youtube