Microsoft Excel Course Contents The contents of this course are as follows: Excel BasicsExcel IntermediateExcel Advance MICROSOFT BASIC EXCEL 1: Getting Started With Microsoft Office Excel 2016 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 2: Performing Calculations Topic A: Create Worksheet Formulas Topic B: Insert Functions Topic C: Reuse Formulas and Functions 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 4: Formatting a Worksheet Topic A: Apply Text Formats Topic B: Apply Number Formats Topic C: Align Cell Contents Topic D: Apply Styles and Themes Topic E: Apply Basic Conditional Formatting Topic F: Create and Use Templates 5: Printing Workbooks Topic A: Preview and Print a Workbook Topic B: Set Up the Page Layout Topic C: Configure Headers and Footers 6: Managing Workbooks Topic A: Manage Worksheets Topic B: Manage Workbook and Worksheet Views Topic C: Manage Workbook Properties MICROSOFT INTERMEDIATE EXCEL 1: Working With Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions 2: Working With Lists Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data 3: Analyzing Data Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting 4: Visualizing Data With Charts Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features 5: Analyzing Data With PivotTables and PivotCharts Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers MICROSOFT ADVANCED EXCEL 1: Working With Multiple Worksheets and Workbooks Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data 2: Using Lookup Formulas and Formula Auditing Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas 3: Sharing and Protecting Workbooks Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks 4: Automating Workbook Functionality Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros 5: Creating Sparklines and Mapping Data Topic A: Create Sparklines Topic B: Map Data 6: Forecasting Data Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecasting Data Trends
