Free Advanced Excel Download
Last month, Bob Mac Leod, our resident international finance, and spreadsheet, expert at Lake Hart, gave an entertaining presentation of Excel features for about fifty staff. (Who knew learning advanced Excel could be so much fun!) Bob created a great handout for all of us to learn about: Using Excel graphs in other software such as Word or PowerPoint Keeping a history of changes (spreadsheets reflecting different time periods) What to do about the default date setting (e.g., “6-Nov”) Navigating Excel more fluidly with keyboard keys Lookups SumIf and CountIf Sorting and filtering (also by color) If/Then statements Text to … Continue reading Free Advanced Excel Download



