Microsoft Publisher Topics

One Day Course

1. Getting Started with Microsoft Publisher 2013
2. Topic A: Explore the Interface
3. Topic B: Customize the Publisher Interface
4. Topic C: Create a Publication
5. Adding Content to a Publication
6. Topic A: Add Text to a Publication
7. Topic B: Organize Text Boxes and Picture Placeholders in a Layout
8. Topic C: Control the Display of Content in Text Boxes
9. Topic D: Apply Building Blocks
10. Formatting Text in a Publication
11. Topic A: Format Text and Paragraphs
12. Topic B: Apply Paragraph Styles
13. Topic C: Apply Schemes
14. Editing Text in a Publication
15. Topic A: Edit Text in a Publication
16. Topic B: Present Content in Tables
17. Topic C: Insert Symbols and Special Characters
18. Adding and Formatting Graphics in a Publication
19. Topic A: Add Graphical Objects to a Publication
20. Topic B: Manipulate the Appearance of Pictures
21. Preparing a Publication for Sharing and Printing
22. Topic A: Save a Publication
23. Topic B: Run Design Checker
24. Topic C: Preview and Print a Publication
25. Topic D: Share a Publication

Microsoft OneNote Course

One Day Course

1. Exploring Notebook Structure
2. Navigate the OneNote 2013 Environment
3. Use Predesigned Templates for OneNote Notebooks
4. Customize the User Interface within OneNote
5. Adding Content and Formats to a OneNote Notebook
6. Modify Formatting in a Notebook
7. Add Audio and Video to a Notebook
8. Add Quick Notes and Links
9. Use Tags, Symbols, Drawing Tools, and Pen Options
10. Managing OneNote Notebooks, History, and Backups
11. Save and Export Content and Use Alternate File Types
12. Manage Notebook Recycle Bins and Backups
13. Working with Excel Spreadsheets and Embedded Files
14. Work with Excel Spreadsheets
15. Work with Embedded Files
16. Sharing and Collaborating with Notebooks
17. Send a Notebook and Use Outlook Integration
18. Share and Collaborate on Notebooks
19. Finalizing a Notebook
20. Finalize a Notebook Using Proofing and Print Settings
21. Configure Notebook Settings, Properties, and Security
22. Organize and Search Notebooks

Microsoft Office 365

1.  OFFICE 365 OVERVIEW
   
2. What is Office 365?
   
3. Services provided in Office 365
   
4. Connecting to the Services
   
5. Office 365 Integration
6. CONNECTING TO OFFICE 365
   
7. Logging In
   
8. Office 365 Portal Overview
   
9. Lync Options
10. WORK WITH THE OUTLOOK WEB APP
    
11. OWA Interface Overview
    
12. Email
    
13. Calendar
    
14. Themes and Rules
    
15. Contacts and Public Groups
    
16. Other Options
17. OFFICE 365 AND OUTLOOK 2010/2013
    
18. Outlook 2010 New Features
    
19. Use the GAL
    
20. Share Calendars
    
21. Schedule Meetings
22. USING LYNC
    
23. Set Options
    
24. Instant Messaging and Contacts
    
25. Online Meetings and Meeting Requests
    
26. Application and Information Sharing
    
27. Outlook Integration
28. USING SHAREPOINT
    
29. Team Site Overview
    
30. Explore and Navigate a Site
    
31. Use Document Libraries
    
32. Collaboration Tools
    
33. Outlook and Microsoft Office Integration
    
34. Use the Calendar
    
35. Publishing Tools
    
36. Working Offline
    
37. Searching
38. WORK WITH OFFICE WEB APPS
    
39. Create, View and Change Files
    

Power BI: Power Views

One Day Workshhop

1. Get started with Power View
2. Working with Data
3. Data sources for Power View
4. Import Data into Excel 2013, and Create a Data Model
5. Incorporate Internet Data, and Set Power View Report Defaults
6. Filter and highlight data
7. Slicers
8. Sorting   
9. Create charts and other visualizations
10. Create Map-based Power View Reports
11. Reporting – Create Amazing Power View Reports
12. Reports with multiple views in Power View in SharePoint
13. Share Power View reports
14. Share Power View in Excel
15. Share Power View in SharePoint reports (RDLX files)
16. Print Power View reports
17. Set Power View reporting properties in Power Pivot
18. Extend Data Model relationships using Excel 2013, Power Pivot, and DAX​

