This event has ended

Microsoft Excel 2010 Fundamentals

ThinkData Solutions, Inc

Monday, April 23, 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 5 Tickets Ended $175.00 $0.00

Share Microsoft Excel 2010 Fundamentals

Event Details

Microsoft Excel 2010 - Fundamentals

 

Course Description

Learn the fundamentals of Microsoft Excel 2010. Do you need to speed up the learning curve because you upgraded? Are you the person who loves tips, tricks shortcuts on navigation, selection, you know the stuff we do all the time in Excel 2010? This session is great for any user and any level! Packed full of fun!

 

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

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.