NetCom celebrates 15 years of helping our clients become lifelong learners
Passionate about Learning
HOME      LIVE CHAT        My NetCom Free Catalog 1-888-563-8266
.

Excel 2010: Level 3

Excel 2010: Level 3 Course Description

In this Level 3 series of Excel 2010, students will learn how to use some advanced features to work with different types of reports. Students will look at some productivity tools to increase data entry, features to enable collaboration with others, and use various commands to analyze large numerical reports. Students who complete this course can be on their way to preparing for a Microsoft Office Specialist exam. By completing the other levels available for this application students will have reviewed all of the exam objectives.

Intended Audience for the Excel 2010: Level 3 Course

  • 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 and export data.

Training Packages & Career Tracks that include the Excel 2010: Level 3 Course

Excel 2010: Level 3 Course Objectives

  • enhance productivity and efficiency by streamlining the workflow.
  • collaborate with other workbook users.
  • audit worksheets.
  • analyze data.
  • work with multiple workbooks.
  • import and export data.
  • integrate Excel data with the web.
  • structure workbooks with XML.

Required Prerequisites for the Excel 2010: Level 3 course

The Excel 2010: Level 3 Course prepare students for the following Exams

  • 77-882 : MOS: Microsoft Office Excel 2010

Recommended Next Steps after taking the Excel 2010: Level 3 Course

