This page is a quick reference for Excel tips published on BusinessToolsBlog.com.
Useful Excel Tips:
- Beginning of the Month Function
- Calculate a Full Month
- Calculate the Quarter for any given Date
- Calculate business days
- Change “All Capital Text” to “Sentence Case”
- Change dates to the End of Month
- Change Excel’s color palate
- Color Code Worksheet Tabs
- Convert text to numbers with the Paste Special function
- Count unique data in a range, exclude duplicates
- Create a Custom Toolbar
- Create a drop down selection list in a cell
- Create a new line or line break in the same cell
- Date Arithmetic
- Display numbers in thousands (000’s) with custom cell formatting
- File in Use
- Fix Stretchy Pictures or Logos
- Format Painter
- Formula Auditing
- Goal Seek Function
- Hide a Worksheet, so almost no one can find it
- Hide the field buttons in a Pivot Chart
- Inexact searches
- Matching Colors
- Paste from Rows to Columns, or Columns to Rows by transposing
- Paste Value & Paste Formatting
- Pivot Tables - the best way to work with data in excel
- Preventing objects in a spreadsheet from printing
- Remove Grid Lines
- REPT function to create instant bar chart
- Round numbers in the same cell without a formula
- Sumif formula automates summing
- Unhide All Hidden Sheets with one mouse click
- Using HLOOKUP & VLOOKUP together
Charts:
- Create a Pareto Chart
- Create a Waterfall Chart
- Format a stacked bar chart with negative values
- Gant Chart, how to build
- Link Excel Charts to PowerPoint, so they auto-refresh
- Link Excel Chart Titles to cells in the spreadheet
- Stacked bar chart with positive and negative numbers
- Timeline Chart, how to build
Excel Addins/Utilities:
Excel Shortcuts/Timesavers:
- Custom Command Bars
- Move quickly between worksheets
- Selection arrow to select multiple objects
- Shortcut Keys
- Use the Fill Handle to quickly Copy/Paste across multiple cells
- View 2 or more worksheets at the same time
BlogoSquare