Contact US

Login

    Overview

    Excel is a spreadsheet program from Microsoft, a component of its Office product group for business applications. In common with similar products, such as Lotus 1-2-3 and Corel’s QuattroPro, Excel is an automated version of the paper-based spreadsheet that makes it easier to manipulate, process, and view the data. Although Lotus 1-2-3 was reportedly the first spreadsheet to introduce cell names and macros, Excel implemented a graphical user interface and the ability to point and click using a mouse

    Excel Training Format:

    • Excel Online Training Instructor Led Online classes &Interactive sessions.
    • Certification of the course Completion.
    • Life Time Access to Excel training Online video tutorial.
    • Exercise after class
    • Course Completion Certification
    Empty tab. Edit page to add content here.
    1. Basics
    • Creating a New Workbook
    • Navigating in Excel
    • Moving the Cell Pointer
    • Using Excel Menus
    • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
    • Entering Values in a Worksheet and Selecting a Cell Range
    • Previewing and Printing a Worksheet
    • Getting Help from the Office Assistant
    • Saving a Workbook & Re-opening a saved workbook

    2. Worksheet Formatting

    • Creating Headers, Footers, and Page Numbers Adjusting Page Margins and Orientation
    • Adding Print Titles and Gridlines, rows to repeat at top of each page Formatting Fonts & Values
    • Adjusting Row Height and Column Width Changing Cell Alignment
    • Adding Borders
    • Applying Colours and Patterns Using the Format Painter Using AutoFormat
    • Merging Cells, Rotating Text, and using AutoFit Using AutoFill

    3. Workbook Management

    • Switching Between Sheets in a Workbook
    • Inserting and Deleting Worksheets
    • Renaming and Moving Worksheets
    • Protecting a Workbook
    • Hiding Columns, Rows and Sheets
    • Splitting and Freezing a Window
    • Inserting Page Breaks

    4. Editing a Workbook

    • Entering Date Values and using AutoComplete
    • Editing, Clearing, and Replacing Cell Contents
    • Cutting, Copying, and Pasting Cells
    • Moving and Copying Cells with Drag and Drop
    • Collecting and Pasting Multiple Items
    • Using the Paste Special Command
    • Inserting and Deleting Cells, Rows, and Columns
    • Using Undo, Redo, and Repeat
    • Checking Your Spelling
    • Finding and Replacing Information
    • Inserting Cell Comments

    5. Applying Formulas in Excel

    • Creating a basic Formula
    • Calculating Value Totals with AutoSum Editing & Copying Formulas
    • Fixing Errors in Your Formulas
    • Formulas with Several Operators and Cell Ranges

    6. Working With Forms Menu

    • Sorting, Subtotalling & Filtering Data
    • Copy & Paste Filtered Records
    • Using Data Validation

    7. Creating & Working with Charts

    • Creating a Chart
    • Moving and Resizing a Chart
    • Formatting and Editing Objects in a Chart Changing a Chart’s Source Data
    • Changing a Chart Type and Working with Pie Charts Adding Titles, Gridlines, and a Data Table Formatting a Data Series and Chart Axis Annotating a Chart
    • Working with 3-D Charts
    • Selecting and Saving a Custom Chart Using Fill Effects
    • Mapping Data Modifying a Map

    8. Data Analysis & Pivot Tables

    • Creating a PivotTable
    • Specifying the Data a PivotTable Analyzes
    • Changing a PivotTable’s Calculation
    • Selecting What Appears in a PivotTable
    • Grouping Dates in a PivotTable
    • Updating a PivotTable
    • Formatting and Charting a PivotTable
    • Different types of look ups in Excel.

    9. Automating Tasks with Macros

    • Recording a Macro
    • Playing a Macro and Assigning a Macro a Shortcut Key
    • Adding a Macro to a Toolbar
    • Simple VB Script Programs.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 10 Days
    51 STUDENTS ENROLLED

    Enroll For Demo Class






    Key Features

    Online Classes: hrs
    Project:

    Support:
    Lifetime Access:

    All Rights Reserved © Coursedroid