CERTIFICATES

This module explores launching Excel, Microsoft Excel Startup Screen, Customizing the Excel Quick Access Toolbar, More on the Excel Interface, Understanding the Structure of an Excel Workbook, Saving an Excel Document, Opening an Existing Excel Document, Common Excel Shortcut Keys.

This module comes with Entering Text to Create Spreadsheet Titles, Working with Numeric Data in Excel, Entering Date Values in Excel, Working with Cell References, Creating Basic Formulas in Excel and Relative Versus Absolute Cell References in Formulas

This module provides knowledge about Working with the SUM() Function, Working with the MIN() and MAX() Functions, Working with the AVERAGE() Function, Working with the COUNT() Function, Adjacent Cells Error in Excel Calculations, Using the AutoSum Command, Excel's AutoSum Shortcut Key and Using the AutoFill Command to Copy Formulas.

This module covers moving and copying Data in an Excel Worksheet, Inserting and Deleting Rows and Columns, Changing the Width and Height of Cells, Hiding and Unhiding Excel Rows and Columns, Renaming an Excel Worksheet, Deleting an Excel Worksheet and Moving and Copying an Excel Worksheet.

This module makes you familiar with Working with Font Formatting Commands, Changing the Background Color of a Cell, Adding Borders to Cells, Excel Cell Borders Continued, Formatting Data as Currency Values, Formatting Percentages, Using Excel's Format Painter, Creating Styles to Format Data, Merging and Centering Cells, Using Conditional Formatting and Editing Excel Conditional Formatting.

This module comes with Inserting Images, Inserting Excel Shapes and Formatting Excel Shapes.

This module provides with the necessary knowledge of Creating an Excel Column Chart, Working with the Excel Chart Ribbon, Adding and Modifying Data on an Excel Chart, Formatting an Excel Chart, Moving a Chart to another Worksheet and Working with Excel Pie Charts

This module explores the Sorting a List Using Single Level Sort, Sorting a List Using Multi-Level Sorts, Using Custom Sorts in an Excel List, Filter an Excel List Using the AutoFilter Tool, Creating Subtotals in a List, Format a List as a Table, Using Conditional Formatting to Find Duplicates and Removing Duplicates.

This module provides and overview of Excels Function: DSUM(), Excel DSUM Function Single Criteria Continued, Excel DSUM Function with OR Criteria, Excel DSUM Function with AND Criteria, Excel Function: DAVERAGE(), Excel Function: DCOUNT() and Excel Function: SUBTOTAL()

This module provides idea about creating an Excel Data Validation List, Excel Decimal Data Validation, Adding a Custom Excel Data Validation Error and Dynamic Formulas by Using Excel Data Validation Techniques

This module presents idea about the importing Data Into Microsoft Excel, Importing Data from Text Files, Importing Data from Microsoft Access, Import Data From Text Files into Excel,  Import Data From a Database into Excel, Microsoft Excel Legacy Import Options for New Excel Versions and Exporting Data to a Text File.

This module presents Creating an Excel PivotTable, Modifying Excel PivotTable Calculations, Formatting PivotTable Data, Modifying PivotTable Calculations, Drilling Down into PivotTable Data, Creating PivotCharts, Filtering PivotTable Data and Filtering with the Slicer Tool.

This module presents Using the Freeze Panes Tool, Grouping Data (Columns and/or Rows), Print Options for Large Sets of Data, Linking Worksheets (3D Formulas) and Consolidating Data from Multiple Worksheets

This module presents Working with Excel Name Ranges, Advantages and Disadvantages of Excel Name Ranges, Editing an Excel Name Range, Using Excel's IF() Function, Excel's IF() Function with a Name Range, Nesting Functions with Excel, Nesting Excels AND() Function within the IF() Function, Using Excel's COUNTIF() Function, Using Excel's SUMIF() Function and Using Excel's IFERROR() Function

This module covers Microsoft Excel VLOOKUP() Function, Microsoft Excel HLOOKUP() Function, Microsoft Excel INDEX() Function, Microsoft Excel MATCH() Function, Microsoft Excel INDEX() and MATCH() Function Combined, Microsoft Excel INDEX() and MATCH() Function Combined Continued and Creating a Dynamic HLOOKUP() with the MATCH() Function.

This module presents Understanding Excel Macros, Activating the Developer Tab in Excel, Editing a Macro with VBA and Creating Buttons to Run Macros.