Microsoft Excel 2010 Introduction Onsite Group Training Course |
Course Description: The Microsoft Excel 2010 introductory course to teaches students the basic operations and functions of Microsoft Excel 2010. We recommend this class to students that are new to Excel or want to refresh their core skills.
Upon completion of the course, student will be able to complete the following tasks in Excel 2010:
- Excel 2010 New Features
- Excel Fundamentals
- Worksheet Basics
- Formatting a Worksheet
- Creating and Working with Charts
- Managing Workbooks
- Printing and Page Layout
Program Fundamentals
Starting Excel 2010
What’s New in Excel 2010
Understanding the Excel Program Screen
Giving Commands
Using Command Shortcuts
Creating a New Workbook
Opening a Workbook
Previewing and Printing a Worksheet
Saving a Workbook
Closing a Workbook
Using Help
Exiting Excel
Program Fundamentals Review
Getting Started with Worksheets
Navigating a Worksheet
Entering Labels and Values
Selecting a Cell Range and Entering Data in a Cell Range
Overview of Formulas and Cell References
Entering Formulas
Entering Content Automatically
Getting Started with Worksheets Review
Editing a Worksheet
Editing Cell Contents
Copying and Moving Cells
Controlling How Cells Are Moved or Copied
Collecting Items to Move or Copy
Checking Your Spelling
Inserting Cells, Rows, and Columns
Deleting Cells, Rows, and Columns
Using Undo and Redo
Finding and Replacing Content
Adding Comments to Cells
Editing a Worksheet Review
Formatting a Worksheet
Formatting Text
Formatting Values
Adjusting Row Height and Column Width
Working with Cell Alignment
Adding Cell Borders and Background Colors
Copying Formatting
Applying and Removing Cell Styles
Creating and Modifying Cell Styles
Using Document Themes
Applying Conditional Formatting
Creating and Managing Conditional Formatting Rules
Finding and Replacing Formatting
Formatting a Worksheet Review
Creating and Working with Charts
Choosing and Selecting the Source Data
Choosing the Right Chart
Inserting a Chart
Editing, Adding, and Removing Chart Data
Changing Chart Data
Changing Chart Layout and Style
Working with Chart Labels
Changing the Chart Gridlines
Changing the Scale
Emphasizing Data
Using Chart Templates
Changing Chart Type
Using Sparklines
Creating and Working with Charts Review
- Discuss your team's educational needs with a BCS representative.
- Schedule class date(s) that fit your team's availabilty.
- Professional Trainer will conduct the class at your facility or online.
- We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
- You provide the meeting/conference room, student xomputers with correct software installed and a projector for the instructor to use.
- Usually a two-week lead time to schedule a class.
- Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
- 1 Hour Lunch Break, and Two 15-minute Break
- A Professional Instructor will come to your office and train your students
- Up to 6 students can attend the class for the flat rate course price of $1800/day
- Additional students can be added for $125/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
- A Professional Instructor will come to your office and train your students
- Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
- Additional students can be added for $100/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
- A Professional Instructor will come to your office and train your students
- Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
- Additional students can be added for $75/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
On-Site Training Request
Please complete the information request form below, and one of our representatives will contact you within one business day.