This event has ended

Microsoft Excel 2010 Fundamentals

ThinkData Solutions, Inc

Thursday, May 10, 2012 from 9:00 AM to 12:00 PM (CDT)

Birmingham, AL

Microsoft Excel 2010 Fundamentals

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Microsoft Excel 2010 Fundamentals 8 Tickets Ended $175.00 $0.00

Share Microsoft Excel 2010 Fundamentals

Event Details

Microsoft Excel 2010 - Fundamentals

 

Course Description

This course is designed for any person with a basic understanding of Microsoft Windows who needs to learn the basics of Microsoft Excel 2010.

 

Course Objectives:

Upon completion of this course, the student will be able to:

·        Recognize, use and navigate the ribbon

·        Recognize the cursors

·        Navigate the Excel user interface

·        Recognize and use the basic features of Excel

·        Create a worksheet and workbook

·        Perform calculations

·        Present data using charts

·        Print worksheets

Lesson 1 – Overview of the Ribbon

 

·        Work with Ribbon Sizes

·        Minimize the Ribbon

·        Tabs of the new ribbon in excel

·        File

·        Home

·        Insert

·        Page Layout

·        Formulas

·        Data

·        Review

·        View

·        Scroll the Ribbon with your Mouse

·        Customize the Ribbon with Quick Access Toolbar options

Lesson 2 – Know Your Cursors

 

·        Overview of All Cursors

·        The Selection Cursor

·        Drag & Drop

·        Autofill Cursor

·        Entire Column and Row Selection

Lesson 3 – Fundamentals on Working with Workbooks

 

·        Format cell appearance using alignment, fonts, colors, borders, and fills

·        Use undo and redo

·        Use find and replace

·        Move data around in a worksheet using cut-and-paste

·        Create a worksheet in excel

·        Use Autofit Commands

·        Control the view of the worksheet by zoom, hiding data, freezing rows and columns

Lesson 4 – Constructing Workbooks

 

·        Insert and Delete Cells

·        How to add insert columns in a worksheet

·        How to copy and move columns in a worksheet

·        How to add and move rows to a worksheet

·        Add comments to a cell

·        Hide and Unhide Worksheets

·        Name worksheets

·        Rearrange worksheets

·        Click and Drag method

·        Right Click Move or Copy method

·        Customize print settings and preview my printout before I print

·        How to protect a worksheet and workbook using a password

·        Lock or unlock cells

·        Protect the worksheet or workbook

·        Share a workbook to allow multiple to work in at time

Lesson 5 – Cut, Copy, and Paste

 

·        Cut or Copy

·        Paste Special

·        Paste Options

·        Right Click Paste Special

·        Paste Special Smart Tag

·        Paste Values Only

Lesson 6 – Performing Calculations

 

·        Formulas

·        Functions

·        Copy Formulas and Functions

·        Absolute/Relative Referencing (HP10081865)

·        Best Fit Multiple Columns

Lesson 7 – Presenting Data Using Charts

 

·        Create a basic chart

·        Insert Chart

·        Shortcut: F11

·        Modify a Chart

Lesson 8 – Printing

 

·        Headers and Footers

·        Page Margins and Print Titles

·        Page Orientation

·        Page Breaks

·        Print Ranges

 

 

Have questions about Microsoft Excel 2010 Fundamentals? Contact ThinkData Solutions, Inc

When & Where



ThinkData Lab
1500 1st Ave N
Ste L142
Birmingham, AL 35203

Thursday, May 10, 2012 from 9:00 AM to 12:00 PM (CDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.