MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.88 GB | Duration: 3h 42m
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
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.
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.
Who this course is for:
Professionals who want to build on existing but incomplete knowledge
College students who want to succeed in their Excel classes
People who are curious about Excel
People who are starting a career in computing