PowerPivot For Excel

One Day Workshhop

1. Explore the PowerPivot Application
2. Accessing the Power Pivot add-in
3. Navigating the interface
4. Working with Data
5. Import Data from Various Data Sources
6. Refresh Data from a Data Source
7. Manage Data Model
8. Create Relationships
9. Manipulating PowerPivot Data
10. Sort and Filter PowerPivot Data
11. Working with Tables
12. Create Linked Tables
13. Organize and Format Tables
14. Create Calculated Columns
15. Extract Data from Tables Using Functions
16. Create and Manage Table Relationships
17. Creating PowerPivot Reports
18. Using DAX Functions in PowerPivot
19. Manipulate PowerPivot Data Using DAX Function​
20.  Key Performance Indicators (KPI)

​

Microsoft Project Topics

Project Basic Course

1. Quick & Easy Overview of Managing with Project
2. Understanding Project Management Concepts
3. Application and Project Windows
4. Creating and Saving Project
5. Opening and Closing Projects
6. Creating a New Project & prepare it for data entry
7. Enter project tasks
8. Sequence the tasks
9. Define Resources
10. Estimate task duration and assign resources
11. Baseline the project
12. Track the project
13. Creating a Project Plan
14. Project Information
15. Creating Task Lists
16. Editing Task Lists
17. Outlining Task Lists
18. Task Dependencies
19. Modifying Task Dependencies
20. Task Information
21. Project Resources
22. Resource Assignment Concepts
23. Assigning Resources
24. Working with Project Calendars
25. Working with Resource Calendars
26. Working with Task Calendars
27. Entering Project Costs
28. Page Setup Options
29. Previewing Views and Reports
30. Printing Project Information

Project Intermediate Course

1. Changing Scheduling Methods
2. Resource Assignment Concepts
3. Task Type Settings
4. Changing Task Types
5. Task Constraints
6. Identifying Factors Affecting Tasks
7. Defining the Critical Path
8. Formatting the Critical Path
9. Resolving Resource Conflicts
10. Preset Contours
11. Applying Preset Contours
12. Editing Resource Assignments
13. Resource Overallocations
14. Locating Resource Overallocations
15. Resolving Resource Overallocations
16. Saving the Baseline
17. Tracking Project Progress
18. Tracking Task Progress
19. Updating Tasks
20. Updating the Remaining Schedule
21. Comparing Baseline and Actual Data
22. Sorting, Filtering and Grouping
23. Sorting Views
24. Filtering Views
25. Grouping Tasks and Resources
26. Formatting the Project Environment
27. Formatting Views
28. Formatting the Gantt Chart

Project Advanced Course

1.  Tracking and Analyzing Project Data
   
2. Progress Lines
   
3. Earned Value Analysis
   
4. Custom Visual Reports
5. Managing Task Structures
   
6. Change a Task List
   
7. Create a Network Diagram
   
8. Manage the Critical Path
   
9. Use Lag and Lead
   
10. Analyze Earned Value
11. Generating Project Views
    
12. Use View Commands
    
13. Use Existing Views
    
14. Create Custom Views
    
15. Format and Share the Timeline View
16. Importing and Exporting Data
    
17. Importing and Exporting Files
    
18. Using Import/Export Maps
19. Working with Multiple Projects
    
20. Master Projects and Subprojects
    
21. Working with Multiple Projects
    
22. Linking Tasks Across Projects
23. Resource Pools
    
24. Resource Pools
    
25. Working with Resource Pools
26. Additional Features
    
27. Rollup Task Bars
    
28. Hyperlinks
    
29. Custom WBS Codes
    
30. Macros
31. Customizing Tables, Views, and Reports
    
32. Customizing Project Elements
    
33. Custom Tables
    
34. Custom Views
    
35. Customizing Reports
36. Working with Templates
    
37. Sample Templates
    
38. Custom Templates
    
39. The Organizer
    

Excel VBA

Visual Basic For Applications

