Excel Roundup 20141124
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.
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.
- Sumit Bansal builds a one variable data table, in the first part of his series on Data Analysis.
- 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.
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
|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.
|Data Analysis in Sport by Peter O’Donoghue and Lucy Holmes
“Introduces the fundamental principles of data analysis, explores the most important tools used in data analysis, and offers guidance on the presentation of results…Covers commercial packages for performance and data analysis, including Focus, Sportscode, Dartfish, Prozone, Excel, SPSS and Matlab”
|LONDON||Abbot Katz is presenting the final course in his series of Excel courses in London, at the offices of the Guardian newspaper near the Kings Cross station.
Nov 24th — Grabbing and grooming the numbers
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!
Links to Recent Excel Books on Amazon.com