Introduction to Microsoft Excel 365

Introduction to Microsoft Excel 365, available at $49.99, has an average rating of 4.45, with 108 lectures, based on 42 reviews, and has 113 subscribers.

You will learn about 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 This course is ideal for individuals who are Professionals who want to build on existing but incomplete knowledge or College students who want to succeed in their Excel classes or People who are curious about Excel or People who are starting a career in computing It is particularly useful for Professionals who want to build on existing but incomplete knowledge or College students who want to succeed in their Excel classes or People who are curious about Excel or People who are starting a career in computing.

Enroll now: Introduction to Microsoft Excel 365

Summary

Title: Introduction to Microsoft Excel 365

Price: $49.99

Average Rating: 4.45

Number of Lectures: 108

Number of Published Lectures: 108

Number of Curriculum Items: 108

Number of Published Curriculum Objects: 108

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to the Course

Chapter 2: Getting Started with Excel

Lecture 1: Excel Chapter 1 Overview

Lecture 2: Skill 1.1 Introduction to Excel

Lecture 3: Skill 1.2 Navigating a Workbook

Lecture 4: Skill 1.3 Working in Protected View

Lecture 5: Skill 1.4 Entering and Editing Text and Numbers in Cells

Lecture 6: Skill 1.5 Applying Number Formats

Lecture 7: Skill 1.6 Entering Dates and Applying Date Formats

Lecture 8: Skill 1.7 Inserting Data Using Autofill

Lecture 9: Skill 1.8 Exploring Charts

Lecture 10: Skill 1.9 Using the Recommended Charts Feature

Lecture 11: Skill 1.10 Entering Simple Formulas

Lecture 12: Skill 1.11 Understanding Absolute and Relative References

Lecture 13: Skill 1.12 Using Functions and Formulas

Lecture 14: Skill 1.13 Using AutoSum to Insert a SUM Function

Lecture 15: Skill 1.14 Calculating Total with the Quick Analysis Tool

Lecture 16: Skill 1.15 Using the Status Bar

Lecture 17: Skill 1.16 Changing the Zoom Level

Lecture 18: Skill 1.17 Creating a New Workbook Using a Template

Lecture 19: Skill 1.18 Arranging Workbooks

Lecture 20: Skill 1.19 Checking Spelling

Lecture 21: Skill 1.20 Previewing and Printing a Worksheet

Chapter 3: Formatting Cells

Lecture 1: Skill 2.1 Cutting, Copying and Pasting Cell Content

Lecture 2: Skill 2.2 Using Paste Options

Lecture 3: Skill 2.3 Inserting and Deleting Cells

Lecture 4: Skill 2.4 Wrapping Text in Cells

Lecture 5: Skill 2.5 Using Undo and Redo

Lecture 6: Skill 2.6 Aligning Cells

Lecture 7: Skill 2.7 Merging Cells and Splitting Merged Cells

Lecture 8: Skill 2.8 Applying Bold, Italic and Underline

Lecture 9: Skill 2.9 Changing Fonts, Font Size and Font Color

Lecture 10: Skill 2.10 Adding Borders

Lecture 11: Skill 2.11 Adding Shading with Fill Color

Lecture 12: Skill 2.12 Applying Cell Styles

Lecture 13: Skill 2.13 Using Format Painter

Lecture 14: Skill 2.14 Applying Conditional Formatting Using the Quick Analysis Tool

Lecture 15: Skill 2.15 Applying Conditional Formatting with Data Bars and Color Scales

Lecture 16: Skill 2.16 Applying Conditional Formatting with Highlight Cells Rule

Lecture 17: Skill 2.17 Applying Conditional Formatting with Top/Bottom Rules

Lecture 18: Skill 2.18 Removing Conditional Formatting

Lecture 19: Skill 2.19 Clearing Cell Content

Lecture 20: Skill 2.20 Using Find and Replace

Lecture 21: Skill 2.21 Replacing Formatting

Lecture 22: Skill 2.22 Setting and Clearing the Print Area

