Wedemic

Microsoft Excel: Basic & Intermediate

A Training Course by VTeach.

0 STUDENTS ENROLLED

    In-House sessions are available upon request.

     

    Course Objective:

    Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will also be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

     

    Course Content:

    Getting Started with Excel

    Explore the user interface and the ribbon
    Navigate and select in Excel
    Obtain help
    Enter Data and Save a workbook

    Performing Calculation 

    Create Basic Formulas
    Calculate with function
    Commonly used Function
    Copy formula and function
    Auto fill

    Modifying a Worksheet 

    Inserting, Renaming, Deleting, Hiding Worksheet
    Inserting, Renaming, Deleting Rows and Columns
    Moving and copying Worksheet
    Moving and copying Data’s

    Formatting a Worksheet (Appearance of Worksheet)

    Modify Fonts
    Add borders and colors cells
    Change column width and row height
    Apply number formats
    Varying Decimal in Number Formats
    Cell Styles
    Find and Replace text and numbers on a worksheet

    Managing a Workbook 

    Inserting Header and Footer
    Freeze, split options
    Arrange the windows
    Using Sorting, Custom AutoFill Lists

    Printing Workbooks

    Printing Workbook
    Set Page break
    Print Area

    Calculating Data with Advanced Formulas

    Using Range Names
    Creating & Define Range Names
    Using Range Names in Formulas
    Consolidating data
    Using Text and Date Functions
    Using Logical Functions
    Using the Vlookup and Hlookup Functions

    Organizing Worksheet and Table Data

    Format Tables
    Modify Tables
    Create a Data List in Excel
    Learn more about filtering
    Common filter
    Clear a filter

    Presenting Data Using Charts

    Types of Charts
    Creating Charts and Modifying Charts

    Course Curriculum

    Microsoft Excel: Basic & Intermediate 14:00:00

    Course Reviews

    N.A

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

    No Reviews found for this course.

    TAKE THIS COURSE
    Clear
    • SGD 285
    • 2 days
    • ,
    • 1 Units
    • 840 Minutes
    • Wishlist

    Enrol With Confidence


    PayPal Acceptance Mark

    Registration Support

    If you require further assistance on registration matters, email to registration@wedemic.com

    In-House Enquiry

    Achieve higher ROI with your training budget with In-House trainings, email to inhouse@wedemic.com
    VTeach Pte Ltd is a Training Organisation providing high quality and interactive hands-on training delivered by an enviable team of qualified, expert and highly experienced trainers. VTeach has been established to address the training needs of both individuals and corporate companies. We believe good foundation is essential in today’s business world. As a committed training provider, we strive to deliver effective training programmes for a lifelong learning experience to enhance your productivity. We offer a wide variety of programs from Information Technology courses, Finance Courses to Business and Professional Development courses. We also provide in-house lunch time seminars such as Time Management, Stress Management, Motivational Talk, etc. We also have our own team of in-house course developers who liaise directly with our clients to develop training courses which meet their specific needs. Our Training - Regular scheduled public classes - Corporate Training that can be conducted in-house and at the comfort of your own location and time - Customized Training tailored to the organization’s needs and objective.
    More Courses by VTeach Pte Ltd