In a short video, Sara Silverstein shows 6 keyboard shortcuts for formatting numbers in Excel. Do you use any of these?
You can see the shortcuts in the video below, or on the Business Inside website.
Contextures Posts
Here’s what I posted recently:
- Ignore blank cells when copying and pasting on a worksheet
- Create a simple calculated field in a pivot table
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. There is a poll at the end, so please vote for your favourite tweet.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Instead of showing all your data in a chart, use Jon Peltier’s technique to create variable endpoints for the chart data.
- If you’re just getting started with programming, Philip Treacy explains how workbook and worksheet events work.
- Chandoo shares a quick tip for opening and saving files faster in Excel 2013.
- The Dashboard Spy ask if there is a difference between dashboards and scorecards.
- Charles Williams thinks that there are better alternatives to both VLOOKUP and INDEX/MATCH.
- Chris Webb shows how to combine data from multiple Excel files with Power Query, the easy way.
- And for another Power Query trick, Ken Puls shows how to combine multiple worksheets in Power Query.
Excel Announcements
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
The ModelOff 2014 finalists have been selected, and you can attend the finals:
Sunday December 7, 2014 at Microsoft in New York |
|
ONLINE |
Registration is open for Felienne Hermans’ MOOC Course — Data Analysis: Take It to the MAX()
“Using video lectures and hands-on exercises, we will teach you cutting-edge techniques and best practices that will boost your data analysis and visualization skills.” You can audit this 8-week course for free, and classes start Apr. 6, 2015. |
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!