November 2, 2018
A clear understanding of the various components of the PowerPoint screen is essential to effectively use PowerPoint and to create engaging professional presentations efficiently.
November 2, 2018
From animations and video, through to organization charts and process flows, PowerPoint is your complete presentation graphics package providing everything you need for communicating information in an engaging and professional format. Gaining a solid foundation in planning your presentations and understanding PowerPoint’s powerful capabilities and features is essential to save […]
October 4, 2018
This course covers selected features in Microsoft Word relevant to office administration roles within organizations at intermediate level.
October 4, 2018
To let others know the status of a document you can select from several common watermarks in Word such as DRAFT and SAMPLE or design your own.
October 4, 2018
You can display, hide, re-order and rename tabs on the Ribbon showing frequently used commands and hiding the commands you rarely use.
October 4, 2018
Fields can provide precise control and display of dynamic text in a document and include examples such as Table of Contents, Date, Index and Mail Merge (MergeField).
October 4, 2018
For large documents such as books or complex reports you can divide components of a document, such as chapters, into sections then add a title or other text that is specific to each component into the header of that component.
October 4, 2018
Bookmarks can identify a specific word, section, or location in your document that you name and identify for future reference.
October 4, 2018
The Go To command in Word allows you to send the insertion pointer to locations in a document including for example, a specific page, section, line, bookmark, heading or object.
September 13, 2018
Both embedded charts and charts on a separate sheet can be copied and pasted into other applications such as Word and PowerPoint either with or without a link back the source chart in Excel. As Excel is a preferred application for charting and managing chart data, it is practical to […]
September 12, 2018
When working with formulas linking external workbooks, it is essential to understand key aspects associated with managing linked files.
September 12, 2018
Linking formulas can transfer a value to a new place in a different workbook.
September 10, 2018
Linking formulas can transfer a value to a new place in a different worksheet in the same workbook.
September 10, 2018
You can insert a hyperlink, as used on the internet, into a worksheet cell to instantly navigate to a cell or range of cells in another worksheet. Hyperlinks in Excel can also instantly switch to another file or web page.
September 10, 2018
You can import tables of data from Excel into Access to take advantage of the range of powerful data query and reporting capabilities available in Access.
September 10, 2018
You can link a chart title to the displayed content of a single cell on the same or another worksheet.
August 3, 2018
If your Data Model has date fields that are also used in a PivotTable you can create a timeline which can be used to interactively filter your displayed PivotTable data.
August 3, 2018
Slicers are a visual display mechanism in PowerPivots which allow you to interactively filter your PivotTable display using fields and data from your Data Model.
August 3, 2018
Fields imported into a Power Pivot Data Model appear with formatting that has been applied in the source location where that data was created.