All classes available with Virtual Classroom Live! Learn More

Microsoft Office Suite 2010

We do a lot of training here at Babsim for back end products like Windows Server or Visual Studio, but you don’t have to work in the IT industry to come across everyday problems that can be solved easily with a computer program.  Maybe you have a book report due for school, or you need to make a presentation to a sales team.  No matter what task is at hand, you can usually find the solution in the Microsoft Office Suite.

The good news is that we also do end user training for these tools so that you can learn the basics or master the entire program.  Take a look at some of our classes below:   

M-O2010 Microsoft office 2010 Transition from office 2003

You will work with the new and updated features of Microsoft Office 2010.

Upon successful completion of this course, students will be able to:

•identify the features that are common to all applications in the Microsoft Office suite.
•modify documents using Microsoft Office Word 2010.
•present spreadsheet data using Microsoft Office Excel 2010.
•create Microsoft Office PowerPoint 2010 presentations.
•work with databases using Access 2010.
•manage tasks using the new features in Microsoft Office Outlook 2010.
•share files in Microsoft Office 2010.

Microsoft Word

Level 1

You will create, edit, and enhance standard business documents using Microsoft® Office Word 2010.

Upon successful completion of this course, students will be able to:
•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

Level 2

You will create complex documents and build personalized efficiency tools using Microsoft Office Word 2010.

Upon successful completion of this course, students will be able to:
•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

Level 3

You will create, manage, revise, and distribute documents.

Upon successful completion of this course, students will be able to:
•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

Excel

Level 1

You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Upon successful completion of this course, students will be able to:
•create a basic worksheet by using Microsoft Excel 2010.
•perform calculations in an Excel worksheet.
•modify an Excel worksheet.
•modify the appearance of data within a worksheet.
•manage Excel workbooks.
•print the content of an Excel worksheet

Level 2

You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Upon successful completion of this course, students will be able to:
•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.

Level 3

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Upon successful completion of this course, students will be able to:
•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.

PowerPoint

Level 1

You will explore the PowerPoint environment and create a presentation. You will format text on slides to enhance clarity. To enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it.

Upon successful completion of this course, students will be able to:
•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.

Level 2

You will enhance your presentation by using features that will transform it into a powerful means of communication. You will customize the PowerPoint interface to suit your requirements and use features to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it to authenticate its validity.

Upon successful completion of this course, students will be able to:
•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.

Outlook

Level 1

You will use Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks, and create notes.

 Upon successful completion of this course, students will be able to:
•explore the Outlook interface, send mail, and respond to messages.
•compose email messages.
•organize email messages into folders.
•manage contacts and contact information.
•schedule appointments.
•schedule a meeting.
•manage tasks and notes.

Level 2

You will customize the Outlook environment, calendar, and mail messages, and will also track, share, assign, and quickly locate various Outlook items.

Upon successful completion of this course, students will be able to:

  • customize message settings.
  • organize and locate Outlook messages.
  • set calendar options.
  • track activities using the Journal.
  • assign and track tasks.
  • share folder information.
  • customize the Outlook environment.

Level 3

You will work with the advanced features of Outlook.

Upon successful completion of this course, students will be able to:

  • personalize their email.
  • organize Outlook items.
  • manage Outlook data files.
  • work with contacts.
  • save and archive email messages.
  • create a custom form.
  • work offline and remotely.

-Matt