Wizard’s tips by email
Search this site
TagsACOS ADDRESS Chart COLUMN CONCATENATE Conditional format COS COUNTA COUNTIF Custom View Dates Dropdown Format Formulae Frequency IF INDIRECT LARGE MAX MID MOD Named ranges Navigation OFFSET Paste Special Percentages PivotTable PivotTables PRODUCT RADIANS RAND RANK Reference Ribbons ROUND ROUNDDOWN Shortcut Sorting Sudoku SUM SUMIF Syntax Text to columns Trigonometry VLOOKUP
Category Archives: Tools
I needed to create some wordsearches recently. So I turned to Excel. I created two identically-sized grids: a blank one in which I could type the words I wanted to appear in their rightful positions; and another one next to … Continue reading
My daughter's in the midst of learning her times tables. There are various apps out there that can help, but I was after something that addressed a specific need. I wanted to be able to specify the times tables that … Continue reading
Here's the spreadsheet you've all been waiting for. The Excel dice shaker. It caters for up to four dice. Simply hit F9 to make 'em shake. Click here to download.
Here's a handy spreadsheet to help you calculate basis points, and prorate their charge as necessary. Simple, but useful.
There are two big problems with most risks and issues registers: They’re difficult to read They’re difficult to maintain. Let’s start with the readability. Usually, they’re a lifeless grid in a tiny font with lots of columns and, depending on … Continue reading
I can’t remember why, but I set myself a personal challenge some time back to create a spreadsheet that could convert numbers to text. Here it is. Type in a number between 1 and 999,999 in the red cell and … Continue reading
I created an Excel year calendar recently. Here's a link to it. It's completely dynamic, allowing you to show the calendar for any year between 1900 and 9999. The only user interaction is to enter the year. The rest of … Continue reading