Basic to Advanced Excel Training In Dubai

Microsoft Excel Course Outline

• Using Multiple Worksheets and Workbooks
  a. Opening and switching between multiple workbooks
  b. Copying worksheets between workbooks
  c. Linking worksheets with 3-D formulas
  d. Syntax of 3-D formulas
  e. Inserting a 3-D reference
  f. Adding a Watch window
  g. Linking workbooks
  h. External links
  i. Maintaining workbook links
  j. Managing workbooks
•  Advanced Formatting
  a. Using Special Number Formats
  b. Creating Custom Formats
  c. Using Themes and Backgrounds
  d. Conditional Formatting
• Outlines and Subtotals
  a. Outlining and consolidating data
  b. Selecting a large range
  c. Creating custom views
  d. Switching among custom views
  e. Consolidating data
  f. Creating subtotals
  g. Multiple subtotal functions
• Tables
  a. Sorting and filtering data
  b. The structure of organized data
  c. Advanced filtering
  d. Custom AutoFilters
  e. Copying filtered results to another location
  f. Working with tables
  g. Creating tables
  h. Formatting tables
  i. Adding to a table
  j. Structured references
  k. The Total row
  l. Table names
• Analytical Tools
  a. Goal Seek and Solver
  b. What-if analysis
  c. The Solver utility
  d. Using Solver
  e. Scenario Manager
  f. Creating a scenario
  g. Switching among scenarios
  h. Merging scenarios
  i. The Scenario Summary report
•  Importing and Exporting
  a. Using the Save As command to export data
  b. Importing data
  c. Converting text to columns
  d. Removing duplicates
• Sharing Workbooks
  a. Using hyperlinks
  b. Inserting a hyperlink in a worksheet
  c. Sharing workbooks
  d. Using Save & Send
  e. Sending workbooks via e-mail
•  Templates
  a. Changing application settings
  b. The Excel Options dialog box
  c. Customizing the Ribbon
  d. Using built-in templates
  e. Using Excel templates
  f. Creating a workbook from a template
  g. Creating and managing templates
  h. Custom templates
  i. Modifying template