1. Record A Simple Macro
2. Record a Macro
3. Run a Macro
4. Understand the VB Editor
5. Use the Menu Bar
6. Use the Standard Toolbar
7. Use the Project Explorer
8. Use the Properties Window
9. Understand the Code Window
10. Understand Code Window Options
11. Edit Code
12. Get Help
13. Use .CHM or .HLP Files
14. Close the Visual Basic Editor
15. Work with Objects
16. Understand the Object Browser
17. Understand Objects
18. Understand the Objects Hierarchy
19. Reference Objects
20. Understand Collections
21. Use the Editing Features
22. Use the Immediate Window
23. Use the Auto List
24. Use Auto Quick Info
25. Work with Variables
26. Understand Variables
27. Declare Variables
28. Understand Data Types
29. Store Values in Variables
30. Store Objects in Variables
31. Create Procedures and Functions
32. Understand Procedures
33. Use the Macro Recorder to Create Sub Procedures
34. Call Procedures from Procedures
35. Use Intrinsic Functions
36. Use Message Boxes
37. Use Input Boxes
38. Create Functions
39. Pass Arguments to a Function
40. Work with Conditional Statements
41. Understand Conditional Statements
42. Work with Decision Structures
43. Work with Loop Structures
44. Work with Forms and Controls
45. Understand UserForms
46. Use the Toolbox
47. Work with UserForm Properties
48. Events and Methods
49. Use the Properties Window
50. Understand Controls
51. Work with the Label Control
52. Work with the Text Box Control
53. Work with the Command Button Control
54. Work with the Combo Box Control
55. Work with the Frame Control
56. Work with the Option Button Controls
57. Add Functionality to Forms
58. Work with Control Appearance
59. Set the Tab Order
60. Populate a Control
61. Add Code to Controls
62. Launch Forms from Procedures
63. Use Pivot Tables
64. Understand PivotTables
65. Create PivotTables
66. PivotTable Arguments
67. Add Fields to PivotTables
68. Control Forms
69. Control PivotTables from a Form
70. Control a Form from a Custom Toolbar
71. Understand Debugging
72. Understand Errors
73. Debug Code
74. Debug Tools
75. Use the Locals Window
76. Use the Watch Window
77. Use Breakpoints
78. Create Add-in

Power BI: Power Map

One Day Workshhop

1. Getting Started with PowerMap
2. Importing Data from a website
3. Importing Data from a database
4. Importing Data from an excel file
5. Explore your data in a Power Map tour
6. Geocode your Power Map data
7. Move around in Power Map
8. Visualize your data in Power Map
9. Change the look of your Power Map
10. Create a custom map in Power Map
11. Add or move a scene in a Power Map tour
12. Filter data in a Power Map tour
13. Change Power Map time options
14. Export a Power Map tour as a video

Excel Pivot Tables Workshop

Excel Basic Course

1. Understanding Pivot Tables
2. Source data for Pivot Table reports
3. Creating Worksheet Lists
4. Using Names
5. Create A Name
6. Using a Name in a Formula
7. Creating Names for a Multiple Rows or Columns
8. Creating Names for a Value or Formula
9. Creating a Pivot Table
10. Pivot Table Field List
11. Pivot Table Tools
12. Rearranging the Pivot Table
13. Changing the Report Field Titles
14. Formatting Data Fields
15. Using the Report Filter
16. Displaying Filtered Fields on Separate Worksheets
17. Formatting the Pivot Table
18. Sorting Data
19. Removing Data
20. Refreshing Data
21. Using Formulas Functions
22. Create a Calculated Field
23. Add or remove subtotals in a Pivot Table report
24. Display Or Hide Details
25. Working with Multiple Data Ranges
26. Setting up the source data
27. Creating PivotCharts
28. Creating the Chart
29. Chart Tools
30. Using Pivot Table Data Outside The Pivot Table Report
31. Create relationships between data from different sources,
32. Creating a Pivot Table from a Database
33. Databases you can access
34. Using Microsoft Query
35. Microsoft Query Toolbar
36. Returning Data to Excel
37. Publishing an Excel Workbook
38. When to Use Excel Services 

​

Power BI: Power Query

One Day Workshhop

1. Power Query and When to Use It
2. Data Sources
3. Connect to a web data source
4. Connect to a spreadsheet
5. Connect to a database
6. Add a Wikipedia page data source
7. Organizing Data
8. Build repeatable processes to filter, clean, aggregate, and transform your data.
9. Shape data in the subject table
10. Remove Other Columns to only display columns of interest
11. Replace Values to clean up values in a selected column
12. Filter values in a column
13. Queries
14. Name a query
15. Load the query to a worksheet
16. Share queries and their data with other users in your organization.
17. Common Problems Solved

​

Creating a Blinking Christmas Tree in Excel

A Presentation by: Nabil W. Mourad

