Looks like this event has already ended.
Check out upcoming events by this organizer, or organize your very own event.
Microsoft Excel 2010 FundamentalsThinkData Solutions, IncMonday, April 23, 2012 from 9:00 AM to 12:00 PM (CDT)Birmingham, AL |
|
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
When & Where
ThinkData Lab
1500 1st Ave N
Ste E112
Birmingham,
AL 35203
Monday, April 23, 2012 from 9:00 AM to 12:00 PM (CDT)
Add to my calendar
Organizer
ThinkData Solutions, Inc
At ThinkData Solutions, our name says it all. We thoughtfully provide a wide variety of solutions to data and technology related challenges.
While every solution designed by ThinkData is customized to meet specific needs, we divide our services into three main categories: Training, Development, Consulting.
Training: Utilizing our technology lab at Innovation Depot and our full mobile training lab, we host a wide variety of technology training classes. Our training expertise ranges from productivity tools such as Microsoft Office to complex and integrated business systems. Whether the training is for an individual or several hundred employees in multiple locations, we customize our training to fit both your needs, and your budget. In addition to training classes held in our technology lab in the Innovation Depot, our team is also available for on-site training at your business.
Consulting: Through our corporate consulting services, we help companies stay ahead of technology trends to ensure employees can skillfully utilize the tools at their disposal. All engagements are different. For example, we have provided consulting from customized human resource skills tests and competency assessments to technology purchase evaluations and budget planning. If your company is looking bridge the gap between technology and success, we can provide options to maximize technology investments by designing a custom program to achieve your goals.
Development: In addition to training and consulting, the team at ThinkData is fully equipped to manage custom development projects. Our team is comprised of top-level programmers versed in multiple programming languages. From database development to custom software applications, we can build the tools your company needs to succeed. As experts in rapid custom development of web-based, distributed and standalone applications, we can quickly and efficiently meet your specific requirements and business needs. At ThinkData, programming is our passion.