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.
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.