Profile

Cover photo
273 followers|49,125 views
AboutPostsPhotosYouTube

Stream

Contextures Inc.

Shared publicly  - 
 
Do you spend more time fighting Excel, or Googling how to use it?
These are the burning questions in this week's collection of #Excel tweets, for your Friday entertainment.
Always save your work if you hear thunder, so you won't have another "Deja screwed" moment. And if you're still in college, spend some time learning how to use
1
1
Debra Dalgleish's profile photo
Add a comment...

Contextures Inc.

Shared publicly  - 
 
How many hours have you wasted by pressing F1 instead of F2?
Here is this week's collection of #Excel tweets, for your Friday entertainment.
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Chart labels, mouse tricks, VBA intro, hyperlinks  
Read these tips + more in my weekly #Excel roundup
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Compare #Excel worksheet values with the INDIRECT function
Use with the FORMULATEXT function, in Excel 2013, to compare formulas too.
If Excel sheets are set up identically, you can create 3-D formulas, to sum a specific range, in a group of sheets. (You can use other functions in a 3-D formula too, such as Average, Count, Min or Max.) For example, this workbook has sheets for the East, Central and West regions, and all three ...
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Have you ever gone pivot table mad?
Here is this week's collection of #Excel tweets, for your Friday entertainment.
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Spreadsheet models, chart types, journalism, pixel art + more
Read these tips + more in my monthly #spreadsheet roundup
1
Add a comment...
Have them in circles
273 people
Karthikeyan T's profile photo
Heiko Heimrath's profile photo
Daryl Lamy's profile photo
zoz81's profile photo
Mike Bradburn's profile photo
mohamed helemish's profile photo
Tian XIA's profile photo
Sanjoy Ojha's profile photo
AliReza Zare's profile photo

Contextures Inc.

Shared publicly  - 
 
Fix dates, refer to tables, weekly planner, apply exchange rate  
Read these tips + more in my weekly #Excel roundup
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Download my free #Excel weekly meal planner - select meal items and print a shopping list.
Functions calculate costs, with a pivot table and macro for the shopping list.
There is an Excel weekly meal planner on my website, and you can use it to organize your meals, and create a shopping list. I hadn't used it for quite a while, and after opening it this week, I decided it was time for an update. Excel Weekly Meal Planner http://blog.contextures.com/ ...
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Does every job involve making Excel charts all day?
Here is this week's collection of #Excel tweets, for your Friday entertainment.
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Pivot layout, dashboards, nested IFs, date formats
Read these tips + more in my weekly #Excel roundup
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Use the keyboard, or right-click menus, to move fields in an #Excel pivot table layout
Last week, someone asked me if there is a menu command for moving the fields in a pivot table layout. For example, if the Region field is in the Columns area, can you use a command to move it to the Rows area, or do you have to drag it with the mouse, in the PivotTable Field List?
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Flexible formulas, Power BI, interactive chart, invalid entries
Read these tips + more in my weekly #Excel roundup
In this week's roundup, fix drop down lists that allow invalid entries, create an interactive chart, get a free Excel book on Kindle, and much more. If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
1
Add a comment...
People
Have them in circles
273 people
Karthikeyan T's profile photo
Heiko Heimrath's profile photo
Daryl Lamy's profile photo
zoz81's profile photo
Mike Bradburn's profile photo
mohamed helemish's profile photo
Tian XIA's profile photo
Sanjoy Ojha's profile photo
AliReza Zare's profile photo
Contact Information
Contact info
Email
Story
Tagline
Business solutions with Microsoft Excel and Access
Introduction
Providing Excel tips and tutorials at Contextures website.

Custom business solutions using Microsoft Excel and Access.