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!