Microsoft Excel 2013Introduction Onsite Group Training Course

Excel 2013 Fundamentals
Starting Excel 2013
What’s New in Excel 2013
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

• Microsoft Excel 2016 Introduction
• Microsoft Excel 2016 Advanced
• Microsoft Excel 2013 Intermediate
• Microsoft Excel 2013 Advanced
• Microsoft Excel 2010 Introduction
• Microsoft Excel 2010 Intermediate
• Microsoft Excel 2010 Advanced

Microsoft Value Pack (Best Deal)