Private Tutoring


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

Corporate Training



We provide one-on-one tutoring in All MS Office applications. Courses can be customized  to suit your needs. Read more

Authorized Testing Center

Remote Training Anywhere 

Copyright © The Office Instructor
  Call Now: 647 290 0644

Alphabetic Shortcut keys

For Microsoft Word


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, Power BI or VBA training?

Do you need a OneNote, Project, Visio or PowerPoint training?

Are you Switching to Office 2016  or Office 2019?
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.

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 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 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​

Creating a Blinking Christmas Tree in Excel

A Presentation by: Nabil W. Mourad

Inserting a Table of Contents 

in Microsoft Word

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

.


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 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

​

An Advanced Excel Tutorial

By : Nabil W. Mourad

Microsoft Office Specialist certification is the leading IT certification in the world.. Read more


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 

 

​

in the World

​We train your employees wherever you are on the globe.... In English, French or Arabic   Read more


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

The Official Partner of Big Dreams

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