Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel for Office 365/2019: Part 1

Provides a foundation for Excel knowledge and skills

Description

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Excel® can help.

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.

Course Outline

Lesson 1: Getting Started with Excel
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Navigate in Excel for the Web
  • Enter Cell Data
Lesson 2: Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
  • Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Colors, Borders, and Styles
  • Apply Basic Conditional Formatting
Lesson 5: Printing Workbooks
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers
Lesson 6: Managing Workbooks
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Prerequisites

Prior Course Recommendation: Using Microsoft Windows 10 or Using Microsoft Windows 11

Similar courses

Introduction to DAX for Power BI

Using Data Analysis Expressions to solve common business problems in Power BI

More Information
Microsoft Excel for Office 365/2019: Part 2

Start down the road to creating advanced workbooks and worksheets to help deepen understanding of organizational intelligence

More Information
Microsoft Excel for Office 365/2019: Part 3

Put the full power of Excel right at your fingertips: collaborate, automate, and use conditional logic to construct and apply elaborate formulas and functions

More Information
Microsoft Outlook for Office 365/2019: Part 2

Builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365/2019: Part 1 course and will help you customize a communication system well-suited to your work style

More Information
Microsoft Access 2019/2021: Part 2

Expand basic database management skills

More Information
Microsoft Word for Office 365/2019: Part 2

Tackle more advanced features of Word

More Information
Microsoft Power BI: Data Analysis Practitioner

Analyze business data, visualize insights, and share those insights across the enterprise

More Information
Microsoft Project 2019/2021: Part 2

This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment

More Information
Microsoft Project 2019/2021: Part 1

Use Microsoft Project effectively and efficiently in a real-world environment.

More Information
Microsoft Excel for Office 365/2021: Data Analysis with Power Pivot

Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data

More Information
Microsoft Excel for Office 365/2021: Data Analysis with PivotTables

Use the advanced PivotTable functionality in Excel to analyze your raw data

More Information
Microsoft PowerPoint for Office 365/2019: Part 2

Create presentations that not only stand out from the crowd, but also don't consume all of your available time

More Information
Microsoft PowerPoint for Office 365/2019: Part 1

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® PowerPoint® can help you do.

More Information
Microsoft SharePoint for Site Owners (Modern)

SharePoint provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location

More Information
Tableau Part 2

In this course, you will perform advanced data visualization and data blending with Tableau.

More Information
Microsoft Word for Office 365/2019: Part 3

Includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

More Information
Microsoft Word for Office 365/2019: Part 1

You will learn fundamental Word skills

More Information
Microsoft Outlook for Office 365/2019: Part 1

Use Outlook to compose and handle your email communications and to manage your calendar, contacts, and tasks.

More Information
Adobe Photoshop CC - Part 1

This course will prepare you to use the most common basic features of Adobe Photoshop

More Information
Microsoft Access 2019/2021: Part 1

Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

More Information
Adobe Acrobat Pro DC: Introduction

This course is for individuals who are new to Adobe Acrobat Pro DC, but need to create and share PDF files and PDF portfolios

More Information
PL-400T00 Microsoft Power Platform Developer

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes.

More Information
Adobe Illustrator CC - Part 1

Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text.

More Information
Adobe InDesign CC: Part 1

In this course, you will use Adobe InDesign to create and deliver professional looking printed and interactive documents.

More Information
Formatting Technical Documents

Work with formatting options such as styles and section breaks to automate and troubleshoot document content including table of contents, list of figures, and more.

More Information

Press enter to see more results