Excel 2010: Level 3 Course Outline

    1. Lesson 1: Streamlining Workflow
      1. Topic 1A: Update Workbook Properties
      2. Topic 1B: Create a Macro
      3. Topic 1C: Edit a Macro
      4. Topic 1D: Apply Conditional Formatting
      5. Topic 1E: Add Data Validation Criteria
    2. Lesson 2: Collaborating with Other Users
      1. Topic 2A: Protect Files
      2. Topic 2B: Share a Workbook
      3. Topic 2C: Set Revision Tracking
      4. Topic 2D: Review Tracked Revisions
      5. Topic 2E: Merge Workbooks
      6. Topic 2F: Administer Digital Signatures
      7. Topic 2G: Restrict Document Access
    3. Lesson 3: Auditing Worksheets
      1. Topic 3A: Trace Cells
      2. Topic 3B: Troubleshoot Invalid Data and Formula Errors
      3. Topic 3C: Watch and Evaluate Formulas
      4. Topic 3D: Create a Data List Outline
    4. Lesson 4: Analyzing Data
      1. Topic 4A: Create a Trendline
      2. Topic 4B: Create Sparklines
      3. Topic 4C: Create Scenarios
      4. Topic 4D: Perform a What-If Analysis
      5. Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak
    5. Lesson 5: Working with Multiple Workbooks
      1. Topic 5A: Create a Workspace
      2. Topic 5B: Consolidate Data
      3. Topic 5C: Link Cells in Different Workbooks
      4. Topic 5D: Edit Links
    6. Lesson 6: Importing and Exporting Data
      1. Topic 6A: Export Excel Data
      2. Topic 6B: Import a Delimited Text File
    7. Lesson 7: Integrating Excel Data with the Web
      1. Topic 7A: Publish a Worksheet to the Web
      2. Topic 7B: Import Data from the Web
      3. Topic 7C: Create a Web Query
    8. Lesson 8: Structuring Workbooks with XML
      1. Topic 8A: Develop XML Maps
      2. Topic 8B: Import and Export XML Data

    Benefits of taking the Excel 2010: Level 3 course at NetCom

    • Why choose Microsoft - Application Training at NetCom Learning?
      As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

      In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

      See the training value proposition below:

      Why Microsoft - Application Training at NetCom?
      NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS). CPLS is the premier training channel and delivery mechanism for Microsoft training content. As such, we are one of the only authorized training organizations that can market Microsoft training services and the only ones with access to Microsoft's Official Curriculum and latest technologies.

      Microsoft Certified Partner for Learning Solutions Value Proposition:
      Microsoft Certified Partner for Learning SolutionsNon-authorized Training Center
      Only MCT (Microsoft Certified Trainers) are authorized to teach the classNon MCT can teach the course
      Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online trainingDo not have access to official courseware
      Partners adhere to stringent Microsoft designated lab requirementsComputer and lab equipment may not be up to requirements of course
      Successful candidates are awarded Certificate of Completion directly from Microsoft for most of the coursesNot authorized to issue Certificate of Completion
      Software Assurance Vouchers can only be redeemed at a CPLSCannot redeem Software Assurance Vouchers from Microsoft
      Overall, a better quality training experienceSubstandard training experience

    • NetCom provides Authorized Training
      NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

      See our comprehensive list of partner authorizations.

    • Award winning, world-class Instructors
      Amanda G.
      - Phenom in the IT industry, earned her first Microsoft certification at age 15.
      - B.B.A in Management along with numerous Cisco, Microsoft, and CompTIA certifications.
      - Database designer and network administrator background.

      Bio:

      Amanda is a phenom in the IT industry. The daughter of NetCom Learning Instructor and Subject Matter Expert, Michael Govinda, Amanda was a Microsoft Certified Systems Engineer at age 15 and began earning Cisco credentials at 17. She also holds a B.B.A in Management and worked as a database designer and network administrator in the IT department of a top New York City publishing firm.

      Amanda currently teaches CompTIA A+, Network+, and Security+, as well as Cisco CCNA and CCNA Voice courses at NetCom Learning, garnering much acclaim from her students who enjoy a close-to-perfect pass rate on their certification exams. Amanda is a certified trainer for Cisco and CompTIA, and holds numerous technical certifications including Cisco Certified Network Associate-Security, CCSI, CCNP, CCVP, MCSE, CompTIA A+, CompTIA Net+, and CompTIA Security+.
      Carmille A.
      - Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark;
      - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000.
      - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis.

      Bio:

      Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS.

      Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.

      Charles W.
      - Expert in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access as well as Adobe Graphic and Web Designer (InDesign, Acrobat, Photoshop, Illustrator, Dreamweaver and Flash Catalyst)
      - Holds an A.A.S in Graphic Design as well as various Awards and Affiliations, including MCT, MCP, MCAS, and Office 2007 Master.
      - Senior Lead Trainer for over 10 years.

      Bio:

      Charles is a Technical Trainer & Instructional Designer for over 10 years. He is a Microsoft Certified Trainer and dedicates himself to Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access. He is also an Adobe specialist and holds a degree in Graphic Design.

      Charles is well known for his high evaluation scores, achieving 8.75 out of 9 on a regular basis, teaching in one-on-one, instructor-led, and web-based environments; one of the reasons for his high evaluation is his expertise in increasing personnel performance by developing and implementing programs constructed from the job task analysis process. Charles currently teaches Adobe Graphic and Web Designer, and Microsoft Office Specialist courses at NetCom Learning.
      Ignacio J.
      - Designs and architects Microsoft IT solutions since the early 1990s.
      - Hands-on experience in multiple Microsoft Dynamics products including CRM, GP, SL, AX and NAV since 2004.
      - Taught over 250 courses at NetCom Learning.

      Bio:

      Ignacio is a Senior Solutions Architect, Civil Engineer and Certified Expert Trainer. He has been designing and architecting Microsoft IT solutions since the early 1990s, and has extensive experience developing scalable and high performance integration solutions. In 2004, Ignacio expanded into business management and accounting software as well, where he gained hands-on experience in many Microsoft Dynamics products including CRM, GP, SL, AX and NAV.

      Ignacio holds a library of industry-wide certifications from Microsoft and other leading IT vendors. He has taught over 250 courses at NetCom Learning and is revered by students for his wide-ranging IT expertise.
      Paul B.
      - Microsoft Office Specialist with over 14 years of training experience.
      - Expert in the IT industry, working in the IT field since 1986.
      - Highly rated instructor with an all-time average evaluation score of 8.7 out of 9.

      Bio:

      Paul is Subject Matter Expert specializing in the Microsoft Office Suite and SharePoint end-user technologies with more than 25 years of practical experience in the IT industry. He is also a Microsoft Certified Trainer (MCT) with over 14 years of training experience.

      A sought-after instructor and eternal favorite among students, his instructor feedback scores are among the industry's highest at 8.7 out of 9.0. As a trainer, his knowledge and passion for the subject matter as well as his personable nature, excellent communications skills and sense of humor are implicit in every class. NetCom Learning is proud to have Paul on our roster of IT geniuses.
      Richard B.
      - More than 25 years of know-how in the IT industry, including Product Engineering at Panasonic.
      - CompTIA and Microsoft Subject Matter Expert with over 9 certifications.
      - Subject Matter Expert at NetCom Learning since 2006, where has trained more than 1300 students.

      Bio:

      Richard Brown is a Microsoft Certified Trainer and Subject Matter Expert specializing in Microsoft and CompTIA. Richard has more than 25 years of experience in the IT industry with a successful career as Product and Network Engineer in Fortune 500 companies such as Panasonic.

      A sought-after enterprise technician, Richard is a natural educator teaching beginner to advanced Server 2008 R2 and SharePoint 2010 as well as A+ and Network+ classes. Richard has trained more than 1300 students at NetCom Learning with an average evaluation score of 8.6 out of 9 since 2006.

      Vijayanti R.
      - Specialist in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, FrontPage, and Access. Microsoft Office Specialist and Microsoft Office Master.
      - Degree in Information and Business Technology from South Bank University - United Kingdom.
      - Business professional since 1992 and Information Technology instructor since 2003.

      Bio:

      Vijayanti has been a business professional for over 20 years and an Information Technology instructor for over 10 years. She is a Microsoft Office Specialist and a Microsoft Office Master with a degree in Information and Business Technology from South Bank University in the UK.

      Vijayanti also trained and qualified as an Information and Communications Technology Teacher. She has been working at Netcom Learning as a Software Instructor with an extensive know-how in Microsoft Office Suites.
    • Actual Client Testimonials
      May 13 2013
      It was easy and useful. The instructor was happy to cater the course to our needs. The instructor was very knowledgeable and a great resource.

      - Kim G.
      Course(s) Taken

      May 13 2013
      Useful, relevant content, well instructed!

      - Joe S.
      Course(s) Taken

      May 13 2013
      I would recommend NetCom because I thought that the instructors were knowledgeable and patient. I liked that the instructors asked the class for real examples of their work. I liked that the classes were small.

      - Kathleen E.
      Course(s) Taken

      May 13 2013
      They were good thorough classes and very accommodating.

      - Jared W.
      Course(s) Taken

      May 13 2013
      I would recommend NetCom because of the care they take in making certain you learn. The class size was nice and we were able to receive individualized attention thereby promoting deeper absorption of the materials. The place is neat, clean and friendly. They were very hospitable to the students as well.

      - Catherine F.
      Course(s) Taken

      May 10 2013
      Friendly and fun learning environment. Beneficial classes from beginners to advanced knowledge mixture. Easy to learn! The support and troubleshooting was fantastic.

      - Tyler N.
      Course(s) Taken

      May 10 2013
      I would absolutely recommend NetCom to a friend. Both Robert and Octavia are wonderful, and the instructors are a class act.
      Octavia is a true gem of a person. NetCom is very fortunate to have her as the "front house" person. She is extremely kind, professional, patient, and efficient. And Robert took a great deal of time with me when I first inquired about classes; he explained the different types of classes, and he went over the curriculum in an in-depth manner.

      - Rebecca J.
      Course(s) Taken

      May 10 2013
      I felt the courses provided and the content are very worthwhile.

      - Joe S.
      Course(s) Taken

    • Awards won by NetCom
      NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

      See our list of awards.

    • Specialized Boot Camp Training

      Discover Our Vegas Boot Camp experience

      This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

      For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.


    Enrollment Options for the Excel 2010: Level 3 course


    Training Delivery Methods

    Take this training with one of the following training delivery methods
    • Classroom Training
      Classroom Training NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.

    • Live Online Training (LOT)
      Live Online Training NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
      Learn more about LOT

    • Boot Camp Training
      Boot Camp Training NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps

    • Private Onsite Training
      Private Onsite Training With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
      Learn more about Private Onsite Training

    • Private 1-on-1 Training
      Private 1-on-1 Training NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
      Learn more about Private 1-on-1 Training

    Contact us
    call usCall us Toll-free at 1-888-563-8266
    web formFREE Training Inquiry form
    live chatWebsite Live Chat
    email usContact us via Email: info@netcomlearning.com

    Duration: 1 days (8 hours)
    .  Next Class Dates
    Register Jun 26, 2013 New York, NY
    or Attend Online
     Price.. This class is guaranteed to run
     
    Register Aug 28, 2013 New York, NY
    or Attend Online
     Price..
     
    Register Oct 23, 2013 New York, NY
    or Attend Online
     Price..
     
     more schedules more..
    classes are guaranteed to run.

    For a customized version of this class, please contact us or call 1-888-563-8266.
    .  Get More Information
    Name:
    Email:
    Phone:
    Comments:
    Help us filter out spammers:

    Change text if hard to read
    Enter code above:

    .  Similar Courses

    . .
    live chat

    .  CALL 1-888-563-8266
    . arrow  Need course pricing?
    arrow  Need more information?
    arrow  Worried about financing?
    Newsletter:
    © 1998-2013, NetCom Learning. All Rights Reserved.