Excel 2019

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, …

Create Financial Statements Easily in Excel using Checkbook Assistant Add-in

Keep Track of Your Expenses

Financial statements are one of those crucial financial documents that you need to prepare as a business entity. While there are many apps and software that can help you create these, Microsoft Excel has everything you need to make financial statements–all for free. So, why should you shell out unnecessary expenses when you can easily …

SEO Gadget for Excel

Get SEO Gadget for Excel

For a very long time, we’ve relied on Microsoft Excel to make better sense of data, organize and sort them, as well as make calculations. We also use Excel to visualize otherwise complex information, create reports, solve problems, and generate valuable insight. SEO Gadget for Excel can help streamline your SEO related data management tasks.

How to Generate Random Numbers, Dates, and Booleans in Excel

Generate-Dates-And-Other-Random-Data

You may not realize it, but it’s quite hard to generate a random number. However, there will be many situations when you need to do so, such as data analysis, for getting a random winner from a list or coming up with a password. Whatever your purpose is, you can generate random numbers as well …

Cleanup and Standardize Excel Sheets with XL Tools

Select-Data-Range-You-Want-To-Cleanup

For some, working with Excel can be daunting. Filling up the blank cells, writing the correct formula, and just facing numbers can be challenging. Most likely, this is because working in Excel is not the same as working on Word, which is more straightforward. Of course, the two are different and there will be instances …

New Features of Office 2019

PowerPoint 2019 Edition

Microsoft is starting to slowly unveil its latest masterpiece–Office 2019. Prior to this, people in the technology sphere have been abuzz with the features that Office 2019 will bring to the table. Now that their giving previews of its features, the mystery is slowly being lifted. But when will it be released? What can we …