Hive profile

ExGap Analytics

@exgap

Data Analytics | Microsoft Excel | Data Visualization |Technology

10 followers 12 following 25 posts Reputation 54.71

ExGap Analytics
@exgap Sep 29, 2019, 8:59 AM UTC

Excel Data Analysis : Data Tables

In this session, we are going to look how Excel Data Tables work within What-If analysis. Data Tables is a way for us to interject alternative values into a calculation without the need to recreate t…

6 upvotes 2 replies $0.01
ExGap Analytics
@exgap Feb 13, 2019, 4:43 PM UTC

Excel 2019 VS Office 365 subscription, which one to pick?

Are you wondering which product has more value to your needs? What is the main difference between Excel 2019 and Office 365? You stumbled to the right place as I will try to compare these two product…

21 upvotes 3 replies $0.59
ExGap Analytics
@exgap Feb 13, 2019, 11:30 AM UTC

How to customize your Excel Ribon and increase your productivity

The ability to customize the Excel ribbon is a great way to enhance your workflow, improve on your productivity or simply to give the platform a unique feel to it. In the following article we will un…

22 upvotes 2 replies $0.62
ExGap Analytics
@exgap Feb 8, 2019, 7:09 AM UTC

Introduction to Charts in Microsoft Excel

Charts are a great way to represent your data in a visual form in order to better understand your dataset and get hidden insights which otherwise you wouldn't be able to. Microsoft Excel offers a var…

46 upvotes 5 replies $0.31
ExGap Analytics
@exgap Feb 5, 2019, 12:19 PM UTC

Set a background image in Microsoft Excel with a macro button

Most people see Microsoft Excel as a dull and monotonic platform, however, there are many ways to perform work in a much more pleasing and creative environment by applying few techniques to create at…

18 upvotes 3 replies $0.64
ExGap Analytics
@exgap Feb 3, 2019, 5:31 PM UTC

Introduction to Excel filters and how to extract data

With the following article, I'll try to explain how to use number, text and date filters on your dataset to find exactly what you need, no matter how big your dataset is. Filters represent certain co…

28 upvotes 4 replies $0.45
ExGap Analytics
@exgap Feb 2, 2019, 4:49 PM UTC

How to automate your spreadsheets with Excel macros

I want to teach you with this article on how to join multiple tasks into a single one-second event and this way automate a lot of mundane time-consuming task in your excel workflow. Excel is a fast w…

22 upvotes 2 replies $0.50
ExGap Analytics
@exgap Jan 31, 2019, 7:05 PM UTC

Excel 2019: Introduction to Excel Macros and fundamental rules for using them

Excel macro is a sequence of commands that tell Excel to perform a series of tasks. Generally, those are repetitive tasks, which are prone to errors if repeatedly keyed manually. They are created usi…

18 upvotes 4 replies $0.53
ExGap Analytics
@exgap Jan 28, 2019, 8:53 AM UTC

A free and easy way to build a Budget Spreadsheet

Dear Steemians, the Crypto bear market took a toll on a lot of us and because of that, it might be a good idea to learn how to make a Budget Spreadsheet where we can quickly see our financial picture…

44 upvotes 4 replies $1.11
ExGap Analytics
@exgap Jan 22, 2019, 7:17 PM UTC

Microsoft Excel's AI tool for data visualization

A nicely featured AI-powered visualization tool called Excel Ideas can help extract the essential information from a spreadsheet and shift it to an excellent visualization to give its user better dec…

26 upvotes 1 replies $1.20