MOS (Word, Excel, PowerPoint 2010) - Boot Camp

About the MOS (Word, Excel, PowerPoint 2010) - Boot Camp

MOS: Word, Excel, PowerPoint 2010 Boot Camp (6 days)   

Course Objectives

• create a basic Word document.
• edit a document.
• format text.
• format paragraphs.
• insert a table.
• insert special characters and graphical objects.
• control the page setup and appearance of a Word document.
• proofread documents for accuracy.
• manage lists.
• customize tables and charts.
• customize the formatting of a document using styles and themes.
• modify pictures in a document.
• create customized graphic elements.
• insert content using Quick Parts.
• control text flow.
• use templates to automate document creation.
• use the mail merge function.
• use macros to automate common tasks.
• use Word with other programs.
• collaborate on documents.
• manage document versions.
• add reference marks and notes.
• simplify the use of long documents.
• secure a document.
• create forms.
• create a basic worksheet by using Microsoft Office Excel 2010.
• perform calculations in an Excel worksheet.
• modify an Excel worksheet.
• format a worksheet.
• print the content of an Excel workbook.
• manage an Excel workbook.
• use advanced formulas.
• organize worksheet and table data using various techniques.
• create and modify charts.
• analyze data using PivotTables, Slicers, and PivotCharts.
• insert and modify graphic objects in a worksheet.
• customize and enhance workbooks and the Microsoft Office Excel environment.
• 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.
• explore the PowerPoint 2010 interface and familiarize yourself with the interface.
• create a presentation.
• format text on slides.
• add graphical objects to a presentation.
• modify graphical objects on slides.
• work with tables in a presentation.
• import charts to a presentation.
• prepare to deliver a presentation.
• customize the PowerPoint environment.
• customize a design template.
• add SmartArt graphics to a presentation.
• add special effects to a presentation.
• customize a slide show.
• collaborate on a presentation.
• secure and distribute a presentation.

Course Outline

• Creating a Basic Word Document
  1. Identify the Elements of the User Interface
  2. Customize the Word Environment
  3. Enter Text in a Document
  4. Save a Document
  5. Open a Document in Different View Modes
  6. Print a Document
  7. Obtain Help in Word
• Editing a Word Document
  1. Navigate Through a Document and Select Text
  2. Modify Text
  3. Undo Text Changes
  4. Find and Replace Text
• Formatting Text in a Word Document
  1. Change Font Styles
  2. Highlight Text in a Document
• Formatting Paragraphs in a Word Document
  1. Set Tabs to Align Text
  2. Modify the Layout of a Paragraph
  3. Create Lists
  4. Apply Borders and Shading
  5. Apply Styles
  6. Manage Formatting
• Inserting Tables in a Word Document
  1. Create a Table
  2. Modify a Table
  3. Format a Table
  4. Convert Text to a Table
• Inserting Special Characters and Graphical Objects
  1. Insert Symbols and Special Characters
  2. Insert Illustrations in a Document
• Controlling the Appearance of the Pages in a Word Document
  1. Control the Layout of a Page
• Managing Lists
  1. Sort a List
  2. Renumber a List
  3. Customize a List
• Customizing Tables and Charts
  1. Sort Table Data
  2. Control Cell Layout
  3. Perform Calculations in a Table
  4. Create Charts
• Creating Customized Formats with Styles and Themes
  1. Create or Modify a Text Style
  2. Create a Custom List or Table Style
  3. Apply Default and Customized Document Themes
• Modifying Pictures
  1. Resize a Picture
  2. Adjust the Picture Appearance Settings
  3. Wrap Text Around a Picture
  4. Insert and Format Screenshots in a Document
• Creating Customized Graphic Elements
  1. Create Text Boxes and Pull Quotes
  2. Draw Shapes
  3. Add WordArt and Other Special Effects to Text
  4. Create Complex Illustrations with SmartArt
• Inserting Content Using Quick Parts
  1. Insert Building Blocks
  2. Create Building Blocks
  3. Modify Building Blocks
  4. Insert Fields Using Quick Parts
• Controlling Text Flow
  1. Control Paragraph Flow
  2. Insert Section Breaks
  3. Insert Columns
  4. Link Text Boxes to Control Text Flow
