Through completing the introductory Excel 2016 training course, you’ll develop foundational data manipulation knowledge and skills that you simply can repose on through additional training and use. With the Excel 2016 - Part 1 course under your belt, you’ll feel confident using one among the world’s most powerful applications.

Audience Profile

If you’re curious about learning the way to use Excel or liable for creating spreadsheets or performing basic data manipulation, this course is ideal for you.

Skills Gained

• Write a variety of fundamental Excel commands
• Perform worksheet calculations
• Build custom formulas
• Amend elements during a worksheet
• Apply formatting changes to cells
• Manage workbook properties

Prerequisites

• Using Microsoft Windows 10
  Microsoft Windows 10 - Transition from Windows 7

Deepen your understanding of Excel by learning the way to create advanced workbooks and worksheets. With Part 2 training from New Horizons under your belt, you’ll be able to create custom formulas, apply built-in Excel functions and manipulate data to extract the insights you would like .

Audience Profile

If you’re liable for analyzing, managing or manipulating data sets, this course is for you. you'll apply the learnings from Excel 2016 - Part 2 to virtually any industry, including accounting, office administration, business or financial analysis, marketing, sales and more.

Skills Gained

• Perform calculations using functions and formulas
• Sort, filter and query data
• Create and format tables
• Visualize data with charts
• Create advanced formulas
• Analyze data with PivotTables and PivotCharts

Prerequisites

• Excel 2016 - Part 1

This advanced Excel course builds off learnings from Excel 2016 - Parts 1 & 2 and prepares you to finish difficult Excel tasks like LOOKUPS, macros and more. The course also covers Microsoft Office Specialist exam objectives to assist you prep for the certification exam.

Audience Profile

If you’re proficient in Excel 2016 and searching to master more advanced features, this course is for you.

Skills Gained

• Refer to internal and external worksheets
• Perform LOOKUPs and audit formulas
• Share and protect workbooks
• Automate workbook functionality using validation rules and macros
• Create sparklines and map data
• Forecast data

Prerequisites

• Excel 2016 - Part 1
• Excel 2016 - Part 2

In this course, students will use PowerPoint 2016 to start creating engaging, dynamic multimedia presentations.

Audience Profile

This course is meant for college kids who wish to realize a foundational understanding of Microsoft PowerPoint 2016 that's necessary to make and develop engaging multimedia presentations.

Skills Gained

• Identify the essential features and functions of PowerPoint 2016.
• Develop a PowerPoint presentation.
• Perform advanced text editing operations.
• Add graphical elements to your presentation.
• Modify objects in your presentation.
• Add tables to your presentation.
• Add charts to your presentation.
• Prepare to deliver your presentation.

Prerequisites

• Using Microsoft Windows 10

In this course, students learn different tools & features within PowerPoint which will help them deliver content in an informative & memorable manner. Students will create presentations that not only stand out, but also don't consume all of their time.

Audience Profile

This course is meant for college kids who have a foundational working knowledge of PowerPoint 2016, who wish to require advantage of the application's higher-level usability, security, collaboration, and distribution functionality.

Skills Gained

• Modify the PowerPoint environment.
• Customize design templates.
• Add SmartArt and math equations to a presentation.
• Work with media and animations.
• Collaborate on a presentation.
• Customize a slide show.
• Secure and distribute a presentation.

Prerequisites

• PowerPoint 2016 - Part 1
• Using Microsoft Windows 10

In this course, you'll use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create Tasks and Notes for yourself, and customize the Outlook interface to fit your working style.

Audience Profile

This course is meant for people that have a basic understanding of Microsoft® Windows® and wish to understand the way to use Outlook as an email client to manage their email communications, calendar appointments, contact information, and other communication tasks. additionally to making and sending email, this course will introduce you to organizing your mail, working with attachments, formatting message text, scheduling meetings, and responding to meeting invitations.

Skills Gained

• Navigate Outlook 2016 to read and answer email.
• Use the Address Book, format and spell check new messages.
• Attach files and insert illustrations to messages.
• Customize read and response options.
• Use flags, categories, and folders to arrange messages.
• Create and work with Contacts.
• Create appointments and schedule meetings in Calendar.
• Create and work with Tasks and Notes.

Prerequisites

• Using Microsoft Windows 10
• Microsoft Windows 10 - Transition from Windows 7

This course builds upon the foundational knowledge presented within the Microsoft ® Office Outlook® 2016: Part 1 course and can help students customize a communication system well-suited to your work styles.

Audience Profile

This course is meant for people that have a basic understanding of Microsoft® Windows® and need to understand the way to use Outlook’s advanced features to manage their email communications, calendar events, contact information, search functions, and other communication tasks.

This course is additionally designed for college kids who are preparing for the Microsoft Office Specialist certification and who want to organize for Microsoft Outlook 2016.

Skills Gained

• Modify messages and set global options.
• Organize, search, and manage messages.
• Manage your mailbox.
• Automate message management.
• Work with calendar settings.
• Manage contacts and groups.
• Manage activities by using tasks.
• Share workspaces with others.
• Manage Outlook data files.

Prerequisites

• Outlook 2016 - Part 1