search3
    
    50544A - Learn Microsoft Excel 2010 Step by Step, Level 1

    QUICK

    INFORMATION

    course-duration

    1 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Training

    customize-batch

    Customize Your Batch

    one-o-one

    1:1 Training Available on Demand

    Course Information

    The Microsoft Excel 2010 Level 1 training is a one-day course that provides essential knowledge to students of the various features and functions of Microsoft Excel 2010.

    Completion of the course equips the participants with the following skill set:

    • Creating workbooks.
    • Zooming in on a worksheet.
    • Modifying workbook content.
    • Modifying worksheet content.
    • Arranging multiple workbook windows.
    • Adding buttons to the Quick Access Toolbar.
    • Maximizing usable space in the program window.
    • Correcting and expanding upon worksheet data.
    • Entering and revising data.
    • Customizing the ribbon.
    • Moving data within a workbook.
    • Finding and replacing data.
    • Formatting cells.
    • Adding images to worksheets.
    • Applying workbook themes and Excel table styles.
    • Adding headers and footers to printed pages.
    • Preparing worksheets for printing.
    • Printing worksheets.
    • Printing parts of worksheets.
    • Printing charts.

    COURSE OUTLINE

    Module 1: Set Up a Workbook

    In this module, participants will learn how to create a workbook, modify workbook and worksheet content, and save a modified workbook.

    Lessons

    • Create Workbooks
    • Modify Workbook Content
    • Modify Worksheet Content

    Lab:  Creating Workbooks
    Lab:  Modifying Workbook Content
    Lab:  Modifying Worksheet Content

    Module 2: Customize the Excel 2010 Program Window

    In this module, participants will learn how to change the Excel program window, including the user interface.

    Lessons

    • Zoom in on a Worksheet
    • Arrange Multiple Workbook Windows
    • Add Buttons to the Quick Access Toolbar
    • Customize the Ribbon
    • Maximize Usable Space in the Program Window

    Lab:  Maximizing Usable Space in the Program Window

    Module 3: Work with Data and Excel Tables

    This module explains how to use tools to enter and manage worksheet data effectively.

    Lessons

    • Enter and Revise Data
    • Move Data Within a Workbook
    • Find and Replace Data
    • Correct and Expand Upon Worksheet Data
    • Define Excel Tables

    Lab:  Entering and Revising Data
    Lab:  Moving Data Within a Workbook
    Lab:  Finding and Replacing Data
    Lab:  Correcting and Expanding Upon Worksheet Data
    Lab:  Defining Excel Tables

    Module 4: Apply Visual Effects

    This module explains how to change your data’s appearance.

    Lessons

    • Format Cells
    • Apply Workbook Themes and Excel Table Styles
    • Add Images to a Worksheet

    Lab:  Formatting Cells
    Lab:  Applying Workbook Themes and Excel Table Styles
    Lab:  Add Images to a Worksheets

    Module 5: Print Workbook Content

    This module explains worksheets configuration to convey the greatest possible amount of information.

    Lessons

    • Add Headers and Footers to Printed Pages
    • Prepare Worksheets for Printing
    • Print Worksheets
    • Print Parts of Worksheets
    • Print Charts

    Lab:  Adding Headers and Footers to Printed Pages
    Lab:  Preparing Worksheets for Printing
    Lab:  Printing Worksheets
    Lab:  Printing Parts of Worksheets
    Lab:  Printing Charts

    WHO SHOULD ATTEND

    This course is beneficial for information workers who want to learn beginner level Excel 2010 skills.

    Pre-requisites

    Before attending this course, candidates must have:

    • Basic computer knowledge.
    • Basic file management skills.
    • The candidate should have the knowledge to navigate to folders and files on a computer running Windows 7.

    Exam

    Name Code Fee

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.