• Using Templates to Automate Document Creation
  1. Create a Document Based on a Template
  2. Create a Template
• Automating the Mail Merge
  1. Use the Mail Merge Feature
  2. Merge Envelopes and Labels
  3. Create a Data Source Using Word
• Using Macros to Automate Tasks
  1. Automate Tasks Using Macros
  2. Create a Macro
• Using Microsoft Office Word 2010 with Other Programs
  1. Link a Word Document to an Excel Worksheet
  2. Send a Document Outline to Microsoft Office PowerPoint
  3. Send a Document as an Email Message
• Collaborating on Documents
  1. Modify User Information
  2. Send a Document for Review
  3. Review a Document
  4. Compare Document Changes
  5. Merge Document Changes
  6. Review Track Changes and Comments
  7. Coauthor a Document
• Managing Document Versions
  1. Create a New Document Version
  2. Compare Document Versions
  3. Merge Document Versions
• Adding Reference Marks and Notes
• Insert Bookmarks
  1. Insert Footnotes and Endnotes
  2. Add Captions
  3. Add Hyperlinks
  4. Add Cross-References
  5. Add Citations and a Bibliography
• Simplifying the Use of Long Documents
  1. Insert Blank and Cover Pages
  2. Insert an Index
  3. Insert a Table of Figures
  4. Insert a Table of Authorities
  5. Insert a Table of Contents
  6. Create a Master Document
• Securing a Document
  1. Hide Text
  2. Remove Personal Information from a Document
  3. Set Formatting and Editing Restrictions
  4. Add a Digital Signature to a Document
  5. Set a Password for a Document
  6. Restrict Document Access
• Creating Forms
  1. Add Form Fields to a Document
  2. Protect a Form
  3. Automate a Form
• Creating a Basic Excel Worksheet
  1. Identify the Elements of the User Interface
  2. Customize the Excel Interface
  3. Work with Cells
  4. Enter Data in an Excel Workbook
  5. Obtain Help in Excel
• Performing Calculations in an Excel Worksheet
  1. Create Basic Formulas
  2. Calculate the Cell Values by Using Functions
  3. Copy Formulas and Functions
• Modifying an Excel Worksheet
  1. Manipulate Data
  2. Modify the Worksheet Elements
  3. Search for Data in a Worksheet
  4. Modify Rows and Columns
• Formatting an Excel Worksheet
  1. Modify Fonts
  2. Check a Worksheet for Spelling Errors
  3. Apply Number Formatting
  4. Add Borders and Colors to Cells
  5. Align the Content in a Cell
  6. Apply Cell Styles
• Printing Excel Workbooks
  1. Set the Page Layout Options
  2. Set Page Breaks
  3. Print a Workbook
• Managing an Excel Workbook
  1. Format Worksheet Tabs
  2. Manage Worksheets
  3. View Worksheets and Workbooks
• Calculating Data with Advanced Formulas
  1. Apply Cell and Range Names
  2. Calculate Data Across Worksheets
  3. Use Specialized Functions
  4. Analyze Data with Logical and Lookup Functions
• Organizing Worksheet and Table Data
  1. Create and Modify Tables
  2. Format Tables
  3. Sort or Filter Data
  4. Use Functions to Calculate Data
• Presenting Data Using Charts
  1. Create a Chart
  2. Modify Charts
  3. Format Charts
• Analyzing Data Using PivotTables, Slicers, and PivotCharts
  1. Create a PivotTable Report
  2. Filter Data Using Slicers
  3. Analyze Data Using PivotCharts
• Inserting Graphic Objects
  1. Insert and Modify Pictures and ClipArt
  2. Draw and Modify Shapes
  3. Illustrate Workflow Using SmartArt Graphics
  4. Layer and Group Graphic Objects
• Customizing and Enhancing the Excel Environment
  1. Customize the Excel Environment
  2. Customize Workbooks
  3. Manage Themes
  4. Create and Use Templates
• Streamlining Workflow
  1. Update Workbook Properties
  2. Create a Macro
  3. Edit a Macro
  4. Apply Conditional Formatting
  5. Add Data Validation Criteria
• Collaborating with Other Users
  1. Protect Files
  2. Share a Workbook
  3. Set Revision Tracking
  4. Review Tracked Revisions
  5. Merge Workbooks
  6. Administer Digital Signatures
  7. Restrict Document Access