Inserting a Table of Contents 

in Microsoft Word

An Advanced Excel Tutorial

By : Nabil W. Mourad

Alphabetic Shortcut keys

For Microsoft Word

Microsoft Outlook Topics

Outlook  Basic Course

1. Getting Started
2. Outlook Interface: Panes & Folders
3. Outlook Today: Keep track of your schedule &Tasks for today- Customize
4. Getting Help
5. E-mail
6. Reading mail Messages: Inbox Preview & read messages- E-mail Icons
7. Creating and Sending E-mail messages- Automation Features
8. Working with messages: Reply, forward, delete & restore messages
9. Attachments: open, read, forward, save
10. E-mail Management
11. Message options: Sensitivity, Imp., delivery, receipt & Flagging
12. Junk e-mail: blocked & Safe senders
13. Search Folders: Create & Use
14. Printing Messages: Set Up options
15. Contact Management
16. Working with contacts: Add, modify, attach items & organize
17. Electronic business cards
18. Contact Groups: create & modify groups- Contact Views
19. The People Pane: To view contact details - OSC
20. Tasks
21. Working with tasks: create, edit, delete- Single & Recurring
22. Categorize & view tasks – Convert mail to task
23. Managing Tasks: assign, accept & decline, send Status report
24. Appointment and Events
25. Creating and sending Appointments: single & recurrent
26. Modifying appointments: modify, delete & restore
27. Events: one time & recurring
28. Calendar Views: Add Holidays & time zones

Outlook Intermediate Course

1. Meeting Requests and responses
2. Meetings: create and send meeting requests- accept, decline & propose
3. Managing meetings; reserve resources, update & cancel meetings.Customizing Outlook
   
4. Customize the Ribbon & QAT
5. Quick Steps
6. The Navigation Pane
7. Address Books
8. Customizing Messages
9. Message Appearance
10. Creating & using signatures
11. Voting Buttons
12. Out of Office Messages
13. Organizing Items
14. Searching
15. Using Filters
16. Categorizing Items
17. Working with Folders
18. Automating Tasks
19. Managing Stationery
20. Organizing Mail
21. Organizing the Inbox folder
22. Setting Rules

Outlook Advanced Course

1.  Explore the User Interface
2. Backstage View
3. Ribbon Overview
4. Mini Toolbar
5. Status Bar
6. Shortcut Key Tips
7. Contextual Tabs
8. Advanced Organizational Tools
9. Create, Delete, Rename and Manage Outlook Folders
10. Move Messages to Folders         
11. Use and Create Quick Steps          
12. Use the Rules and Alerts Wizard 
13. Create an Out of Office Message
14. Configure Junk Email Options
15. Create, Customize and Use Search Folders
16. Use Instant Search
17. Advanced Email Features
18. Use the Format Text Ribbon
19. Use the Insert Ribbon
20. Set Mail Advanced Mail Options
21. Create and Use a Signature        
22. Recall and Delay Messages
23. Use Voting Buttons                       
24. Conversation View
25. Clean Up Conversations
26. Advanced Contact Features
27. Use People Pane
28. Set-up and Use the Social Connector
29. Customize Business Cards           
30. Assign a Task to a Contact
31. Map the Geographical Location of a Contact
32. Forward a Contact
33. Sort and Filter Contacts
34. Set Contact Options
35. Use Contacts for a Mail Merge
36. Link Items to a Contact
37. Advanced Calendar Options
38. Customize the Calendar Screen
39. Add Holidays and Time Zones
40. Use and Customize Categories
41. Create a Recurring Appointment
42. Use the Schedule View
43. Schedule and Request Meetings
44. Use Calendar Overlay
45. Create Calendar Groups
46. Share a Calendar
47. Advanced Task Options
48. Assign Tasks
49. Track Assigned Tasks                        
50. Request a Status Report for Tasks
51. Data Management
52. Use Archive Folders
53. Manual and Auto Archive 
54. Import and Export Information      
55. Set Outlook Options
56. Use RSS Feeds 
57. Use Outlook Forms
58. Create a User Template / Stationery
59. Create a Custom Form
60. Track Journal Entries and Contact Activities
    

Microsoft Word Topics

Word Basic Course

1. Introduction to Microsoft office applications
   
