When selecting text (or cells in Excel), Microsoft includes a Mini toolbar giving you many common formatting options, so you do not have to constantly navigate to the Home ribbon or remember shortcut keys. The options shown on the Mini toolbar will vary, depending upon what you have selected. This option is available in Excel, One Note, Outlook, PowerPoint and Word. It cannot be customized. Examples of the Mini Toolbar within Word –
To activate, select the text you want to format, and the Mini toolbar will appear. You can also right click anywhere to activate it.
NOTE: If you do not see the Mini Toolbar, it may be turned off.
To Turn On/Off the Mini Toolbar
Click the File Tab, select Options, then click the General button. (OR Select (ALT F, T and click the General button.)
Navigate to the User Interface options section and checkShow Mini Toolbar on selection to turn on the option or uncheck to turn off the option.
Excel has a great feature for importing data directly into your Excel worksheet. You can import data from files (Excel, CSV, HTML), databases (Access, SQL), tables, Web, ODBC, etc., making it quicker and easier to share information. Below are the step by step instructions for using the Get Data feature in Excel 2016. Continue reading “Using the Get Data Feature in Excel 2016”
Learn how to utilize the Excel Printing Options to customize your printing.
Excel gives you a vast amount of options for printing spreadsheets, worksheets and specific print areas. For example, you can set repeating rows for each page printed or even set a specific area within a worksheet to print. NOTE: Prior to printing, it is a good idea to preview the worksheet to make sure it’s going to look the way you want it to. Below are the step by step instructions for Excel Printing. Continue reading “Excel Printing Options”
Learn how to use the AutoCorrect Options for the Office programs — Excel, OneNote, Outlook, PowerPoint and Word.
The AutoCorrect options allow you to correct misspellings, typos, capitalization errors, add symbols and ignore specified words. The autocorrect options are available in Excel, OneNote, Outlook, PowerPoint and Word. Below are the step by step instructions for setting and using the autocorrect options. NOTE: The steps are the same for all listed programs unless noted differently.Continue reading “AutoCorrect Options”
Learn how to utilize Excel AutoFill to quickly fill in cells where the data follows a pattern.
The Excel AutoFill feature allows you to quickly fill in cells where the data follows a pattern. You begin by typing in the pattern in a few cells and let Excel complete the list. Below are the step by step instructions for using AutoFill to enter Data and utilize its options. I’ve also include some AutoFill examples. Continue reading “Excel AutoFill”
Learn how to edit the Custom Dictionary within the Office Products.
The spell check feature compares the words within your documents with the words within the main Office dictionary. This dictionary contains most of common words but it may not contain some proper names, technical terms, acronyms and capitalizations. To combat this issue, you can add words and capitalizations to a custom dictionary to prevent the spell check feature from flagging them as misspelled. The custom dictionary applies to Office 2016 – Word, Excel, Outlook and PowerPoint, however the steps may differ slightly. Below are the step by step instructions for editing a Custom Dictionary in Word. Continue reading “Custom Dictionary”
Learn how to set the various Word Save Options. The skills learned here can also be utilized in Excel and PowerPoint.
The Word Options dialog box is where you can add and change Word settings used within your documents, set your personal information (metadata) stored with the document and any preferences you wish to set. The Word Save Options specifically work with the variables used when saving your documents, such as the format to use when saving, how often to save AutoRecover, AutoRecover file locations, Default local file location, etc. Similar Save Options are available in Excel and PowerPoint as well.
Learn about Excel Custom Lists — 1) Creating Custom Lists using the Options Feature; 2) Creating Custom Lists Using a Range of Cells; 3) Deleting Custom Lists; 4) Using Custom Lists within Spreadsheets
Excel custom lists can be used to fill or sort data within the defined order. By default, Excel provides s few built-in lists – Day of the Week and Day of the Month. You can also create your own custom lists.
A formula can contain any or all the following – functions, references, operators, and constants. Constants are values that are not calculated as they always remain the same. Below are the step by step instructions for using various Excel Formulas and Functions Features. Continue reading “Excel Formulas and Functions”
Learn how to Utilize the Excel Watch Window to monitor changes within cells on large worksheets.
When working with a large worksheet or a collection of related worksheets, the data may frequently change. The Excel Watch window allows you to save time by monitoring the results of selected cells in a separate window. Below are the step by step instructions for utilizing the Excel Watch Window. Continue reading “Utilizing the Excel Watch Window”