Computers & Technology   

This course builds on the foundational and intermediate knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 and Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

You will:

• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.

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. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. 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.

In this course, you will learn fundamental Excel skills. You will:

• Familiarize yourself with Excel's layout, its various parts, its commands, and its terminology.
• Outline Excel's abilities to quickly, efficiently, and accurately calculate data.
• Update worksheets without throwing away all of the valuable work you've already done.
• Format a worksheet and organize your data.
• Print workbooks.
• Manage the overall structure of your workbooks.

This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

You will:

• Work with functions.
• Work with lists.
• Analyze data.
• Visualize data with charts.
• Use PivotTables and PivotCharts.

This course builds on the foundational and intermediate knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 and Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

You will:

• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.

Unlock the full potential of productivity by exploring Google Workspace! With its powerful suite of tools—like Gmail, Docs, Sheets, and Drive—you can collaborate, create, and stay organized seamlessly, whether you're working solo or as a team.

In this course, you will use the various apps included in Google Workspace to work productively. You will:

• Navigate the Google Workspace environment and use Gmail to send and manage email correspondence
• Manage schedules using Google Calendar
• Communicate with colleagues over text, voice, and video using Google Chat and Google Meet
• Store and share files using Google Drive
• Collaborate on documents using Google Docs, Google Slides, and Google Keep
• Collaborate on data using Google Sheets and Google Forms
• Collaborate on websites using Google Sites

Unlock the full potential of productivity by exploring Google Workspace! With its powerful suite of tools—like Gmail, Docs, Sheets, and Drive—you can collaborate, create, and stay organized seamlessly, whether you're working solo or as a team.

In this course, you will use the various apps included in Google Workspace to work productively. You will:

• Navigate the Google Workspace environment and use Gmail to send and manage email correspondence
• Manage schedules using Google Calendar
• Communicate with colleagues over text, voice, and video using Google Chat and Google Meet
• Store and share files using Google Drive
• Collaborate on documents using Google Docs, Google Slides, and Google Keep
• Collaborate on data using Google Sheets and Google Forms
• Collaborate on websites using Google Sites

Unlock the full potential of productivity by exploring Google Workspace! With its powerful suite of tools—like Gmail, Docs, Sheets, and Drive—you can collaborate, create, and stay organized seamlessly, whether you're working solo or as a team.

In this course, you will use the various apps included in Google Workspace to work productively. You will:

• Navigate the Google Workspace environment and use Gmail to send and manage email correspondence
• Manage schedules using Google Calendar
• Communicate with colleagues over text, voice, and video using Google Chat and Google Meet
• Store and share files using Google Drive
• Collaborate on documents using Google Docs, Google Slides, and Google Keep
• Collaborate on data using Google Sheets and Google Forms
• Collaborate on websites using Google Sites