Excel 2016

How to Use Mentions in PowerPoint to Get Advice and Feedback

Start Writing Comments and Mention People Involved

Ever wish you could easily and quickly get the attention of a certain team member or manager for feedback on your project? Usually, it goes like this. You finish your document, then email or share it with your team members or submit it to your client. Then you wait for their feedback. If you need …

How to Chat as You Edit Documents in Microsoft Office

Chat with Co-Authors with Office 365

When it comes to productivity and collaboration, Microsoft Office is leading the game. Not only does it have the most advanced programs and features; it also keeps updating them to suit the needs of today’s users. One of its biggest selling points today is its collaborative feature. This allows Office users to work on the …

How to Skip Conditional Formatting for Blank Cells in Excel

Skip Conditional Formatting for Blanks

Conditional formatting in Excel is a feature that allows you to apply certain formatting values on a cell or a range of cells in a table based on certain conditions, or criteria. With this feature, Excel will check the value of a specified cell or range of cells to see if it matches the condition …

How to Analyze Data Quickly in Excel

See Automatic Preview of Selection

Over the years, Excel has been widely used for collecting, documenting, and analyzing data. It has undergone many changes and improvements over time, adding different features that are relevant to the demands of today. With Big Data as one of the many important things businesses and organizations rely on to make sound plans and decisions, …

How to use VLOOKUP to Find a Value in a Table or Range

Fill in the needed values

So you’ve been organizing your data in Excel. You believe you’ve done a good job so far, but when it comes to looking for a particular piece of information, you spend so much time finding it. If this is you, then you may not have heard about the VLOOOKUP tool in Excel. It has many …

Get a Better Handle on Your Spreadsheets with Tickmark Add-in for Excel

Customize Tick Icons

While Excel spreadsheets are one of the most widely used tools for gathering, collating, and analyzing data, there are still many who are daunted by it. The seemingly endless expanse of cells and the wide range of formula and features can leave people confused, especially those who are new to Excel. However, even those who …

My First Add-in VBA Tool for Microsoft Office

Customize Ribbon and Modify Macros

The Microsoft Office suite of programs has a rich set of features that make it easy to work on various tasks and be productive. These features allow you to manipulate, modify, and customize how you work on documents, spreadsheets, presentations, emails, forms, and databases. However, if you are going to do hugely repetitive tasks, especially complex …

How to Automate Creating Slides from Excel to PowerPoint

Automate Excel Tasks

Every organization or business needs a more efficient way to collect, manage, interpret, and present data. While it’s easy to automate certain processes, such as collecting and analyzing information, putting it together in a sensible and legible way can be difficult. This is because presenting data is manual work and can often be a time-consuming, …

How to Maintain Company Branding in Excel Spreadsheets

mrBrand Add-in for Excel

When you think about spreadsheets, pizzazz rarely comes to mind. You only envision blank cells that can go on forever. And if you’re a business that needs to show off your brand, you need to do more than just create tables and diagrams. With the myBrand Add-in for Excel you can maintain company branding in …