2. Explore the user interface
3. What is word? (family)
4. Backstage view / office button (2007)
5. Ribbon overview
6. Mini toolbar
7. Status bar
8. Shortcut key tips
9. Contextual tabs
10. Create, open and save documents
11. What is word? (function)
12. How to create your first word document?
13. Create a new blank document
14. Create a document from a template
15. Open word files
16. Getting help
17. Save documents
18. Add, select, navigate and delete text
19. Viewing documents in different ways
20. Format text and paragraphs
21. Use the home ribbon to format font and paragraphs
22. Format with the mini-toolbar
23. Font and paragraph dialog boxes
24. Use the format painter
25. Use the quick style gallery
26. Use basic bullets and numbering
27. Add borders and shading
28. Using cut, copy, paste
29. Use the office clipboard
30. Set tabs and use the ruler
31. Undo/redo
32. Find, replace and go to
33. Check spelling and grammar:
34. Proofing, thesaurus and translate
35. Navigate a long document (part 2)
36. Printing and viewing your document
37. Use the page set-up group and dialog box
38. Print preview and print options (2007)
39. Customize
40. Customize the quick access toolbar
41. Show/hide the ribbon

Word Intermediate Course

1. Explore the user interface
   
2. Working with styles
3. Create a style from text
4. Use the styles pane
5. Modify and delete styles
6. Use the style inspector
7. Use reveal formatting
8. Manage styles
9. Use and modify themes
10. Create a template
11. Modify a template
12. Attach a template to a document
13. Bullets and numbering
14. Custom bullets and numbering
15. Create a multi-level list
16. Restart or continue numbering
17. Advanced page formatting
18. Use columns
19. Insert page breaks, column breaks, section breaks and line breaks
20. Set break options
21. Add quick parts and use building blocks
22. Create a blank page and a cover page
23. Add page colours, watermarks, borders and horizontal lines
24. Add headers and footers
25. Add hyperlinks
26. Edit/ Remove hyperlinks
27. Use hyphenation and word count
28. Use research, language and translation tools
29. Use and customize autocorrect
30. Insert the date and time
31. Insert symbols and special characters
32. Use the mail merge wizard
33. Use the mailings ribbon
34. Create envelopes and labels
35. Email a document
36. Working with graphics
37. Add pictures and clipart
38. Format and modify images
39. Add and format word art
40. Add and format AutoShapes
41. Add and format text boxes
42. Align, distribute, group and order graphics
43. Add and format SmartArt
44. Insert a table
45. Table selection options
46. Format a table
47. Modify table structure
48. Draw a table
49. Use table options dialog boxes
50. Convert text to table
51. Sort a table
52. Use and insert equations
53. Insert a chart
54. Format a chart
55. Modify chart options
56. Embed and link excel tables and charts

Word Advanced Course

1. Work with forms
2. Work with webpages
3. What is a Macro
4. Set macro security
5. Record a macro
6. Assign a macro to a keystroke or quick access toolbar
7. Reviewing documents
8. Add, edit, navigate and delete comments
9. Track and review changes
10. Track changes options
11. Inspect the document
12. Prepare for sharing
13. Compare and combine documents
14. Protect documents
15. Create and modify outlines
16. Create a table of contents from heading styles
17. Create a table of contents from an outline
18. format, modify and update a TOC
19. Add footnotes and endnotes
20. Use bookmarks - use cross references
21. Create a bibliography
22. Manage bibliography sources and choose styles
23. Add captions and create a table of figures
24. Mark entries and create an index
25. Update and modify an index
26. Create and update a table of authorities
27. Create a master document
28. Create and work with sub documents
29. XML and word
30. What is XML and why is it used?
31. Use the XML structure pane
32. Tag a document
33. Apply an XML schema

Microsoft Access Topics

Access Basic Course

1. What is Access?  What is a Database?
2. What are Related Tables?
3. Database Concept
4. Getting Started Screen
5. Opening a database & Exploring Environment (blank- Template- Existing)
6. Differences from Excel- Similarities with PowerPoint
7. Getting Help
8. How to plan a database?
9. Explore tables in datasheet & design views
10. Creating tables in Datasheet view
11. Creating tables in design View
12. Changing The Design Of A Table
13. Effective & Ineffective field names
14. Deleting, inserting & Moving Fields
15. Attachment Data Type
16. Add a Total row.
17. Finding And Editing Records
18. Sorting records
19. Filtering a table
20. Setting Field Properties
21. Working With Input Masks
22. Setting Validation Rules
23. What is a query?
24. Create Queries using a Wizard
25. Creating And Using in Design view
26. Modifying Query Results And Queries
27. Performing Operations In Queries
28. What is a form
29. Form Views
30. Creating Forms by using form Button
31. Creating Forms by using the Wizard
32. Using Design View to create a form
33. Sorting And Filtering Records in a form
34. What is a Report?
35. Different views of a Report
36. Change default view
37. How to create a report by using the wizard
38. Create a Report in Design view
39. 7 Sections of a report- Properties
40. Grouping feature in Reports
41. Modifying and printing reports