• Auditing Worksheets
  1. Trace Cells
  2. Troubleshoot Invalid Data and Formula Errors
  3. Watch and Evaluate Formulas
  4. Create a Data List Outline
• Analyzing Data
  1. Create a Trendline
  2. Create Sparklines
  3. Create Scenarios
  4. Perform a What-If Analysis
  5. Perform a Statistical Analysis with the Analysis ToolPak
• Working with Multiple Workbooks
  1. Create a Workspace
  2. Consolidate Data
  3. Link Cells in Different Workbooks
  4. Edit Links
• Importing and Exporting Data
  1. Export Excel Data
  2. Import a Delimited Text File
• Integrating Excel Data with the Web
  1. Publish a Worksheet to the Web
  2. Import Data from the Web
  3. Create a Web Query
• Structuring Workbooks with XML
  1. Develop XML Maps
  2. Import and Export XML Data
• Getting Started with PowerPoint
  1. Identify the Elements of the User Interface
  2. View a Presentation
  3. Save a Presentation
  4. Use Microsoft PowerPoint Help
• Creating a Basic Presentation
  1. Initiate a Presentation
  2. Enter Text
  3. Arrange Text
  4. Format Text Placeholders
  5. Add Slides to a Presentation
  6. Arrange Slides
  7. Work with Themes
• Formatting Text on Slides
  1. Apply Character Formats
  2. Format Paragraphs
• Adding Graphical Objects to a Presentation
  1. Insert Images into a Presentation
  2. Add Shapes
  3. Add Visual Styles to Text in a Presentation
• Modifying Graphical Objects in Presentations
  1. Edit Graphical Objects on a Slide
  2. Format Graphical Objects on a Slide
  3. Group Graphical Objects on a Slide
  4. Arrange Graphical Objects on a Slide
  5. Apply an Animation Effect to a Graphical Object
• Working with Tables
  1. Insert a Table in a Slide
  2. Format Tables
  3. Import Tables from Other Office Applications
• Working with Charts
  1. Insert Charts in a Slide
  2. Modify a Chart
  3. Import Charts from Other Office Applications
• Preparing to Deliver a Presentation
  1. Review the Content in a Presentation
  2. Divide a Presentation into Sections
  3. Add Transitions
  4. Add Speaker Notes
  5. Print a Presentation
  6. Deliver a Presentation
• Customizing the PowerPoint Environment
  1. Customize the PowerPoint Interface
  2. Set Options for Working with PowerPoint
• Customizing a Design Template
  1. Set Up a Slide Master
  2. Create Custom Slide Layouts
  3. Add Headers and Footers
  4. Modify the Notes Master
  5. Modify the Handout Master
• Adding SmartArt Graphics to a Presentation
  1. Insert SmartArt Graphics
  2. Modify SmartArt Graphics
• Adding Special Effects to a Presentation
  1. Add Multimedia Elements
  2. Customize Slide Component Animations
• Customizing a Slide Show
  1. Set Up a Custom Slide Show
  2. Annotate a Presentation
  3. Create a Presenter-Independent Slide Show
  4. Set Up a Slide Show to Repeat Automatically
• Collaborating on a Presentation
  1. Review a Presentation
  2. Publish Slides to a Slide Library
  3. Restrict Access to a Shared Presentation
  4. Share a Presentation Using PowerPoint Web App
• Securing and Distributing a Presentation
  1. Broadcast a Presentation
  2. Convert a Presentation into a Video
  3. Package a Presentation
  4. Publish a Presentation to Other File Formats
  5. Secure a Presentation

Why should you take the MOS (Word, Excel, PowerPoint 2010) - Boot Camp

For IT professionals, certification is a third party validation of your skills, that helps distinguish you from your peers. Beyond demonstrating a level of competency and proficiency, certification proves that you are committed to your cause and that you've invested the time and money to prove it. Holding a certification also makes you a more valuable employee, and often results in raises, promotions, and a better career.

For organizations, certifications identify the credentials that can be used to hire the right employee. Having certified employees also increases sales for the organization by proving to prospective clients that the organization has the skills to support its claims.

