Why Won’t the Track Changes Feature Work in Excel? Stop Excel from AutoCorrecting Certain Words Use Hyperlinks to Create an Opening Menu for a WorkbookĪrrange Windows to See Two or More Open Workbooks Have the Fill Handle Fill Your List of Part Numbers Why is the Scrollbar Slider Suddenly Tiny?Ĭopy the Characters from a Cell Instead of Copying an Entire CellĬopy Cells from One Worksheet to Many Other WorksheetsĮnter a Series of Months, Days, or More by Using the Fill Handle

How to See Headings and Row Labels as You Scroll Around a Report How to See Headings as You Scroll Around a Report Return to the First Column After Typing the Last Column Set up Excel Icons to Open a Specific File on StartupĬontrol Settings for Every New Workbook and WorksheetĪutomatically Move the Cell Pointer in a Direction After Entering a Number Have Excel Always Open Certain Workbook(s) My Manager Wants Me to Create a New Expense Report from ScratchĮxcel’s Obsession with Security Has Hampered Linked Workbooks Use a Trusted Location to Prevent Excel’s Constant Warnings Get Quick Access to Formatting Options Using the Mini Toolbar Increase the Number of Workbooks in the Recent Files List Why Does The File Menu Cover The Entire Screen? Use New Keyboard Shortcuts to Access the Ribbon The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough)

Use Dialog Launchers to Access the Excel 2003 DialogĪll Commands Start at the Top (Except for 2 Controls at the Bottom) Why Do The Charting Ribbon Tabs Keep Disappearing?

Use a Wheel Mouse to Scroll Through The Ribbon Tabs Minimize the Ribbon to Make Excel Feel a Bit More Like Excel 2003 What is Office 365? Do I have to Work in a Browser? If you use Excel 20-40 hours per week, you will save 50 hours a year with the tips in this book. Instead, turn to the topic on 'How to join two text columns'. You will never have to go hunting for 'Concatenation'. Some topics may offer additional details, alternate strategies, results, gotchas, and other elements, as appropriate to the topic. Each topic starts with a problem and then provides a strategy for solving the problem. This book offers 567 real-life business problems. How would you know to turn to the chapter on concatenation when you need to learn how to join a column of first names with a column of last names? No one at my dinner table ever uses the word 'concatenation' in dinner conversation. Many Excel books try to go in a serial fashion through every single Excel option. 'Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem.'.'Power Excel with MrExcel' - by Bill Jelen.

Videos on pivot tables in excel 2013