Intermediate Word Processing
- Working with Documents
-
- Fonts, Borders, Shadows and Shading
- Aligning Your Documents – Indents and Justification, Page Breaks
- Setting up the Documents – Professional Outlook
-
- Setting Margins
- Document Sections
- Paper size and orientation
- Document Styles
-
- Creating, Modifying
- Assigning and Viewing document styles
- Understanding Headers and Footers
-
- Inserting page
- Adding, Editing headers and footers
- Applying Symbols and Special Characters
-
- Definitions and Shortcut keys
- Inserting symbols and special characters
- Proof Reading Documents
-
- Spell checks and Grammar checks
- Using the Thesaurus
- Summary/Conclusion
Intermediate Excel
- Working with Ranges
-
- Definitions of ranges
- Cell ranges and Selecting a range
- Naming Convention
- Working with Cells
-
- Inserting & Removing cells
- Merging and Unmerging cells, Word Wraps in cells
- Calculations & Formulas
-
- Defining equations & Creating formulas
- Copying formulas, Relative and Absolute address
- Changing your calculations, Changing your settings
- Using auto-sum calculations
- Adding Notes to Cells
-
- How to add notes to the cells
- Copying/Removing the notes
- Formatting the Cells
-
- Changing cell attributes & fonts
- Text alignments, Adding borders to cells
- Shading the cells, Changing the column width, Changing the row height
- Printing Excel worksheet and workbook
- Summary/Conclusion
Introduction to Access Database
- The Access Database
-
- Definitions, data, records, files
- Roles of Database
- Creating Access Files
-
- Save, Close, Open and Exist Access database
- Designing Access Database
-
- Using the templates
- Design your own
- Using the templates wizards
- Querying the Database
-
- Setting the query criteria
- Sorting the data, Running query, Multiple query
- Summary/Conclusion
