When you type something in a cell after an = sign in Excel, a list of functions is shown. Functions have an icon next to them. For some functions, the icon shows a Yellow triangle with an exclamation mark. That is the Excel Function Warning I am talking about.
No warning Warning
What exactly is the Excel Function Warning?
It basically means: “Do not use this function. We have a new and more accurate function available now”. If you use only newer versions of Excel, you should use the newer functions.
Here is an example. The older STDEV function now has two separate functions STDEV.S and STDEV.P – S means sample and P means population. The mathematical formula used behind the scenes by these functions is different. As mathematics advances further, the logic used also undergoes improvement. The newer functions utilize the latest algorithms to increase accuracy of your results.
- Notice if any of the your formulas have one or more Excel Function Warning icon.
- Go to the help file of that function.
- The newer, better or more appropriate function will be listed there.
- Learn the new function(s). Understand what has changed and why.
- Change these across your files to ensure more accurate results.
- Use the new function when you create new workbooks.
I see lot of movies. I am the First-Day-First-Show guy. Usually, I post the Movie Rating on my personal FB page. See some examples below. But recently I posted a Movie Rating Chart. Here is how you do it.
Movie Rating Chart
Continue reading Movie Rating Chart
Hello. Here is the Vietnam session video – 1.5 hours. Most of the narration in the video is in Vietnamese language. If you understand the language, you will love the video. Thanks to Minh Nguyen, the Vietnamese narration is amazing… that is what attendees told me after the session! Thanks to Softline for arranging this event.
This is a special announcement for readers in Vietnam. I am speaking at an event arranged by Softline. We are inviting CFO and CIO from the organizations to attend together. This way, it is much easier to explain the business as well as technical details of technology in a single session. For more information, please contact Ms. Ha Linh at firstname.lastname@example.org Tel: 0918 401 248 or (+848) 3899 2737
See you there!
Outlook now has a new feature to compress ALL attached images in one go. Use Insert – Attachments option to add images. BEFORE sending the mail, open the File menu. You will see the new option. Choose the Resize large images when I send this mail option. Now all images will be compressed by reducing their size to 1024X768 or smaller. Aspect ratio will not be disturbed.
DO NOT use this option if you want to retain original resolution. If the mail bounces because the other person(s) cannot receive such large emails, put the files on some cloud storage (OneDrive, Google Drive, Dropbox, etc.) and send a link.
This feature was released in May 2017. Depending upon the configuration decided by your Office 365 Administrator, you may receive this feature much later. You will get it instantly if you are on the Office Insider – Fast branch.
This long-awaited and demanded feature is now available. Go to any birthday notification and open the three dot menu (… also called the Ellipsis). Choose the Turn Off option and heave a sigh of relief!
As discussed in the earlier article, we can now Change Pivot Defaults. Here is a detailed video which covers how to change defaults.
In addition, learn a new, smart way of keeping commonly used pivot layouts in a simple Excel file and use them on demand. Something like a Pivot layout template.