Tips

How to use IFNA Function in Excel

if function in excel example

There is the Excel IF function that creates True or False results. However, if there is an N/A error, there is another function that takes care of that. This is the IFNA function in Excel. In a previous post we showed you how to use the AND function. This time we will show you how …

How to Use the AND Function in Excel

and function in excel

Excel is a nifty application for all kinds of data gathering, sorting, and analysis. One of its best features is that it allows users to make use of logical expressions. These are then used to check if certain conditions are met in a list of data. This particular function is called the AND function.

How to Freeze Panes to Lock Columns and Rows in Excel

freeze panes

When you’re working with spreadsheets, there can be a lot of data that your worksheet would take up many cells. It can be easy to get lost, if this is the case. You may have a hard time recognizing what row or column the cell you’re viewing belongs to. And this is where Microsoft Excel’s …

All About Using Real-Time Collaboration for a Word Document

Share Your Word Document for Collaboration

Also known as real-time collaboration, Word makes it now possible for users to co-edit a document remotely and at the same time. This is, of course, an answer to the growing inclination for apps, especially productivity apps, to become more collaborative. With Microsoft Word, multiple people can work together on a document. This allows people …

How to use Slicers in Excel to Filter Data

Choose Data to Display

Using a Slicer in Excel is one of the best ways for you to filter your data. This is especially true if you have a large and complex data set. If you want to figure out a single category or view a specific data set under specific conditions, then a slicer can help you with …

8 Key Must-Have Elements to Make a Professional Presentation

8 Key Must-Have Elements to Make a Professional Presentation

A professional presentation requires a few key elements that can help you achieve desired goals. When presenting before a group of professionals, you need to be mindful of certain things which can help you acquire desired results by ensuring that your content is clear, cohesive and sends out a message that can resonate with your …

How to Use Your Smartphone as Remote and Laser Pointer for PowerPoint

Laser Pointer PowerPoint for Android

These days, we rely on our smartphones for so many things. From our schedules to our calls, workouts to socialization, alarms, and productivity. And now, we can also use our smartphones for presentations, particularly as a remote and laser pointer. Here is a tip on how to use your smartphone as a remote and laser …

How to Insert a Linked Excel Chart in PowerPoint

Embed or Insert Chart from Excel to PowerPoint

When you’re creating PowerPoint presentations, listing your ideas and data in every slide can make your slides look dull. It’s nice to break it up with images and visuals. And while pictures can paint many words, if you want to present comprehensive information, you have to have charts. Here is a tip on how to …

Delete Files Protected by TrustedInstaller in Windows 10

TrustedInstaller

There are a lot of files in Windows based operating systems which come with restrictions. The TrustedInstaller.exe is a Windows Module Installer service in Windows OS which performs the function of installing, modifying and removing system components and Windows updates. Sometimes, you might require deleting a file or folder managed by TrustedInstaller. In such a …

How to Add New Shapes to Existing SmartArt Graphics

Hierarchy SmartArt Graphic for Organizational Charts

SmartArt graphics are widely used these days in Microsoft Office, particularly in PowerPoint, as a tool to visualize information. With SmartArt graphics, you can create attractive designs that also convey a story or a message. Therefore, your documents, in this case, your slideshows, will be tidier and more concise. Learn all about how to add …