This is the continuation of the article Efficiency Test: Excel Data Cleanup
The date cleanup challenge was to change all cells having dd-mm-yy formatting to dd-mmm-yy formatting across all sheets in the most efficient way. Continue reading Efficiency Test 3: Excel Date Cleanup : Solution →
The Word and PowerPoint efficiency test have become very popular. So here is another one for Excel. It is a very interesting test. The problem looks simpler. But you will learn a lot while finding the solution. Continue reading Efficiency Test 3: Excel →
In the previous article, we saw how audio recording in OneNote synchronizes automatically with your notes.
This feature can revolutionize how students attend lectures and take notes.
Read on to find out how you can benefit from learning with OneNote as your enabler.
Estimated reading time 4 min.
Continue reading Students – try this new way of learning with OneNote →
Do you spend lot of time capturing detailed minutes of meeting or taking exhaustive notes while attending lectures? Very often you get less time to participate and concentrate on the content.
OneNote offers a brilliant solution to this problem: OneNote Audio Recording.
Estimated reading time 10 min.
Continue reading Never miss important points during a meeting. Use OneNote audio recording. →
How do you know if your method of getting work done using Office is efficient or inefficient?
Here is a simple but powerful test you can use to find out.
Estimated reading time 4 min.
Continue reading Inefficiency test: Hands vs. Brain →
With little effort – and lot of fun, you can create amazing backgrounds for PowerPoint using Surface Pro.
Learn how to do finger painting and smudging using Fresh Paint and get outstanding results.
Reading and practicing time 15 min.
Continue reading Create PowerPoint backgrounds with finger painting and Fresh Paint →
We take accuracy of Excel data for granted.
Often the raw data as well as results of formulas can be wrong, outdated or misleading.
Here is a collection of 13 data accuracy articles which will help you ensure the integrity of your Excel data with minimal effort.
Continue reading Knowledge Pack: Data Accuracy in Excel →
Here is a new way of learning. I give you a sample file and a task to perform.
Do it your way .. and then check it against the most efficient method. Continue reading Efficiency Test 2: Word- Fit table inside the page →
I wrote many articles recently about using ZOOM while presenting. I originally thought I will write only one article, but ended up writing 6.
This Zoom KNOWLEDGE PACK will guide you to the right article, depending upon what you need.
Continue reading Zoom Knowledge Pack for High Impact Demos and Presentations →
In the last few articles I covered how to zoom the entire screen while showing demos.
Since version 2013, PowerPoint offers a brilliant new zoom feature.
It is easy to use and very effective.
Estimated reading time 4 min.
Continue reading PowerPoint 2013: How to use PowerPoint Zoom to show details →
Posts navigation
Achieve more with less effort by using Office 365 platform efficiently. Learn from the Efficiency Guru, Dr. Nitin Paranjape @drnitinp