Microsoft Office 5 Day Bootcamp
Request a Class
9:00am - 4:30pm
This 5 Day Bootcamp is a fast paced course that includes: Excel Level 1, Excel Level 2, Word Level 1, Word Level 2 and Outlook Level 1.
AUDIENCE AND PREREQUISITES
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. Word is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy and even fun.
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel , Word and Outlook that is necessary to create and work with electronic spreadsheets. Students will learn Excel Level 1 and 2. The Excel courses is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets as well as learn higher-level functionality in Excel to anlyze and present data. Word 1 and 2 Students will learn skills such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content. To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10 or 7 environment and be able to use Windows 10 or 7 to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders. To obtain this level of skill and knowledge, you can take either one of the following Logical Operations courses:
FOLLOW UP COURSES
Student should be prepared to work and grasp topics quickly. Each Subject Matter will be complete in 1 day for 5 days.
To ensure your success in this course, you should have end-user skills with any current version of Windows® Including: Being able to start programs, Switch between programs, locate saved files, close programs and access websites using a web browser.
This Course is subject to a minimum enrollment to run. This class may run as a virtual instructor led course if the minimum enrollment has not been met. Please contact us at firstname.lastname@example.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course Objectives Excel Level 1 - Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is cr Perform calculations. Modify a worksheet. Format a worksheet. Print workbooks. Manage workbooks.Excel Level 1 Lesson 1: Getting Started with Microsoft Office Excel Lesson 2: Performing Calculations Lesson 3: Modifying a Worksheet Lesson 4: Formatting a Worksheet Lesson 5: Printing Workbooks Lesson 6: Managing WorkbooksCourse Objectives Excel Level 2 - Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizatio Work with functions. Work with lists. Analyze data. Visualize data with charts Use PivotTables and PivotCharts.Excel Level 2 Lesson 1: Working with Functions Lesson 2: Working with Lists Lesson 3: Analyzing Data Lesson 4: Visualizing Data with Charts Lesson 5: Using PivotTables and PivotCharts Financial Functions Working with Graphical Objects Using Array Formulas Microsoft Office Excel 2016 Exam 77-727Word Level 1 - In this course, you'll learn how to: Use Word 2016 to create and edit simple documents Format documents. Tables and lists. Add design elements and layout options. Proof documents. Course covers MS Office Specialist exam objectives to help students prepare for the Word 2016 Exam & the Word 2016 Expert Exam..Word Level 1 Lesson 1: Getting Started with Word Lesson 2: Formatting Text and Paragraphs Lesson 3: Working More Efficiently Lesson 4: Managing Lists Lesson 5: Adding Tables Lesson 6: Inserting Graphic Objects Lesson 7: Controlling Page Appearance Lesson 8: Preparing to Publish a DocumentWord Level 2 Lesson 1: Organizing Content Using Tables and Charts Lesson 2: Customizing Formats Using Styles and Themes Lesson 3: Inserting Content Using Quick Parts Lesson 4: Using Templates to Automate Document Formatting Lesson 5: Controlling the Flow of a Document Lesson 6: Simplifying and Managing Long DocumentsOutlook Level 1 - In this course, you will use Outlook to manage your email communications, including composing, reading, and responding to emails; schedule appointments, meetings; manage contacts Schedule tasks and create notes Customize message response options Organize your mail. Navigate Outlook to read and respond to email Use the Address Book, and format and spell check new messages. Attach files and insert illustrations to messages. Customize read and response options. Use flags, categories, and folders to organize messages. Create and work with Contacts. Create appointments and schedule meetings in Calendar. Create and work with Tasks and Notes. You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Outlook 2016.Outllook Level 1 Lesson 1: Getting Started with Outlook 2016 Lesson 2: Formatting Messages Lesson 3: Working with Attachments and Illustrations Lesson 4: Customizing Message Options Lesson 5: Organizing Messages Lesson 6: Managing Your Contacts Lesson 7: Working with the Calendar Microsoft Office Outlook 2016 Exam 77-731