Chapter 4: Using Formulas and Functions

Lecture 1: Skill 3.1 Using the Function Arguments Dialog to Enter Functions

Lecture 2: Skill 3.2 Using Formula AutoComplete to Enter Functions

Lecture 3: Skill 3.3 Calculating Averages

Lecture 4: Skill 3.4 Finding Minimum and Maximum Values

Lecture 5: Skill 3.5 Using Date and Time Functions

Lecture 6: Skill 3.6 Creating Formulas Using Counting Functions

Lecture 7: Skill 3.7 Formatting Text Using Functions

Lecture 8: Skill 3.8 Using CONCAT to Combine Text

Lecture 9: Skill 3.9 Using TEXTJOIN to Combine Text

Lecture 10: Skill 3.10 Creating Formulas Referencing Data From Other Worksheets

Lecture 11: Skill 3.11 Naming Ranges of Cells

Lecture 12: Skill 3.12 Working with Named Ranges

Lecture 13: Skill 3.13 Updating Named Ranges with the Name Manager

Lecture 14: Skill 3.14 Editing and Deleting Names with the Name Manager

Lecture 15: Skill 3.15 Using the Logical Function IF

Lecture 16: Skill 3.16 Calculating Loan Payments Using the PMT Function

Lecture 17: Skill 3.17 Finding Data Using the Vlookup Function

Lecture 18: Skill 3.18 Checking Formula for Errors

Lecture 19: Skill 3.19 Finding Errors Using Trace Precedents and Trace Dependents

Lecture 20: Skill 3.20 Displaying and Printing Formulas

Chapter 5: Formatting Worksheets and Managing the Workbook

Lecture 1: Skill 4.1 Inserting Worksheets

Lecture 2: Skill 4.2 Naming Worksheets

Lecture 3: Skill 4.3 Changing the Color of Sheet Tabs

Lecture 4: Skill 4.4 Moving and Copying Worksheets

Lecture 5: Skill 4.5 Deleting Worksheets

Lecture 6: Skill 4.6 Grouping Worksheets

Lecture 7: Skill 4.7 Inserting and Deleting Rows and Columns

Lecture 8: Skill 4.8 Applying Themes

Lecture 9: Skill 4.9 Modifying Column Widths and Row Heights

Lecture 10: Skill 4.10 Freezing and Unfreezing Rows and Columns

Lecture 11: Skill 4.11 Hiding and Unhiding Rows and Columns

Lecture 12: Skill 4.12 Hiding and Unhiding Worksheets

Lecture 13: Skill 4.13 Splitting Workbooks

Lecture 14: Skill 4.14 Changing the Worksheet View

Lecture 15: Skill 4.15 Adding Headers and Footers

Lecture 16: Skill 4.16 Inserting Page Breaks

Lecture 17: Skill 4.17 Showing and Hiding Worksheet Elements

Lecture 18: Skill 4.18 Changing Worksheet Orientation

Lecture 19: Skill 4.19 Setting up Margins for Printing

Lecture 20: Skill 4.20 Scaling Worksheets for Printing

Lecture 21: Skill 4.21 Printing Titles

Lecture 22: Skill 4.22 Printing Selections, Worksheets and Workbooks

Chapter 6: Adding Charts and Analyzing Data

Lecture 1: Skill 5.1 Inserting a Column Chart or Bar Chart

Lecture 2: Skill 5.2 Inserting a Pie Chart

Lecture 3: Skill 5.3 Inserting a Line Chart

Lecture 4: Skill 5.4 Resizing and Moving Charts

Lecture 5: Skill 5.5 Applying Quick Layouts to Charts

Lecture 6: Skill 5.6 Showing and Hiding Chart Elements

Lecture 7: Skill 5.7 Applying Quick Styles and Colors to Charts

Lecture 8: Skill 5.8 Changing the Chart Type

Instructors

Maria Hamilton
Computing Professor

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 6 votes
4 stars: 12 votes
5 stars: 24 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu