Latest News

Excel & Office 365 Custom Solution Advice

Creating Art in Excel

How many times have you been there? Hours of compiling and scrubbing data. Then days at the keyboard to get the Excel formulas and marcos just right so reports run correctly. Followed by the arduous back and forth of End User Testing only to hear “Can you make it look better? It just looks too […]

Read more

Forms in Excel, a new way to implement Excel surveys within Office 365

When you need to create a quick and efficient feedback gathering tool The need to gather feedback and be able to process the data is a key element for all of us. Whether we need to validate content, performance or just get opinions, you need a quick method to do this. There are paid services […]

Read more

Keep Track of your Money in Excel

Microsoft is doing it again. They are making a move from within an app or solution that will expand into their greater offering ecosphere. We are talking about Microsoft Money – the easy and dynamic personal finance management add-in aptly called Money, now available in Excel for Microsoft 365 Personal or Family subscribers. First let’s talk […]

Read more

The Latest Excel Updates for Summer 2020

Workbook Statistics At last! A feature that’s been long-asked for, Workbook Statistics is finally available. With this new option, you can have an instant snapshot of the elements your workbook contains. In terms of the worksheet you’re currently working on, you can now see in which cell your worksheet ends, how many cells have data, […]

Read more

How Excel Can Be Used for eLearning

With the digitization and computerization of the world today, the education field has not been left unaffected. Education and the internet have combined significantly over the last decade to provide people with skills and many learning institutions have adopted remote learning in the form of eLearning. Among the computer programs you will find in just […]

Read more

10 Excel Features You Might Not Know About

Let’s face it: Excel is a very complete tool, with a lot of features a casual user might not be aware of. Today we’ll take a look at them and show you how they can improve your workflow! 1. Hide content with outlines For a very quick way to hide certain contents, look no further […]

Read more

Remote Excel Training: What You Need to Know

Excel skills are among the most valuable traits out there and required in a wide array of jobs. And you don’t even need to leave your home to get certified! Here are some reasons why you should consider remote Excel training like the one we offer here at ExcelHelp. The Basics A lot of people […]

Read more

The Best Excel Shortcuts

Shortcuts are a way to improve your productivity and save time—as well as keeping you from reaching to that mouse when you just want to be using the keyboard. Today, we’ll show you some of the best Excel Shortcuts that can make your life so much easier. The Basics Need to select all items in […]

Read more

How to use XLOOKUP on Excel

LOOKUP functions are functions that return a certain value from a range or array. The VLOOKUP function has been in Excel since the software’s first incarnation in 1995, back in Excel 1 for Macintosh. It was incredibly useful and was for 3rd most used function in Excel after SUM and AVERAGE. Problem was, VLOOKUP only […]

Read more

Custom Quotation Software for Excel

Quotation and invoicing software is exactly what it says: it lets you create invoices and quotes, as well as keeping track of your business expenses. Today we’ll take a look at Custom Quotation Software for Microsoft Excel, and how you can begin to use it for your own business. First, let’s see the quotation templates […]

Read more