Excel Practice Certification Exams.

PART 2: Excel Certification Exams. * 6 Practice Exams * Time 90minutes * 80 Questions Each * 480 Questions.

Ratings: 0.00 / 5.00




Description

The following are areas of subject comprised in these programmed Certification practice tests

1. Introduction to Excel spreadsheet

  • Understanding Workbooks and Worksheets

  • Moving around a Worksheet

  • Navigating with your keyboard, Navigating with your mouse

  • Using the Ribbon, Ribbon tabs, Contextual tabs, types of commands on the Ribbon, Accessing the Ribbon by using your keyboard, Using Shortcut Menus.

  • Customizing Your Quick Access Toolbar.

  • Working with Dialog Boxes, Navigating dialog boxes, tabbed dialog boxes.

  • Using Task Panes

  • Entering and Editing Worksheet Data .

2. Performing Basic Worksheet Operations.

3. Working with Excel Ranges and Tables.

4. Formatting Worksheets

5. Understanding Excel Files and Templates.

6. Printing Your Work

7. Customizing the Excel User Interface

8. Working with Formulas and Functions

9. Introducing Formulas and Functions.

10. Using Formulas for Common Mathematical Operations

11. Using Formulas to Manipulate Text

12. Using Formulas with Dates and Times.

13. Using Formulas for Conditional Analysis

14. Using Formulas for Matching and Lookups

15. Using Formulas for Financial Analysis

  1. Using Formulas for Statistical Analysis

  2. Using Formulas with Tables and Conditional Formatting.

  3. Understanding and Using Array Formulas

  4. Getting Started with Excel Charts

  5. Using Advanced Charting Techniques

  6. Creating Sparkline Graphics

  7. Visualizing with Custom Number Formats and Shapes.

  8. Importing and Cleaning Data

  9. Using Data Validation

  10. Creating and Using Worksheet Outlines

  11. Linking and Consolidating Worksheets

  12. Introducing PivotTables

  13. Analyzing Data with PivotTables


What You Will Learn!

  • Enable to Identify the different components of the Excel worksheet and its objectives.
  • Comprehensive understanding of Excel formulas & functions.
  • Creating a spreadsheet to tabulate and record numeric values and text
  • Quick usage of the short-cut keys.

Who Should Attend!

  • Students who want to build a solid understanding on the Basics foundation of Microsoft Excel Spreadsheet