Do you have the right background for MOS (Word, Excel, PowerPoint 2010) - Boot Camp?

Benefit of taking MOS (Word, Excel, PowerPoint 2010) - Boot Camp 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 Information Technology 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 Solutions Non-authorized Training Center Only MCT (Microsoft Certified Trainers) are authorized to teach the class Non MCT can teach the course Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online training Do not have access to official courseware Partners adhere to stringent Microsoft designated lab requirements Computer 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 courses Not authorized to issue Certificate of Completion Software Assurance Vouchers can only be redeemed at a CPLS Cannot redeem Software Assurance Vouchers from Microsoft Overall, a better quality training experience Substandard 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.

  See more...  
• Actual Client Testimonials

  Dec 06 2011 Instructor was very well-informed and easy to understand. Learned many new shortcuts and efficiencies from the training. - Anthony P. Course(s) Taken Excel 2007

  
  

  Dec 06 2011 The training helped me learn a lot of knowledge I can translate into my every day work load. This class provided me a lot of knowledge to help make using Excel a lot more efficient. - John M. Course(s) Taken Excel 2007

  
  

  Dec 06 2011 Everything was as expected. - Chris F. Course(s) Taken Excel 2007

  
  

  Oct 21 2011 Instructor Marc made the subject matter interesting. I felt we learned much quicker. Looking forward to putting what I learned into practice at work. - Jorge V. Course(s) Taken Word 2007

  
  

  Oct 21 2011 My training experience has been very pleasant. The location of the facility is very convenient. The instructor was very friendly and made the time go by fast by keeping everyone engaged. I truly enjoyed my learning experience. - Harriet K. Course(s) Taken Excel 2007

  
  

  Oct 21 2011 The overall training was satisfactory and appropriate with regards to my needs at work. - Jean T. Course(s) Taken Excel 2007

  
  

  Oct 20 2011 Good instructor, clean and new accommodations. Overall, very good. -Nelson P. Course(s) Taken Excel 2007

  
  

  Oct 14 2011 Traveling to NetCom New York was a great decision! The staff and instructor were helpful and made the learning and testing of MOS Boot camp a very enjoyable experience. I highly recommend the session and the experience that it provides. -Isabel F. Course(s) Taken MOS (Word, Excel, PowerPoint 2010) - Boot Camp

  
  

• Real world Client Case Studies
  
  

  Customized Training helps improve Business Productivity.

  Published On: 6 April 2006

  Customer: Whole Foods Market

  Location: New York, NY, US

  Industry: Retail

  Founded in 1980 as one small store in Austin, Texas, Whole Foods Market® is now the world's leading retailer of natural and organic foods, with 183 stores in North America and the United Kingdom. To date Whole Foods Market remains uniquely mission driven: We're highly selective about what we sell, dedicated to stringent Quality Standards, and committed to sustainable agriculture.

  Business Needs: Whole Foods uses Excel for a wide variety of purposes. Each department leader in Whole Foods must track many financial metrices on a daily basis. Whole Foods felt that their was a huge gap in the ability of team members using Excel. Some knew how to create graph and extrapolate data, while others were unsure of what right click meant.   Solution: NetCom customized a training program to address the broad spectrum of skills. Through a tailored class delivery format, Whole Foods was able to maximize the ROI on their training investment. By monitoring the feedback from participants, NetCom then suggested further modifications to meet the skill levels of the students.   Training: Courses Taken Excel 2003: Level 1 Excel 2003: Level 2 Packages Purchased Excel 2003   Benefits: Whole Foods was pleased to see that their Team Members walked away with practical knowledge of Excel. In addition to usable software skills, they were also inspired to seek out advanced uses of the program. Not only did the customized training helped achieve a high return on investment, it also helped improve day to day productivity.

• 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 Bootcamp Training
  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.

• Certification Attainment Policy (CAP)
  If you are not able to attain all certifications during the boot camp, you can attend the boot camp again within a period of one year, if it is still being offered and has availability. To attend, simply retain your course materials. You will need to pay for test vouchers and optional travel. If the courseware has changed, you must purchase the latest material. CAP would not apply if the class you want to reattend is for a different certification.

Next Step, how do I attend the MOS (Word, Excel, PowerPoint 2010) - Boot Camp?

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com