Introduction to Microsoft Excel 365

Learn to use Microsoft Excel for college or the office, including absolute cell references, IF, VLOOKUP and PivotTables.

Learn Microsoft Excel with this training course consisting of 3.5 hours, 5 chapters, and over 100 brief, skill specific videos.

What you’ll learn

  • Build a solid understanding of the Microsoft Excel basics and advanced functionality.
  • Learn how Excel actually works for use in the office or the classroom.
  • Learn Excel from scratch or fill in the gaps to become immediately confident.
  • Access a Computing Professor with 10+ years of teaching.

Course Content

  • Introduction –> 1 lecture • 3min.
  • Getting Started with Excel –> 21 lectures • 48min.
  • Formatting Cells –> 22 lectures • 34min.
  • Using Formulas and Functions –> 20 lectures • 1hr 2min.
  • Formatting Worksheets and Managing the Workbook –> 22 lectures • 32min.
  • Adding Charts and Analyzing Data –> 22 lectures • 44min.

Introduction to Microsoft Excel 365

Requirements

  • Browse the internet.
  • Download and open files.

Learn Microsoft Excel with this training course consisting of 3.5 hours, 5 chapters, and over 100 brief, skill specific videos.

During this introductory course on using Microsoft Excel 365, we’ll teach the basics of using Microsoft Excel.

Your instructor will walk you through Excel’s features, starting with the basics, then formatting cells, using functions and formulas, adding charts and analyzing data. The course contains over 100 brief and strategic videos that teach specific skills for college students and professionals.

 

Chapters included with this course:

Getting Started with Excel

This chapter provides you with the basic skills necessary to start working with Excel. The first step is to become familiar with the Excel interface and learn how to navigate a workbook. Next, you’ll learn to to enter data and apply simple formats. You’ll learn about charts and the building blocks for basic formulas, functions, absolute and relative cell references. Pay close attention to the concept of relative and absolute cell references. To help you start using Excel for your own purposes, you will learn how to create a workbook from a template and manage multiple workbooks.

Formatting Cells

This chapter focuses on skilling for working with cells and cell ranges. You will learn to move data – to insert, delete and merge cells. This chapter also covers conditional formatting to enhance a workbook and make the data easier to understand.

Using Formulas and Functions

It’s time to go beyond simple formulas. In this chapter you will learn to use functions built into Excel to compute statistics, insert dates, modify text, work with logical expressions, compute loan payments and perform table lookups. You will also create formulas that reference named ranges and learn essential troubleshooting skills.

Formatting Worksheets and Managing the Workbook

As Excel projects get bigger and more complicated, more formatting skills are required. In this chapter you will learn how to manage the organization and appearance of worksheets for optimal display on-screen and when printed.

Adding Charts and Analyzing Data

This chapter introduces data analysis. You will learn to use charts to visualize data; to use tables and PivotTables to quickly sort, filter and summarize data. You will conduce what-if analysis using data tables and goal seek.