The Ultimate Excel Tutorial – This Table of Contents walks you through the Excel Environment. Taken from the fabulous book ‘Learn Excel from Mr Excel’ - written by Bill Jelen. It provides you with all those troubleshooting tips and tweaks, exploring Excel from top to bottom.
Table of Contents: Learn Excel from Mr Excel - 277 Excel Mysteries Solved
Are you new to Microsoft Excel? Or consider yourself an intermediate or expert user? Here you will find a wealth of walk through tutorials as found in the acclaimed book ‘Learn Excel with Mr. Excel’. Solving 277 mysteries and walking you through topics, this is a great step by step or standalone set of user guides for your entire Excel environment. Here are the topics as expertly laid out by author Bill Jelen.
The Excel Environment
- Show Full Menus All the Time…
- Show Full Toolbars All the Time…
- Add a Close Button to the Standard Toolbar…
- Close All Open Workbooks…
- Double the Value of the Recently Used File List…
- Remember Workbooks to Open Using a Workspace…
- Automatically Move the Cell Pointer in a Direction After Entering a Number…
- How to See Headings and Row Labels as You Scroll Around a Report…
- How to Print Titles at the Top of Each Page…
- Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page…
- How to Print Page Numbers at the Bottom of Each Page…
- How to Make a Wide Report Fit to One Page Wide by Many Pages Tall…
- Arrange Windows to See Two or More Open Workbooks…
- Why Is There a “:2” After My Workbook Name in the Title Bar?…
- Have Excel Always Open Certain Workbook(s)…
- Set up Excel Icons to Open a Specific File on Startup…
- Use a Macro to Further Customize Startup…
- Control Settings for Every New Workbook and Worksheet…
- Open a Copy of a Workbook…
- Open a Saved File Whose Name You Cannot Recall…
- Suppress the Update Links Message…
- Send Excel File as an Attachment…
- Save Excel Data as a Text File…
- Use a Laser Printer to Have Excel Calculate Faster…
- Use Excel as a Word Processor…
- Spellcheck a Region…
- Use Hyperlinks to Create an Opening Menu for Your Workbook…
- Get Quick Access to Paste Special…
- Use Shift Key to Reverse Popular Toolbar Icons…
- Create a Menu or a Toolbar of Your Favorite Icons…
- Restore Your Menus After Customizing…
- Quickly Copy a Formula to All Rows of Data…
- Quickly Turn a Range on Its Side…
- Stop Excel from AutoCorrecting Certain Words…
- Use AutoCorrect to Enable a Shortcut…
- Why Won’t the Track Changes Feature Work in Excel?…
- Copy Cells from One Worksheet to Many Worksheets…
- Have Excel Talk to You…
- Enter Special Symbols…
- Find Text Entries…
Part 1: The Excel Environment
Part 2: Calculating with Excel
Part 3: Wrangling Data
Part 4: Formatting Excel
