Microsoft Excel Consulting & Office 365 Blog | Excel Help - Page 9
Your Programming and Traning Professionals

Excel Help Blog

Using Custom Microsoft Solutions to Analyze your Bid Management Process

All About Excel Pivot Tables

All About Excel Pivot Tables

Pivot tables are a powerful data analysis tool that you can use to get insights into the data that you are working with. To create pivot tables, you need to first of all organize your data into clear rows and columns with labels that make sense for the data that you are working with, so […]

Read More
Using Power Query to Clean Your Excel Data

Using Power Query to Clean Your Excel Data

Power Query is a handy feature in Excel that helps you to clean your data, and change it into the format that you need it in. Power Query has been available in Excel for a long time, although in Excel 2016 it was called Get and Transform instead. This tool is an ETL (Extract, Transform […]

Read More
New AI Features Available in Excel

New AI Features Available in Excel

Excel is an incredibly useful piece of software that can be found in offices across the world. However, many of the companies that use this software aren’t taking advantage of the full range of features. Microsoft recently added some new AI based features to Excel that can make this software tool even better. Ideas – […]

Read More
What Is The Difference Between Excel 365 and Excel 2019?

What Is The Difference Between Excel 365 and Excel 2019?

Technically Excel 2019 is not yet available, however, many of the new features are accessible to subscribers to the Office 365 version. Microsoft has been moving toward a subscription-based model in recent years in order to make incremental changes rather than big changes to file types that posed all sorts of difficulties for Excel users. […]

Read More
Select New Features in Excel 2019

Select New Features in Excel 2019

Microsoft is rolling out several new features in Excel 2019, some of which are already available to Office 365 Subscribers. Here we will highlight a few of our favorites: Funnel Charts and the IFS, MAXIFS, MINIFS and SWITCH functions. Funnel Charts Funnel charts are commonly used in sales organizations to show how leads are converted […]

Read More
Data Prep: Unformat your Formatted Tables

Data Prep: Unformat your Formatted Tables

Tables come in many styles and formats. For reporting purposes, the better a table is formatted, the easier it is to read. However, formatting is often our enemy when we attempt to use the data for analysis, database, and data integration purposes. In this blog post, we will demonstrate how to unformat a table and […]

Read More
Create a Heatmap from a Large Data Set using Excel’s Power Maps

Create a Heatmap from a Large Data Set using Excel’s Power Maps

One of the exciting new features of Excel 2016 is the capability to generate geographical maps. This feature, called Power Maps, is now also available for Excel 2013. The types of maps that can be generated with Power Maps are only limited by your imagination! After covering the basics, we will demonstrate how to create […]

Read More
Venturing Away from Excel’s Home Tab: The Data Tab

Venturing Away from Excel’s Home Tab: The Data Tab

If you tend to avoid venturing away from Excel’s home tab, where you feel most comfortable, you are missing out on some features that could make your life easier. The Excel 2016 Data Tab, for example, is packed with useful functionality. In this post, we will review the functionality available in the “Get & Transform,” […]

Read More
Why Microsoft Word is the Best Tool for Transcription

Why Microsoft Word is the Best Tool for Transcription

The key to maximizing the return on investment seen from transcription is the speed, accuracy, and overall efficiency with which the transcription can be completed. A large portion of the responsibility in realizing these goals lies with the person performing the task. As a general rule, the more experienced and skilled a transcriptionist is, the […]

Read More
Using Excel Online for File Sharing with OneDrive and Excel Desktop

Using Excel Online for File Sharing with OneDrive and Excel Desktop

Microsoft Office 365 provides users with a combination of widely used and familiar applications, such as Excel, Word, and PowerPoint, along with some new tools, cloud storage, and more. This post intends to bring some clarity to the use and sharing of files with Excel Online, and how that relates to Excel Desktop and OneDrive. […]

Read More
1 7 8 9 10 11 15