Introduction to Excel

QAR 99


Excel is incredibly useful, enabling us to do anything from writing simple spreadsheets for reporting, to carrying out more complicated calculations and analytical techniques.
If you want to help your employees to upskill to take advantage of what Excel has to offer, these bite-sized courses have been developed to help everyone learn at their leisure. They can choose what they want to learn from mini videos that cover each subject individually.

Courses in Collection

    Introduction to Excel - Basic Navigation (Part 1)

    Introduction to Excel - Basic Navigation (Part 2)

    Introduction to Excel - Basic Navigation (Part 3)

    Introduction to Excel - Basic Formulas

    Introduction to Excel - Advanced Formulas

and More ...

Out of stock
Take Actions:
Enroll Now
    Course_Certificate

    Module 1 :Introduction to Excel - Basic Navigation (Part 1)

    Excel has to offer, these bite-sized courses have been developed to help everyone learn at their leisure. They can choose what they want to learn from mini videos that cover each subject individually.

    Topic's covered :
            How to create a new workbook, including an introduction to the screen layout and how to move around a spreadsheet easily

            Exploring cells and how to select, clear information, delete, and insert them

            Using multiple sheets to create workbooks, including naming and coloring tabs for convenience

            The basics of spreadsheets, including how to save, print, and format pages for printing

    Module 2 :Introduction to Excel - Basic Navigation (Part 2)
    Topic's covered :
            How to format cells to include numbers and/or text

            Basic formatting, including text alignment, and changing font and borders

            Editing column width and row height, moving cells, and copying and pasting

            Exploring themes, cell styles, and learning how to fill cells easily

    Module 3 :Introduction to Excel - Basic Navigation (Part 3)
    Topic's covered :
            Drag and drop, autofill, flash fill and autofill options

            The basics of format painting, headers, footers, and page numbers

            Using add-ins, templates, and page breaks

            Freezing rows and columns and removing duplicates

    Module 4 :Introduction to Excel - Basic Formulas
    Topic's covered :
            Using Functions and AutoSum

            What the Insert function does

            The Formula tab and how to use it

            Copying Formulas

            Absolute Cell References

            Entering Calculations

            Date & Time formulas

    Module 5 :Introduction to Excel - Advanced Formulas
    Topic's covered :
            Using the IF functions and how to Nest IF functions

            What IFERROR means (tidying N/A)

            Range Names as well as IF/AND/OR functions

            Concatenation

            Using the Proper function

            NOW and Choose functions

    Module 6 :Introduction to Excel - Data Visualization
    Topic's covered :
            Using Excel charting and how to edit charts

            Formatting, Labeling, and Filtering charts

            Saving your chart as a template

            Creating and using Sparklines

    Module 7 :Introduction to Excel - Pivot Tables
    Topic's covered :
            What Pivot Tables are and what their use is

            How to create Pivot Tables

            How to create Pivot Charts

    Module 8 :Introduction to Excel - VLOOKUP Function
    Topic's covered :
            What the VLOOKUP function is

           How to use the VLOOKUP function

            How to use the HLOOKUP function

    Module 9 :Introduction to Excel - Conditional Formatting
    Topic's covered :
            What Conditional Formatting is

            How to use Conditional Formatting

            Rule Management for Conditional Formatting

    Module 10 :Introduction to Excel - Data Tools
    Topic's covered :
            What Data Validation is

            How to use the What-If Analysis

            Using the Get Data function

            How to Group and Sort Data

            How Filtering works

    Module 11 :Introduction to Excel - Review & Comment
    Topic's covered :
            Using the Find and Replace functions

            Checking Spelling and using the Thesaurus

            Explaining how to Protect Sheets and Workbooks

            Comments: Adding, Editing, Deleting, and Displaying them
    Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday
    January,February,March,April,May,June,July,August,September,October,November,December
    Not enough items available. Only [max] left.
    Add to WishlistBrowse WishlistRemove Wishlist
    Shopping cart

    Your cart is empty.

    Return To Shop

    Add Order Note Edit Order Note
    Estimate Shipping
    Add A Coupon

    Estimate Shipping

    Add A Coupon

    Coupon code will work on checkout page

    Introduction to Excel

    QAR 99