Access Intermediate Course

1. What is a well-structured table (Normalized)? Table Analyzer
2. Object Dependency (Condition)
3. Importance of Table Relationships- Types - How To- Printing Relationships
4. Enforcing Referential Integrity- Cascading Deletes & Updates.
5. Database Normalization
6. How to Relate Tables
7. Implementing Referential Integrity
8. What is lookup field? Types
9. How to add a Multivalued field
10. How to create a Lookup Field
11. Modify lookup field properties (Value list Combo box- Edit list column)
12. Use a Subdatasheet
13. Create outer join, inner join, and self-join queries
14. Types of Queries- Unmatched Q- Find Duplicates Q
15. Create calculated fields in a query - Rule - Expression Builder
16. View summarized and grouped data from tables by using queries
17. Joining Fields Using the Expression Builder
18. Joining Tables In Queries
19. How to create a Form? Types of controls
20. Use controls to add graphics
21. Arranging, Aligning & Formatting Controls
22. Bind a control to a calculated field
23. Create a Calculated Control
24. Add a combo box (= lookup field)
25. Conditional Formatting in a form
26. Create advanced form types (Multiple Value- Split-Datasheet-  Subform)
27. Adding Unbound Controls & Topic B: Adding Graphics
28. Adding Calculated Values
29. Adding Combo Boxes
30. Creating Advanced Form Types
31. Customize headers and footers in a report
    
32. Show report sections.
33. Set properties for grouping data, and modify the appearance of a report
34. Add calculated values in a report by using functions
35. Print database objects and a report of database design
36. Create labels report
37. Create and modify a chart in a form
38. Create and modify a chart in a report

Access Advanced Course

1. What is Querying with SQL
2. Writing SQL statement
3. Adding Field Aliases
4. Displaying Matching data from related tables
5. Displaying Unmatched Records
6. Create SQL Query in SQL view
7. Context Sensitive Help
8. Attaching SQL queries to control
9. Creating Advanced queries
10. Creating Crosstab queries
11. The Crosstab query wizard
12. Create Parameter Queries
13. Wild Cards in Parameter queries
14. Using Action Queries
15. Creating an Append Queries:
16. Creating a Delete Queries:
17. Creating an Update query
18. Creating a Make Table queries
19. Create and run macros to automate tasks.
20. What is a Macro?
21. Modifying macros
22. Attach macros to events of database objects.
23. Creating Advanced Macros
24. Create Data Validation & Data entry Macro
25. Create Macros that run a parameter query.
26. Create AutoKeys and AutoExec macros.
27. Create macros to import and export database objects.
28. Importing, Exporting & Linking
    
29. Importing Objects
30. Exporting Objects
31. Working with XML documents
32. Exporting & Importing XML documents
33. Exporting with an XSL File
34. Save an Access Object as an XPS file
35. Saving a table as an XPS file
36. Linking Access Objects
37. Linking to an Access table
38. Using the Linked Table Manager:
39. Creating Links to Excel
40. Linking to an Excel workbook
41. Using Hyperlinks Fields
42. Database Management
43. Optimizing Resources
44. Converting databases to earlier version
45. Analyzing database performance
46. Splitting databases
47. Compacting & repairing databases:
48. Backing up the database
49. Protecting Databases
50. Setting Options and properties

Microsoft PowerPoint Topics

 PowerPoint Basic Course

