| Microsoft Office (SA-103) | |
| Description: | |
| Introduces the students the Microsoft Office Package, Word Processing, Spread sheets and an introduction to database management by using Microsoft Access. | |
| You Will Learn: | |
| Word: - Using the Word Menus, Toolbars and Help - Creating a Word Document, Saving, Printing - Applying Fonts and Changing Text Size - Indenting Text, Numbered and Bulleted Lists - Margins, Tabs, Line Spacing and Alignment - Spelling, Grammar Checker, Thesaurus - Creating and Formatting Tables - Headers, Footers and Page Numbers - Creating, Applying and Modifying Styles - Creating and Using Templates - Sorting and Filtering Records in a Mail Merge - Drawing Two-and Three - Dimensional Objects Excel: - The Excel Screen, Menus, Toolbars And Help - Creating an Excel Document, Saving, Printing - Adjusting Column Width and Row Height - Inserting Rows and Columns - Aligning Text in Cells - Borders, Shading and Conditional Formats - Functions: Sum, Average, Max and Min - Rotating Text in Cells - Column and Pie Charts, Adding New Data - Creating a Database, Sorting, Filtering Records - Working with Multiple Worksheets and Workbooks - Using the IF and lookup Functions - Using Financial Functions: PMT and FV - Pivot Tables, Goal Seek, Histograms and Moving Average Access: - String Functions - Determining If Data Has Value - Declaring Variables in Modules and Procedures - Working with Visual Basic for Applications - Naming Variables - Database Design - Naming Standard Outlook: - Working with appointment - Date Navigator - Scheduling an appointment - Meeting planner - Responding to a reminder - Viewing & creating events - Adding and sorting a contact list - Using page setup options - Printing and defaults - Setting the time zone - And more! |
|