Function Compatibility in Excel – Instructions

Function Compatibility in Excel - Instructions: A picture of the “Compatibility” functions in Excel.
Function Compatibility in Excel: Overview             Function compatibility in Excel supports older functions that have been replaced by newer versions of those functions. In Excel, some older formula functions have been replaced with new versions. These replacements occur to increase their accuracy and to better reflect their purpose. These new, more accurate statistical functions have
Read more
No Comments

Goal Seek in Excel- Instructions and Video Lesson

Goal Seek in Excel- Instructions and Video Lesson: A picture of the “Goal Seek” dialog box in Excel.
Goal Seek in Excel: Overview             You can use Goal Seek in Excel when you know the result you want a formula to return, but do not know the value needed to create the desired result. Anytime you have a situation where you know the result that you need to obtain, but are unsure of
Read more
No Comments

Plan a Meeting in Outlook – Instructions and Video Lesson

Plan a Meeting in Outlook - Instructions and Video Lesson: A picture of a user selecting a meeting time using the AutoPick feature in Outlook.
Plan a Meeting in Outlook: Overview             You can plan a meeting in Outlook by sending invitations to attendees. These are called “Meeting Request” items. The recipients of your meeting request receive an email message in which they must click a button to show if they are attending. The response they send is then recorded
Read more
No Comments

Slide Masters in PowerPoint – Instructions

Slide Masters in PowerPoint - Instructions: A picture of a user adding a new slide master in PowerPoint.
Slide Masters in PowerPoint: Overview             You use slide masters In PowerPoint to set the default layout and appearance of presentation slides. When you add presentation slides and apply a slide layout, the slide is formatted according to the slide master’s specifications. Each slide master has several associated slide layouts. It is possible to also
Read more
No Comments

The Research Pane in OneNote – Instructions

The Research Pane in OneNote- Instructions: A picture of the Research Pane in OneNote.
The Research Pane in OneNote: Overview             The Research Pane in OneNote helps you quickly look up information. This pane helps you research a specific word or term. The Research Pane in OneNote can help you check spelling, find an alternate word, or just generally research a word.             To use the Research Pane in
Read more
No Comments

Create a Data Model from External Relational Data in Excel – Instructions

Create a Data Model from External Relational Data in Excel - Instructions: A picture of a user selecting the external relational data tables to add to the data model in an Excel workbook by using the “Select Table” dialog box.
Create a Data Model from External Relational Data in Excel: Overview             You can create a data model from external relational data in Excel. Data models in Excel let you store multiple tables of information. They can then be used a data source for PivotTables, PivotCharts, and Power View reports.             The choice to add
Read more
No Comments

Convert Handwriting to Text in OneNote – Instructions

Convert Handwriting to Text in OneNote - Instructions: A picture of a user converting handwriting to text in OneNote.
Convert Handwriting to Text in OneNote: Overview             The ability to convert handwriting to text in OneNote is one of the programs’ great features. When you convert handwriting into text in OneNote, the text looks as though it had been typed on a keyboard. This feature helps users who take handwritten notes make their notes
Read more
No Comments