Posts Tagged with “EXCEL CLASS IN HOUSTON”

 
 

Excel Expert in Houston, Texas

ACCESS TRAINER IN HOUSTON

MICROSOFT EXCEL EXPERT BASED IN HOUSTON

Would you like me to help you with your Excel or Access projects?

Whether it is  programming or teaching you or your entire staff I can help!

Very reasonable pricing and I will work within your budget, either at your office or in our classroom or I can work remotely, your choice!

 

 

Quick instant quote provided for your project – Simply tell us your needs in the form below

Please fill the form below for an instant response

* indicates required field

 

 

 

 

Microsoft Excel Expert in Houston, Texas

Lesson 1: Getting Started with Microsoft Office Excel Expert in Houston, Texas
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 Expert in Houston, Texas Exam 77-420
Appendix B: Microsoft Office Excel Expert in Houston, Texas Expert Exams 77–427 and 77-428
Appendix C: Microsoft Excel Expert in Houston, Texas Common Keyboard Shortcuts
Microsoft Excel Expert in Houston, Texas

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 Expert in Houston, Texas Exam 77-420
Appendix B: Microsoft Office Excel Expert in Houston, Texas 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 Expert in Houston, Texas

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 Expert in Houston, Texas Exam 77-420
Appendix B: Microsoft Office Excel Expert in Houston, Texas 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