1. What is PowerPoint?
2. Open Sample Files
3. PowerPoint Interface
4. Adding Buttons to QAT
5. Customizing the Ribbon
6. Open (New-Ex- Temp)
7. Saving a Presentation
8. Viewing a Slide Show
9. Add and delete Slides
10. Slides Layout
11. Using the Views buttons
12. Dividing a presentation into Sections.
13. Create  Presentation from Outline
14. Reuse Slides.
15. Adding text to Placeholders
16. Using Text Boxes.
17. Cut, Copy & Paste
18. AutoCorrect & AutoFit features
19. Using the Find feature
20. Replace text
21. Replace Fonts
22.  Spell check and Proofing
23. Using Themes
24. Adding Backgrounds
25. Text Alignment
26. Bullets and Numbering
27. Bullet Format
28. Using Pictures and Clipart
29. Dealing with Shapes
30. Inserting a WordArt
31. Create a Diagram
32. Smart Art from Bullets
33. Add Pictures to Smart Art
34. Using simple Animations
35.  Customize Animations
36. Using Slide Transition.
37. Printing slides
38. Printing Options

 PowerPoint Advanced Course

1. Insert Photo Album
2. Insert & Modify Tables
3. Drawing Tables
4. Inserting Excel Worksheet
5. Creating Charts
6. Create & Edit Hyperlinks
7. Using Action Buttons
8. Using Multiple Animations
9. Create a Motion Path
10. Synchronize Animations
11. Insert Movies
12. Editing movies
13. Adding Bookmark to a video file
14. Insert Sounds
15. Editing Audio files
16. Record Narration
17. Modify Slide Master
18. Create Custom Layout
19. Create a Custom Show
20. Setup Show Options
21. Rehearse Slide Timings
22. Broadcast a Slide Show
23. Insert & Edit Comments
24. Accept & Reject changes
25. Compare & Combine Shows
26. PowerPoint Options
27. Speaker Notes & Handouts
28. Finalizing Presentations
29. Delivering Presentations
30. Preparing For Travel
31. Saving As Video
32. Inserting Symbols & Equations
33. Saving in other Formats
34. Sending Directly from PPT

.

Course Outline

Microsoft Excel Topics

Excel Basic Course

1. What is Excel?
2. Open Excel Sample Files
3. Excel Interface
4. Adding Buttons to QAT
5. Customizing the Ribbon
6. Open Workbook (New-Existing- Temp)
7. Saving a workbook
8. Data Selection & Navigation
9. Split & Freeze
10. Enter, Edit & Delete data
11. Find, Replace, Proofing
12. Copy, Cut & Paste
13. Formatting (FANS)
14. Styles & Themes
15. Conditional Formatting
16. Basic Formulas
17. Basic Charting
18. Printing: Page Layout - Header
19. Page Break Preview
20. Getting Help with Excel

Excel Intermediate Course

1. What is a Formula?
2. Basic Formulas
3. Order of Operation
4. Relative & Absolute Reference
5. Basic & Intermediate Functions
6. Formula Auditing
7. Naming
8. Sort & Custom Lists
9. Filtering Data
10. Data Validation
11. Lists & Tables
12. Structured Reference
13. Illustrations - Smart Art
14. File Properties & Info Panel
15. Hiding Workbooks
16. Advanced Customization
17. Protecting Sheets
18. Protecting Workbook
19. Hiding Formulas
20. Custom Views

Excel Advanced Course

1. Summarizing data using Outline
2. Summarizing data using Subtotal
3. Combining data using Consolidation
4. Pivot Tables
5. Pivot Charts
6. Advanced Pivot Tables
7. Filtering Pivot Tables
8. Sparklines
9. Create Scenarios
10. Using Goal Seek
11. Variable Data Tables
12. Using the Solver
13. Linking & Embedding
14. Getting External Data
15. Sharing - Tracking Changes
16. Combining Worksheets
17. Creating Macros
18. Advanced Macros
19. Creating Forms
20. Assign a Macro To a Control

Our Courses

What are you looking for?

Do you need an Excel, Power Pivot, Data Modeling or VBA training?

Do you need a OneNote, Project or PowerPoint training?

Are you Converting to Office 2013  or Office 2016?
or wish to enrich your knowledge in Access, Outlook or Word courses?

We have them all... Each application is offered in three levels (Basic, Intermediate and Advanced). You can explore our "List of Topics" for the course outline of each level to select what is more suitable to you. if you are already familiar with the application, no need to start from the Basic level, you can step into Intermediate or Advanced directly.

If you know the topics that you want to learn, we can customize the course outline to meet your needs...In all cases your learning goals will be achieved.

The Official Partner of Big Dreams

Private Tutoring

With our highly effective onsite computer training courses we will improve the overall productivity of your staff.Read more

Corporate Training

Authorized Testing Center

Recruitment Test Preparation

Copyright © The Office Instructor

  Call Now: 647 290 0644