Excel 2019: Beginner to Expert – 75 lessons – Easy English

Excel 2019: Beginner to Expert – 75 lessons – Easy English, available at $59.99, has an average rating of 4.35, with 75 lectures, 12 quizzes, based on 259 reviews, and has 5634 subscribers.

You will learn about Use the most popular and needed Excel skills for employment. Easily learn VLOOKUP Master Pivot Tables Create and run macros to automate work Use powerful functions and create custom formulas the easy way Format your data to look very professional Easily separate and combine data Prepare worksheets for printing Create shapes like banners and arrows This course is ideal for individuals who are Excellent course for English as a Second Language (ESL) or Anyone who wants to learn Excel the fastest and easiest way. or Anyone looking to get a better job with Excel skills It is particularly useful for Excellent course for English as a Second Language (ESL) or Anyone who wants to learn Excel the fastest and easiest way. or Anyone looking to get a better job with Excel skills.

Enroll now: Excel 2019: Beginner to Expert – 75 lessons – Easy English

Summary

Title: Excel 2019: Beginner to Expert – 75 lessons – Easy English

Price: $59.99

Average Rating: 4.35

Number of Lectures: 75

Number of Quizzes: 12

Number of Published Lectures: 75

Number of Published Quizzes: 12

Number of Curriculum Items: 87

Number of Published Curriculum Objects: 87

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Use the most popular and needed Excel skills for employment.
Easily learn VLOOKUP
Master Pivot Tables
Create and run macros to automate work
Use powerful functions and create custom formulas the easy way
Format your data to look very professional
Easily separate and combine data
Prepare worksheets for printing
Create shapes like banners and arrows

Who Should Attend

Excellent course for English as a Second Language (ESL)
Anyone who wants to learn Excel the fastest and easiest way.
Anyone looking to get a better job with Excel skills

Target Audiences

Excellent course for English as a Second Language (ESL)
Anyone who wants to learn Excel the fastest and easiest way.
Anyone looking to get a better job with Excel skills

Office 365: Complete Excel Course

This Microsoft Excel course is up to date with all the latest features and enhancements. However it works great with 2019, 2013 and 2010 versions as well.

Enroll now to get over 9 hours and 75 lessons of professional training!

Comfortable pace and easy English. Great for ESL.

Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration.

Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course.

When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel:

Create attractive and effective spreadsheets
Sort and format large sets of data
Create and format tables quickly
Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others
Create dynamic Pivot Tables and Pivot Charts
Automate your tasks with Macros
Secure workbooks and worksheets
Use conditional formatting to highlight data

Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future!

Course Curriculum

Chapter 1: Getting Familiar with Excel

Lecture 1: Using the exercise files

Lecture 2: Introducing Excel

Lecture 3: Using the Menu System

Lecture 4: Using the Quick Access Toolbar

Lecture 5: Understanding Workbooks and Worksheets

Lecture 6: Using the Formula Bar

Lecture 7: Using the Status Bar

Lecture 8: Using Navigation Tools

Lecture 9: Using Short Cut Menus and the Mini Toolbar

Lecture 10: Using Excel help

Chapter 2: Entering Data In Excel

Lecture 1: Exploring data entry and editting techniques

Lecture 2: Entering Data with Autofill

Lecture 3: Working with dates and time.

Lecture 4: Using Redo and Undo

Lecture 5: Adding Comments

Chapter 3: Creating Formulas and Functions

Lecture 1: Creating your first Formulas and Functions

Lecture 2: Copying a formula into an adjacent cell

Lecture 3: Calculating year to date totals

Lecture 4: Creating a percent change formula

Lecture 5: Working with absolute and relative references

Lecture 6: Autosum and Auto Average

Lecture 7: Other popular Excel functions

Chapter 4: Formating Data and Text

Lecture 1: Fonts and Styles

Lecture 2: Adjusting columns and rows

Lecture 3: Align and merge

Lecture 4: Creating Borders

Lecture 5: Numeric and special formatting

Lecture 6: Conditional Formating

Lecture 7: Creating Tables

Lecture 8: Inserting shapes

Chapter 5: Layout Features

Lecture 1: Add and delete columns and rows

Lecture 2: Hide and unhide rows and columns

Lecture 3: Moving, copying, and inserting data

Lecture 4: Find and replace

Chapter 6: Preparing worksheets for printing

Lecture 1: Page layout view

Lecture 2: Page break preview

Lecture 3: Page setup

Chapter 7: Creating Charts

Lecture 1: Creating charts from data

Lecture 2: Chart types

Lecture 3: Formatting charts and chart elements

Lecture 4: Inserting sparklines

Chapter 8: View options

Lecture 1: Freezing and unfreezing panes

Lecture 2: Splitting screens

Lecture 3: Outlining

Chapter 9: View multiple workbooks and worksheets

Lecture 1: Working with multiple worksheets and workbooks

Lecture 2: Working with sheets

Lecture 3: Linking worksheets and workbooks with formulas

Chapter 10: IF Functions and VLookup

Lecture 1: If Functions and VLookup

Lecture 2: Lookup Approximate

Lecture 3: Lookup Exact with function assistance

Lecture 4: IF family of functions

Chapter 11: Security features

Lecture 1: Securing workbooks and hiding tabs

Lecture 2: Securing workbooks

Chapter 12: Managing Data

Lecture 1: Sorting Data

Lecture 2: Insert Subtotals

Lecture 3: Using Filters

Lecture 4: Splitting text

Lecture 5: Splitting and combining with Flash Fill

Lecture 6: Deleting duplicates

Lecture 7: Data validation tools

Chapter 13: Analyzing Data

Lecture 1: Using Goal Seek

Lecture 2: Using Solver

Lecture 3: Using Scenario Manager

Lecture 4: Creating Data Tables

Chapter 14: Pivot Tables and Charts

Lecture 1: Creating Pivot Tables

Lecture 2: Manipulating Pivot Tables

Lecture 3: Group by Date

Lecture 4: Groupings in Pivot Tables

Lecture 5: Pivot Table Slicers

Lecture 6: Pivot Charts

Chapter 15: Macro Basics

Lecture 1: Macro Basics

Chapter 16: Advanced Tips and Shortcuts

Lecture 1: Finding Formulas

Instructors

Tim Wright
Nationally Recognized Instructional Designer

Rating Distribution

1 stars: 1 votes
2 stars: 2 votes
3 stars: 26 votes
4 stars: 104 votes
5 stars: 126 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