Microsoft Office
-
Create a Pivot Table in Excel—The Easiest guide
Learn how to create a pivot table in Microsoft Excel
-
The Best Excel Project Management Template in 2021
Excel templates make everyone’s life easy, more so if you are a project manager. An Excel project management template can be a lifesaver if you have short deadlines & need a report ready in a jiffy. Let’s see why. Completing a project with minimal setbacks and hitches along the way is the ultimate goal of…
-
Excel SUMIF vs SUMIFS – The Complete Guide
This article deals with the Excel SUMIF and SUMIFS functions. You’ll learn how to use them along with their key differences. In this article, I’ll cover: Difference Between Excel SUMIF and Excel SUMIFS Functions In your Excel journey, you’ll probably come across situations where you need to find the SUM for certain values only. Located…
-
Create an Excel Dashboard in 5 Minutes – The Best Guide
This Excel Dashboard tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Create a simple interactive Excel dashboard to display critical metrics in 5 minutes. This Guide Covers: Excel Dashboards Explained Have you ever wondered how all those dynamic dashboards with eye-catching graphs and pie-charts that turn heads and receive applause…
-
How to Make An Excel Forecast Sheet in 3 Steps – The Best Guide
This Excel Forecast Sheet tutorial is suitable for users of Excel 2016/2019 and Microsoft 365. Objective Create an Excel forecast sheet to analyze and predict future sales. Display the historical and predicted values in a line chart using the Excel forecast sheet. This Guide Covers: Excel Forecast Sheet Explained Imagine this, you have been…
-
Excel Dynamic Array: 8 Must-Know Formulas
This Excel Dynamic Array tutorial is suitable for users of Excel for Microsoft 365. Objective Explore Microsoft’s NEW Excel Dynamic Array Functions and use them effectively to solve problems. This guide covers: Excel Dynamic Array Explained Dealing with an Excel array is quite complicated in itself, don’t you think? What if there is a…
-
Introduction to Power Automate
In this recorded webinar we look at how to get started using Power Automate from Microsoft. Power Automate allows you to automate repetitive tasks across Microsoft and non-Microsoft applications. Want to automatically download and save any attachments you get via email? No problem. Want to post a reminder in a Microsoft Teams chat at the…
