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
    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