Excel Practice Certification Exams.
PART 2: Excel Certification Exams. * 6 Practice Exams * Time 90minutes * 80 Questions Each * 480 Questions.
Ratings 0.00 / 5.00
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.
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
Using Formulas for Statistical Analysis
Using Formulas with Tables and Conditional Formatting.
Understanding and Using Array Formulas
Getting Started with Excel Charts
Using Advanced Charting Techniques
Creating Sparkline Graphics
Visualizing with Custom Number Formats and Shapes.
Importing and Cleaning Data
Using Data Validation
Creating and Using Worksheet Outlines
Linking and Consolidating Worksheets
Introducing PivotTables
Analyzing Data with PivotTables
Who Should Attend!
- Students who want to build a solid understanding on the Basics foundation of Microsoft Excel Spreadsheet