Login for faster access to the best deals. Click here if you don't have an account.

Navigate the Excel User Interface Dashboard Training

3 weeks ago   Services   Islamabad   21 views
Location: Islamabad
Price: ₨ --

Beginners Course Modules

  • Module 1: Navigate the Excel User Interface
  • Module 2: Use Excel Commands
  • Module 3: Create and Save a Basic Workbook
  • Module 4: Enter Cell Data
  • Module 5: Use Excel Help
  • Module 6: Create Worksheet Formulas
  • Module 7: Insert Functions
  • Module 8: Reuse Formulas and Functions
  • Module 9: Insert, Delete, and Adjust Cells, Columns, and Rows
  • Module 10: Search for and Replace Data
  • Module 11: Use Proofing and Research Tools
  • Module 12: Apply Text Formats
  • Module 13: Apply Number Format
  • Module 14: Align Cell Contents
  • Module 15: Apply Styles and Themes
  • Module 16: Apply Basic Conditional Formatting
  • Module 17: Create and Use Templates
  • Module 18: Preview and Print a Workbook
  • Module 19: Set Up the Page Layout
  • Module 20: Configure Headers and Footers
  • Module 21: Manage Worksheets
  • Module 22: Manage Workbook and Worksheet Views
  • Module 23: Manage Workbook Properties

Intermediate Course Modules

  • Module 1: Work with Ranges
  • Module 2: Use Specialized Functions
  • Module 3: Work with Logical Functions
  • Module 4: Work with Date & Time Functions
  • Module 5: Work with Text Functions
  • Module 6: Sort Data
  • Module 7: Filter Data
  • Module 8: Query Data with Database Functions
  • Module 9: Outline and Subtotal Data
  • Module 10: Create and Modify Tables
  • Module 11: Apply Intermediate Conditional Formatting
  • Module 12: Apply Advanced Conditional Formatting
  • Module 13: Create Charts
  • Module 14: Modify and Format Charts
  • Module 15: Use Advanced Chart Features
  • Module 16: Create a PivotTable
  • Module 17: Analyze PivotTable Data
  • Module 18: Present Data with PivotCharts
  • Module 19: Filter Data by Using Timelines and Slicers

Advanced Course Modules

  • Module 1: Use Links and External References
  • Module 2: Use 3-D References
  • Module 3: Consolidate Data
  • Module 4: Use Lookup Functions
  • Module 5: Trace Cells
  • Module 6: Watch and Evaluate Formulas
  • Module 7: Collaborate on a Workbook
  • Module 8: Protect Worksheets and Workbooks
  • Module 9: Apply Data Validation
  • Module 10: Search for Invalid Data and Formulas with Errors
  • Module 11: Work with Macros
  • Module 12: Create Sparklines
  • Module 13: MapData
  • Module 14: Determine Potential Outcomes Using Data Tables
  • Module 15: Determine Potential Outcomes Using Scenarios
  • Module 16: Use the Goal Seek Feature
  • Module 17: Forecasting Data Trends

Whatsapp: , , O3O3553O 865 O321 96O67  85,

IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad


 
Home Cleaning
Home Cleaning