Microsoft Excel Training Classes in Houston Texas - Hands on Excel Classes in Houston Texas - (Houston)

Posted on: 11/07/17

Description

Microsoft Excel in Houston Training Classes in Houston Microsoft Excel Training Classes in Houton • Hands-on, instructor-led training classes • Step-by-step training manual with exercise link • Certificate of completion • Onsite Training available • Class can be customized to suit your needs • Private one-on-one classes are available Listed below are our standard Course Outlines. Each course is instructor led hands-on classroom-training using step-by-step student manual and exercises. Microsoft Excel in Houston - Training Classes in Houston, Texas Microsoft Excel in Houston: Level 1 Training Course Content Lesson 1: Getting Started with Microsoft Office Excel in Houston Topic A: Navigate the Excel User Interface Topic B: Use Excel Commands Topic C: Create and Save a Basic Workbook Topic D: Enter Cell Data Topic E: Use Excel Help Lesson 2: Performing Calculations Topic A: Create Worksheet Formulas Topic B: Insert Functions Topic C: Reuse Formulas Lesson 3: Modifying a Worksheet Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows Topic B: Search for and Replace Data Topic C: Use Proofing and Research Tools Lesson 4: Formatting a Worksheet Topic A: Modify Fonts Topic B: Add Borders and Colors to Worksheets Topic C: Apply Number Formats Topic D: Align Cell Contents Topic E: Apply Styles and Themes Topic F: Apply Basic Conditional Formatting Topic G: Create and Use Templates Lesson 5: Printing Workbooks Topic A: Preview and Print a Workbook Topic B: Define the Page Layout Lesson 6: Managing Workbooks Topic A: Manage Worksheets Topic B: Manage Workbook and Worksheet Views Topic C: Manage Workbook Properties Appendix A: Microsoft Office Excel in Houston Exam 77-420 Appendix B: Microsoft Office Excel in Houston Expert Exams 77–427 and 77-428 Appendix C: Microsoft Excel in Houston Common Keyboard Shortcuts Microsoft Excel in Houston: Level 2 Excel Training Course Content in Houston Lesson 1: Customizing the Excel Environment Topic A: Configure Excel Options Topic B: Customize the Ribbon and the Quick Access Toolbar Topic C: Enable Excel Add-Ins Lesson 2: Creating Advanced Formulas Topic A: Use Range Names in Formulas Topic B: Use Specialized Functions Topic C: Use Array Formulas Lesson 3: Analyzing Data with Functions and Conditional Formatting Topic A: Analyze Data by Using Text and Logical Functions Topic B: Apply Advanced Conditional Formatting Lesson 4: Organizing and Analyzing Datasets and Tables Topic A: Create and Modify Tables Topic B: Sort Data Topic C: Filter Data Topic D: Use SUBTOTAL and Database Functions Lesson 5: Visualizing Data with Basic Charts Topic A: Create Charts Topic B: Modify and Format Charts Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Slicers Appendix A: Microsoft Office Excel in Houston Exam 77-420 Appendix B: Microsoft Office Excel in Houston Expert Exams 77–427 and 77-428 Appendix C: Financial Functions Appendix D: Date and Time Functions Appendix E: Working with Graphical Objects Microsoft Excel in Houston: Level 3 Excel Training Course Content in Houston Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously Topic A: Use 3-D References Topic B: Use Links and External References Topic C: Consolidate Data Lesson 2: Sharing and Protecting Workbooks Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks Lesson 3: Automating Workbook Functionality Topic A: Apply Data Validation Topic B: Work with Forms and Controls Topic C: Work with Macros Lesson 4: Applying Conditional Logic Topic A: Use Lookup Functions Topic B: Combine Functions Topic C: Use Formulas and Functions to Apply Conditional Formatting Lesson 5: Auditing Worksheets Topic A: Trace Cells Topic B: Search for Invalid Data and Formulas with Errors Topic C: Watch and Evaluate Formulas Lesson 6: Using Automated Analysis Tools Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Activate and Use the Solver Tool Topic E: Analyze Data with Analysis ToolPak Tools Lesson 7: Presenting Your Data Visually Topic A: Use Advanced Chart Features Topic B: Create Sparklines Appendix A: Microsoft Office Excel in Houston Exam 77-420 Appendix B: Microsoft Office Excel in Houston Expert Exams 77–427 and 77-428 Appendix C: Cube Functions Appendix D: Import and Export Data Appendix E: Internationalize Workbooks Appendix F: Work with PowerPivot Microsoft Excel Tutor in Houston Microsoft Excel Trainer in Houston Microsoft Excel Teacher in Houston Microsoft Excel Classes in Houston Microsoft Excel Training in Houston Microsoft Excel Expert in Houston Microsoft Excel / Access VBA Expert in Houston Houston Microsoft Excel Tutor in Houston, TX Houston Microsoft Excel Instructor in Houston, TX Houston Microsoft Excel Weekend Classes in Houston, TX

Ad Number: 21056879