How to build a search box with conditional formatting. Faster (and more fun) than filtering for casual searching. exceljet.net/tips/how-to-bui…
1
David Bruns retweeted
Here's How To Insert Cells And Paste Simultaneously In #Excel wp.me/p3QoSH-AJ
Looking for an obscure character? (Maybe a Cross Pommee?) Draw it, and shapecatcher will find it: shapecatcher.com/ #geeky
David Bruns retweeted
Steve Jobs on the disease of believing that 90% of the work is having a great idea … via @cdixon
Hit 101 functions today on our Excel function page for minimalists. Still lots of work to do though! exceljet.net/excel-functions
1
With VLOOKUP, no need to wrangle a herd of unruly parentheses - exceljet.net/tips/how-to-use…
Does the Excel cursor really move at 10,000 miles per hour? That's our guess! exceljet.net/blog/the-54-exc… (1/3 down the page)
54 Excel shortcuts you really should know (both Mac and Win): exceljet.net/blog/the-54-exc…
How to select visible cells only. Surprisingly useful: exceljet.net/tips/how-to-sel…
Old school: 200 Excel Shortcuts on an actual printed quick-reference card you can hold in your hand: exceljet.net/quick-reference
How to add a "Showing X of Y items" message above a filtered list: exceljet.net/tips/how-to-dis…
New video tip: exceljet.net/tips/how-to-use… That's right, concatenation, baby!
New Excel tip, how to check line length with conditional formatting and the LEN function: exceljet.net/tips/how-to-use…
A short article on breaking down pivot table data by age. Easier than you think. exceljet.net/blog/how-to-gro…
How to use a pivot table to group voting results by voter age: exceljet.net/blog/how-to-gro…
We launched a new course on Excel Pivot Tables, on sale today. Sample videos are here: exceljet.net/core-pivot
Another bite-sized Excel video: sort a pivot table with a custom list exceljet.net/tips/how-to-sor…
Boring but important: if you're building a pivot table from data in an Excel worksheet, use a table. exceljet.net/tips/use-a-tabl…
New video tip - how to group a pivot table by day of week. A little geeky. exceljet.net/tips/how-to-gro…
Modeling Adwords profitability with Excel's Data Tables. Can you make money with pay-per-click? Find out: exceljet.net/blog/how-to-mak…



