#308 All Things Excel

This week we’ll continue our compilation series with a full set of Excel tips.  If you are pressed for time you can also just jump to the Clif Notes version.

Setup

#301 Defaulting to Your Favorite Font on October 19, 2012

#288 Four Ways to Customize Excel for the Way YOU Work on July 20, 2012

#284 Roll Your Own Templates on June 14, 2012

#267 Display Multiple Excel Worksheets Side-by-Side on February 17, 2012

#230 Displaying Two or More Tabs of an Excel Worksheet on June 2, 2011

#226 Excel Readability on May 5, 2011

#199 Excel: Automatic Column Sizing on October 19, 2010

3 Office Annoyances & How to Fix Them on February 26, 2010

#171: Using Snap Off Toolbars in Microsoft Office on April 7, 2010

Formatting

#298 Excel Zebra Stripes on September 28, 2012

#293 Show Only A Few Rows & Columns of Your Spreadsheet on August 24, 2012

#272 Automatic Separator Lines in Excel on March 23, 2012

#271 Add a Watermark to an Excel Worksheet on March 14, 2012

#247 Cleaning Up Your (Excel) Act: Part 2 on September 30, 2011

#246 Cleaning Up Your (Excel) Act: Part 1 on September 23, 2011

#235 Quickly Paint Formatting on July 6, 2011

#194: Copy Excel Page Setup Settings Between Sheets on September 15, 2010

#190: View/Hide Excel Formulas on August 19, 2010

#158: Excel Conditional Formatting on January 8, 2010

#41: Shading Alternate Rows in Excel on October 12, 2007

Working With Data

#275 Quick & Dirty Excel Data Comparison on April 13, 2012

#304 Round & Round We Go on November 9, 2012

#244 5 Things You Should Know About the Excel Fill Handle on September 9, 2011

#239 Excel Range Names on August 3, 2011

#232 Do you F5? on June 16, 2011

#231 Navigating a Selected Range of Cells in Excel on June 10, 2011

#219 How do I love thee? Let me count the ways… on March 18, 2011

#213 Excel Custom Sorting on February 3, 2011

#211 Move & Copy Excel Worksheet Tabs on January 20, 2011

#207 Excel Data from Elsewhere on December 17, 2010

#197: Excel’s IF Function on October 8, 2010

#172: AutoFilter Formula on April 15, 2010

#174: Excel – The Power of ‘IF’ on April 28, 2010

#182: Navigating Excel Tabs on June 24, 2010

#188 Excel Auto-fill Options on August 4, 2010

#183: Save or Close All Documents at Once on July 2, 2010

#164 Excel Subtotals on February 19, 2010

#163: Become a Superhero with Excel Subtotals on February 19, 2010

#160: Excel String Functions: The Sequel on January 22, 2010

#159: Save Time Using Excel’s “Big 3″String Functions on January 13, 2010

Images & Charts

#266 Copy/Paste vs Inserting Images on February 10, 2012

#245 Resizing & Cropping Images on September 16, 2011

#186 Quick & Easy Excel Charts on July 23, 2010

More Good Stuff

#297 Hyperlinking in Excel on September 21, 2012

#305 Linking to Network Locations on November 16, 2012

#256 Save Time With Excel Workspaces on December 2, 2011

#252 Lightning Fast Links on November 4, 2011

#241 Printing Spreadsheets on August 19, 2011

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s