Profile

Cover photo
29 followers|25,298 views
AboutPostsPhotosVideos

Stream

Power Spreadsheets

Shared publicly  - 
 
5 More #Excel Tips and Tricks for Accountants
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
When Are 100% Stacked Bar Graphs Useful?
I'll begin this blog article by answering the question that appears in the title. I've found that 100% bar graphs, designed in the conventional way, are only useful for a limited set of circumstances. Unlike normal stacked bars, the lengths of 100% stacked bars never vary, for they always add up to 100%.
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
Able2Extract: Quickly Convert PDF To #Excel In 6 Easy Steps (Or Less)
2
2
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
The Simplification & Emphasis Approach to Editing Graphs
I teach about data visualization a lot. And it basically comes down to two techniques: simplification and emphasis. Here’s a default graph with fictional data: First, simplify the graph. Remo…
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
Using #Excel Custom Number Formatting as Data Validation Tool
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
#Excel LEFT, RIGHT, MID, LEN, FIND And SEARCH Functions: Learn How To Use Them With A 9-Step Example
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
MS #Excel: How to use the RANDOMIZE Function (#VBA)
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
#Excel #VBA Replace Function to Replace Characters in a String
Use the VBA Replace function to replace a substring of characters in a string with a new string. VBA Replace is similar to the Excel SUBSTITUTE function.
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
This #Excel trick lets you easily spot trends in piles of data
2
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
NEW: #Excel Pivot Table Group: Step-By-Step Tutorial To Easily Group And Ungroup Data
1
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
Compare Ranges in #Excel #VBA
Learn how to create a program in Excel VBA that compares randomly selected ranges and highlights cells that are unique.
1
Add a comment...

Power Spreadsheets

Shared publicly  - 
 
Understanding How to Use Circular References in Microsoft #Excel
2
Add a comment...
Story
Tagline
Become an Excel Power User
Introduction
Become an Excel Power User.