logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Tag: Productivity

A Brief introduction to Microsoft’s PowerApps Platform

November 27, 2016 0 comments Article Advanced, PowerApps

After several months of being in Preview, Microsoft has moved its PowerApps service into General Release – though if PowerBI is anything to go by, we’ll see regular updates and enhancements in the coming months    . If you’re not familiar with PowerApps, it’s a tool to create Data-Driven mobile phone applications in a Graphical Interface, and Read More

Transferring Data & Parameters Between Screens in PowerApps

November 27, 2016 4 comments Article Advanced, PowerApps

If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I want to show you how to transfer data between screens. This assumes you have created a data connection (See also: Creating a connection to an Enterprise Gateway), and have brought some data into your app (in Read More

Using Formula Tracing in Excel

October 22, 2016 0 comments Article Easy, Excel

Formula tracing is a fantastic visual tool in Excel you can use to understand 1) which cells a given formula is referencing and 2) whether a given cell (or range of cells) is used by a formula elsewhere. Both have their uses, but it’s certainly the latter I get the most use from. Read on Read More

15 Functions Every Aspiring Excel Pro Should Know

October 11, 2016 0 comments Article Excel, Intermediate

When you first start using Excel, you’ll quickly become familiar with using basic functions such as SUM, COUNT, MIN, AVERAGE Before long, you’ll be using VLOOKUP’s, IF’s and creating Pivot Tables in order to start bringing you data to life. However, it’s around this phase that I often see people plateauing in their Excel learning Read More

Improvements in how CSV File Saves are Handled in Excel

September 7, 2016 0 comments Article Easy, Excel

Microsoft have this month released an update which addresses a small, yet incredibly annoying ‘feature’ when working with csv files in Excel. Read on to learn more. Read More

Determine if a file is open in Excel or Google Sheets

June 21, 2016 0 comments Article Easy, Excel

We currently use a mixture of Excel and Google Sheets. Not ideal, but it’s important that any output I create can behave with both platforms, there are inherent differences in the platforms. Some of these differences simply can’t be accommodated for. Others, however, can be worked around From time to time, I need my document Read More

Using the same Named Range in multiple worksheets, but with different values, in Excel

May 3, 2016 1 comment Article Excel, Intermediate

Use this trick to create use the same Named Range across multiple worksheets, but with each worksheet holding a different value Read More

Using TEXTJOIN and CONCATENATE for combining Text Strings in Excel

March 31, 2016 1 comment Article Easy, Excel

Learn about the different techniques for joining Text Strings in Excel, including the excellent new TEXTJOIN function Read More

Populating one Drop Down based on the Selection of Another in Excel – Without VBA

March 22, 2016 1 comment Article Excel, Intermediate

This post will show you how to populate a drop-down menu in Excel with values, based on the value selected in another drop-down menu – all without touching VBA Read More

Using NETWORKDAYS to calculate the number of business days between two dates in Excel

March 14, 2016 0 comments Article Excel, Intermediate

NETWORKDAYS (That’s Net Work Days, not Network Days) is a versatile spreadsheet function that lets you calculate working days between two dates, allowing for weekends, public holidays and more. Read More

1 2 3 4 »

Most Read Articles

How did Microsoft’s Power BI come to lead the Gartner Magic Quadrant?

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2025 - Theme by ThemeinProgress