Rob Ferguson

63 Flips | 3 Magazines | 16 Likes | 1 Follower | @REFerguson | Keep up with Rob Ferguson on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Rob Ferguson”

Charley's Swipe File Chart Figures, Page 1

Windows & Mac Excel<p>Learn Excel Charting Tricks while Giving Your Managers,<br>Customers, & Clients Professional Excel Figures Like These<p>This is the …

Data Visualization

Transform Data By Example—a Microsoft Garage project for Excel - Microsoft 365 Blog

A common problem facing Excel users is <i>data wrangling</i>—transforming raw data into a different format so that it can be used for further analysis. For …

Software

How to calculate median in Excel

The median is one of the three main measures of central tendency, which is commonly used in statistics for finding the center of a data sample or …

Geek Deals: Lifetime Subscription to eLearnExcel Microsoft Excel School for $39

Looking to step up your game with Microsoft Excel? Want to become more efficient in your day-to-day work? Today, StackSocial is offering up a meaty …

Microsoft Announces the Return of Export to Excel

At the start of May 2017, Microsoft announced that <b>Export to Excel/CSV would no longer be available to Power B Free users</b>, and would not be part of …

Highlight Actions in Microsoft Excel with Multiselecting

How to implement Highlight Actions in Microsoft Excel with the option to select more than one category (Multiselecting)<i>Clearly and Simply proudly</i> …

Highlight Actions in Microsoft Excel

How to implement a specific Highlight Action Use Case in Microsoft ExcelHighlight Actions in Tableau allow you to visualize all data points related …

Make an instant workplace impact with this Excel training

Microsoft Excel is not just a popular spreadsheet program, it's also powerful. More employers are looking for Excel-proficient employees to crunch …

Microsoft Excel Addict Tips - Highlight All Cells in a Worksheet Matching Your Find Criteria

<b>June 1, 2017</b><p>Hi fellow Excel Addict,<p>Sorry I don't have any scenic pictures of Newfoundland to share with you this week, unless you'd like to see that …

Software

How to format Microsoft Excel to show leading zeroes

Microsoft Excel will default to eliminating zeroes that precede a number. Here are two methods for inserting leading zeroes in Excel.

Software

14 Excel Tips and Tricks

In almost any line of business, it’s likely you’ll use Microsoft Excel at some point.<p>Excel has a powerful range of features, but it can also be …

Tutorials

#2 — IFTTT and Google Sheets: Create a List of my Medium Blog Posts

When I post (in Medium), have the post added to a new row in a Google Sheet<p>The Challenge?<p>I blog on Medium (duh, that’s where you are seeing this!) …

Microsoft Excel — RSS News Feed Into Excel Using PowerQuery?

This was the Challenge Question I Got Today<p>The Challenge?<p>This question came up with a client CFO today because we were looking for an easy way to …

How to create a pivot table in Microsoft Excel

Using a pivot table can increase your productivity in Excel. Here are two simple ways to create one.

Analytics

How to use Microsoft Excel's Conditional Formatting

Microsoft Excel's conditional formatting is a wonderful "automatic" feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, you can specify that all the sales totals in your spreadsheet that exceed $5,000 are highlighted …

Microsoft Excel — Sharing PowerQuery Queries Between Excel Workbooks

Overview<p>The more you use PowerQuery (“Get and Transform” in Excel 2016), you will encounter situations where you want to share a query with others or …

Analytics

9 in-demand skills to add to your resume (and where to learn them)

It's a developer-eat-developer world out there. If you want to stand out from the pack, you've got to show potential employers that your resume is …

Transform Data by Example, a Microsoft Garage project for Excel - Microsoft Garage

Many Excel users can relate to the problem of data wrangling.<p>You start with an input data set that you wish to transform into a new format so that …

desired

Microsoft Excel definitions for common terms

The rewards for mastering Microsoft Excel are numerous, though the first steps may be intimidating. Some may get lost in the spreadsheet jargon and …

A Comparison of Peltier Tech and Excel Box Plots

Box and Whisker Charts in Microsoft ExcelA customer asked me to compare <b>Excel Box Plots</b> between <b>Peltier Tech Charts for Excel 3.0</b>, a commercial VBA …

What Is a Database?

Make the leap from a spreadsheet to a database<p>Databases offer an organized mechanism for storing, managing and retrieving information. They do so …

Databases

eLearnExcel Microsoft Excel School: Lifetime Subscription | The Daily Dot Store

Microsoft Excel is one of the most widely used applications in business today, becoming integral to everything from data crunching to organizing …

Software

Impress Your Boss By Mastering Excel

<i>Everything you need to know about the art of the spreadsheet.</i><p>Think you know Excel? We promise, you don't know it the way you could with a lifetime …

Microsoft Excel

How to count duplicates in Microsoft Excel

There are various ways that duplicates can occur in Microsoft Excel. Check out one method for counting duplicate records in Excel.

Software

Reminder: Microsoft Excel Specialist Certification Bundle, Save 99%

Just a quick reminder for our readers about the great deal on the Microsoft Excel Specialist Certification Bundle in the Geeky Gadgets Deals …

Tips to Use Counta Formula In Microsoft Excel

Microsoft Excel remains one of the most popular software options in the business industry today due to it’s many capabilities. Amongst all of the …

Software

Microsoft Excel — 1 Essential PowerQuery Design Step

If you “Load Data” Into an Excel Worksheet — Do This<p>Everytime you “Refresh” a Query through PowerQuery, the <b>default setting is to adjust the column</b> …

Software

This bundle will make you your office's Excel guru

Excel, Microsoft’s venerable spreadsheet program has some seriously powerful capabilities. But unless you know where to look in the maze of menus and …

Software

Microsoft Excel — Apply the Pareto Principle to Building Your Excel Data Skills

Targeting Your Learning is Key — and the “80/20” Rule is My Approach<p>Most professionals use Excel. And most want to get better with it…as this recent …

Analytics