Category Archives: IT Training

Excel Essentials starting Excel what is a worksheet? what is a workbook? identifying parts of the screen identifying the ribbon components getting help using selection techniques selecting a range of cells selecting nonadjacent cells and ranges selecting an entire worksheet entering data entering text data into a cell entering values entering data into a range quickly adjusting a column width finishing a workbook saving a named workbook saving the workbook…

Read More »

     

Using Advanced Management Features managing items setting up AutoArchiving archiving Manually retrieving Archived Items creating and Applying Categories finding and Grouping Items creating and Clearing a Filter customizing Outlook setting Options adding Shortcuts to the Bar moving, Removing a Shortcut changing your Password Optimizing Mail Functions using Address Books working with Personal Distribution lists Using Message Features attaching a File opening, Closing, Saving an Attached file Accessing the Internet inserting…

Read More »

     

Outlook Essentials getting started exploring the Outlook window navigating in Outlook getting help obtaining context-sensitive help printing documents setting up the page selecting additional printing options previewing and printing a document ending an Outlook session minimizing and restoring Outlook viewing a day, week or month from Outlook and logging off assignment Communicating with Mail using the inbox checking for new messages previewing and opening messages the ribbon selecting and printing…

Read More »

     

Customising PowerPoint how to change the default format of the blank presentation how to change the Default Language how to change the Default Display options how to change the Default Spelling and Security Options how to change the Default Save and default Folder Options about the Quick Access Toolbar add-in Programs Working with Objects tables organisation charts inserting and deleting boxes creating charts how to insert an excel worksheet Drawing…

Read More »

     

PowerPoint Basics     starting PowerPoint opening an existing presentation identifying elements of the PowerPoint window the Ribbon moving between slides using PowerPoint help to use the help topics index changing the zoom level viewing the presentation in outline view viewing the presentation in slide sorter view ending a PowerPoint session closing a presentation Creating a Presentation beginning a new presentation using a template to begin a new presentation adding text and…

Read More »

     

Sorting and Merging Text and Data sorting merging protect document Working with Formulas, Worksheets and Charts calculating in tables using formulas using worksheets creating and modifying worksheets embedding existing Excel worksheets working with charts importing and copying data into a datasheet Introduction to Macros recording and running macros managing Macros deleting Macros   Enhancing Documents working with graphics modifying graphics positioning and deleting graphics using advanced enhancement techniques inserting special…

Read More »

     

Reviewing Documents correcting documents performing a spelling and grammar check using the thesaurus using autocorrect options setting and deleting AutoCorrect exceptions hyphenating documents inserting special hyphens using quick part building blocks creating and inserting quick part deleting quick part entries creating outlines typing outline lists assigning and removing paragraph outline levels using the navigation pane file search – to find a file insert a comment, and picture from a file…

Read More »

     

Creating & Editing Documents starting documents starting Word identifying components of the Word screen the Word 2010 ribbon creating and opening documents moving the insertion/cursor point building and editing documents selecting text replacing and deleting blocks of text moving and copying text modifying page breaks finishing documents previewing and closing a document     Formatting Text & Printing a Document enhancing text applying text formatting effects removing text formatting information…

Read More »

     

What’s new in Office 2013 Sign in for Office where you need it Save and share files in the cloud Shared meetings More choices for getting started Improved Open and Save As Easier file sharing New features in Excel 2013 Quick Analysis FlashFill Working with Charts PivotTables Use multiple tables to analyse data New features in PowerPoint 2013 Getting started choices Improved presenter tools Slide show view, Show taskbar One…

Read More »

     

Introduction Purchase Ledger Year 2000 Starting Sage Line 50 Passwords Change Password Log Off Access Rights Function Keys, Help Menu, Toolbars Moving Around Fields and Forms Record Selection Multiple Selection Finder Button Criteria The Information Button The Amounts Tab Reverse Selection (Swap) Clear Selection Accounting Areas (Modules) Date Sales Ledger Customers (Sales Ledger) Ledger Options Customer Details Account Memos Removing Unwanted Records Reports Day Books Statements New User Reports Receipts…

Read More »