New Learning | Premium Moodle Theme

MOS: Excel 2010 Boot Camp

Description

Microsoft Office Excel 2010 contains powerful tools to help you analyze, manage, and share critical business data. You can also work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create Pivot Tables and Pivot Charts, incorporate multiple data sources, and import/export data.

This one-day course prepares you for Exam 77-882

Curriculum

Lesson 1: Getting Started with Excel

  • Identify the Elements of the Excel Interface
  • Navigate and Select Cells in Worksheets
  • Customize the Excel Interface
  • Create a Basic Worksheet


Lesson 2: Performing Calculations in an Excel Worksheet

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas


Lesson 3: Modifying an Excel Worksheet

  • Edit Worksheet Data
  • Find and Replace Data
  • Manipulate Worksheet Elements


Lesson 4: Modifying the Appearance of a Worksheet

  • Apply Font Properties
  • Add Borders and Colors to Cells
  • Align Content in a Cell
  • Apply Number Formatting
  • Apply Cell Styles


Lesson 5: Managing an Excel Workbook

  • Manage Worksheets
  • View Worksheets and Workbooks


Lesson 6: Printing Excel Workbooks

  • Define the Page Layout
  • Print a Workbook


Lesson 7: Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions


Lesson 8: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data


Lesson 9: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts


Lesson 10: Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts


Lesson 11: Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects


Lesson 12: Customizing and Enhancing the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates


Lesson 13: Streamlining Workflow

  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria


Lesson 14: Collaborating with Other Users

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access


Lesson 15: Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline


Lesson 16: Analyzing Data

  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPack


Lesson 17: Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links


Lesson 18: Importing and Exporting Data

  • Export Excel Data
  • Import a Delimited Text File


Lesson 19: Integrating Excel Data with the Web

  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query


Lesson 20: Structuring Workbooks with XML

  • Develop XML Maps
  • Import and Export XML Data

What's included?
 

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers  & Onsite Certification Testing- (excluding 1-day Adobe, 1-day MS Office and PMP Boot Camps) 
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

Training Formats

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

Instructor Led (the best training format we offer)
Live Online Classroom – Online Instructor Led
Self-Paced Video

Speak to an Admissions Representative for complete details

By far the most competitve price we found, which included exam vouchers, hands on labs, practice test and a true Master of Cyber Security concepts as our Instructor. Franklin Mesa was the best trainer I have ever had and i walked out certified on the last day of my CompTIA Security+ certification bootcamp. 

Marc Alfonso - CompTIA Security + Student

 

The Academy is one of the best educational values for today's job market.  I studied hard and got certified (A+ and N+).  Even though I had no prior IT experience, I now have a good job replacing obsolete computers in hospitals throughout the country.  At my job interview, I just slid my test scores and certification across the table to the interviewer, who is now my boss.  I was hired the next day.  

Not bad for a 65 year old.

John Arnett- Student 

"I congratulate The Academy for a great facility and good lab computers. The Academy is great and I will definitely be taking more courses and utilizing the services available. Omer Palo is an excellent instructor that truly knows his material. I never felt bored in his class which is a first for me. Thank You."

IT Director, Burger King Corporation

"The instructor Frank Martinez is excellent – he covered so much material in 2 weeks that was unbelievable! He definitely knows what he does and it shows in the way that he conducts each lecture. He is the greatest!"
"Thanks Academy for allowing me to experience the MCSA / MCSE + Security Boot camp."

IT Professional, Florida International University

 

Schedules

Contact Us


THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Students - Orbund Log-In