Microsoft Excel - Up to Speed
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled

Microsoft Excel - Up to Speed

Learn Microsoft Excel with Bite-Sized Step-by-Step videos
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled
Created by Roger Hyttinen
Last updated 5/2020
English
English [Auto]
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Microsoft Excel application
Requirements
  • Familiar with the Windows Operating System
Description

Welcome to Microsoft Excel - Up To Speed:


This course helps you to get up and running quickly with the latest version of Microsoft’s powerful spreadsheet application. This handy step-by-step class starts from scratch, starting with basic topics and moving on to more advanced features of the application, designed to help you to become more productive more quickly.


In no time at all you’ll be navigating the Microsoft Excel interface, creating spreadsheets, entering data, working with ranges, formulas and functions, and modifying workbooks. You’ll also learn how to filter your data using a variety of methods, as well as how to sort your worksheets my one or more columns. You’ll work with tables and charts and you’ll learn how to insert a variety of different graphics into your Excel documents. You’ll learn about macros and how they can help to automate those tasks that you perform often and you’ll work with some of Excel’s advanced data analysis tools to analyze your data. Additionally, you’ll learn how to import data from other applications into Excel and how to export your Access data to other applications. You’ll end by managing your workbooks using Excel’s various tools.


Who is this course for?

This course was created for people new to spreadsheets as well as those experienced in Excel who are looking to polish their Excel skills and learn some of the more advanced features of the application. This course will also be helpful for those coming from a previous version of Microsoft Excel or those looking to delve more deeply into the Excel application.

What does this course include?

·Bite-sized step-by-step instructional videos that are easy to follow

· Downloadable lesson files allowing you to follow along with the instructor

· Support for any questions you may have

What You’ll Learn:

The Basics. We’ll begin by creating a new Microsoft Excel workbook and then take a look at the Excel environment. You’ll set Excel options, learn how to navigate the Excel window, how to open an existing Excel workbook and how to move between worksheets and workbooks. You’ll learn about the different views in Excel and you’ll learn how to obtain help when necessary.

Working with Data. You’ll start by entering in text, numbers and simple formulas. You’ll learn about cell ranges and how to select them manually. You’ll discover how to total a range of cells using AutoSum and how to change & delete existing data in your spreadsheets. You’ll also learn how to find and replace data in your worksheets, how to spellcheck your data and how to insert special symbols.

Editing a Worksheet. In this section, we’ll begin the editing process. You’ll begin by working with ranges, copying and pasting data and using the Microsoft Office clipboard. You learn several different methods of cutting, copying and moving data in your workbooks. You’ll then modify your worksheets by changing column width, changing row height and inserting and deleting rows and columns.

Formatting a Worksheet. In this lesson, you’ll learn how to format text and values in your worksheets. You’ll align data within cells, merge cells and center text as well as wrap text with a cell. You’ll also learn how to add and modify cell borders, and apply colors, shading and styles to cells. You’ll discover how to hide unhide, freeze and unfreeze rows and as well as how to insert and remove page breaks.

Page Setup and Printing. Next, we learn how to prepare your spreadsheets for printing and send them to your printer. You’ll adjust margins, set page orientation, set paper sized and define a specific range for printing. You’ll learn how to insert headers and footers as well as how to fit a worksheet to print on a specific number of pages.

Formulas and Functions. Now we begin working more in-depth with formulas and functions. You work with relative, absolute and mixed references. You’ll learn how to copy formulas as well as work with aggregate functions such as MIN, MAX, COUNT and AVERAGE. We’ll finish by taking a look at how the Insert Function button works.

Modifying Workbooks. Next, we’ll begin physically modifying your workbooks. You’ll learn how to add and delete worksheets, copy, rename and position worksheets and group worksheets together so you can work on them as one unit. Additionally, you’ll discover how to change worksheet tab colors and how to use 3-D formulas and references.

Working with Tables. Now we begin working with Tables in Excel. You’ll learn how to create a table, enter data into a table and how to delete rows and columns from a table. We’ll take a look at how to format tables, total data in tables as well as how to sort table data by one or more columns. Using filters, you’ll learn how to display only specific table data. You’ll also learn how to convert a table back to a range, should you so choose.

Working with Charts. Now we move on and begin working with Excel charts. You’ll begin by creating, moving, and resizing charts. You change the chart layout and apply a style to your charts. Then, you’ll learn how to label and format chart elements and text. You’ll look at how to hide gridlines, customize axes and change the chart type. We’ll take a look at some of the different chart types you can use, such as pie charts, map charts and funnel charts. You’ll learn how to change a chart’s source data, create a chart template as well as move a chart to a different workbook.

Working with Graphics. We now begin working with graphics. You’ll begin by adding images from your computer into your spreadsheets and then move on to inserting online images, shapes, icons, and various 3-D shapes. You’ll then learn how to modify and format drawing objects and shapes. Additionally, you’ll work with adding organization charts, SmartArt and WordArt into your worksheets. You’ll then finish by adding hand drawings, simple equations and complex equations to your Excel documents.

Workgroup Collaboration. In this lesson, you’ll work with others by emailing workbooks, previewing and saving your workbooks as webpages and inserting hyperlinks into your worksheets. You’ll also learn how to view, edit and manage comments.

Financial & Logical Functions. In this section, we begin delving deeper into some of Excel’s more advanced functions. We’ll work with the IF function, nested functions, the IFS function, PMT function, and the FV function. You’ll also learn how to perform on-the-fly calculations using the AutoCalculate feature.

Date & Time Functions. In this lesson, we’ll work with some of the more common date and time functions. You’ll learn how various date/time functions. You’ll look at how to add a date and a date interval, how to subtract dates and even how to calculate time intervals.

Managing Workbooks. In this section, we’ll begin working with Excel templates. You’ll learn how to create a new workbook based on a template. You then create your own template and learn how to make changes to an existing template. Additionally, you’ll discover how to show and hide various workbook elements, how to compare two workbooks side-by-side and how to create a workspace. You’ll also learn how to save a workbook in a different file format and how to consolidate data from several different worksheets.

Importing & Exporting Data. Next, we’ll begin working with importing external data into Excel. You’ll bring data from text files and databases into Excel and, when necessary, convert text to columns. You’ll learn how to remove duplicate rows of data, how to link to another file and all about linking and embedding objects into your Excel files. You’ll also learn how to export data from Excel into different file formats. We’ll even take a look at exporting your Excel workbooks into webpages.

Formatting Numbers. In this section, we delve more deeply into formatting numbers. We’ll look at creating your own custom number formats as well as how to use conditional number formatting. You’ll learn how to apply conditional formatting based on top/bottom rules, how to apply specialized conditional formatting, and how to create your own conditional formatting rules. You’ll then manage the conditional formatting in your document as well as remove it from your worksheets.

Working with Ranges. In this section, we’ll delve into some of the more advanced aspects of ranges. Here, you’ll learn how to name a range, how to use a named range in formulas and function and how to manage the named ranges in your workbook. You’ll also work with the VLOOKUP function to look up data from a table array.

Work with Macros. In this lesson, you’ll learn how to automate tasks that you perform often by using macros. You’ll learn how to create, run and edit macros and well as how to save and open workbooks that contain macros. We’ll finish by learning how to add a macro to the Quick Access Toolbar for easy access.

Data Analysis. In this section, we begin working with some of Excel’s data analysis tools. You’ll learn how to trace formula precedents and cell dependents, how to trace and fix errors and how to error check a worksheet. Then, you’ll learn how to create PivotTables to analyze your data in a variety of different ways. You’ll rearrange your PivotTable, set PivotTable options, use Slicers to filter a PivotTable as well as learn how to filter a PivotTable inline. You’ll also create custom PivotTable filters and filter PivotTable data using Timelines. We’ll conclude this section be creating a PivotChart.

Summarizing Data. Now it’s time to begin working with data summary features of Excel. You’ll learn how to create subtotals, nest subtotals and apply advanced filters to your data. You’ll also add group and outline criteria to your data ranges and check the validity of your data by using data validation. We’ll finish off this section by learning how to preview your data using Excel’s Quick Analysis feature.

Analyze your Data. In this section, we look at a couple of different tools for analyzing your data. We begin working with Goal Seek and then Solver to find an ideal solution. We then work with the Scenario Manager to create and save several versions of your worksheet, enabling you to see how changing one or more of your worksheet’s values affects the other values in the worksheet. We then work with Data Tables, which allow you to see how changing certain values in your formulas affects the results. We then conclude this lesson by learning how to forecast future values using the Forecast Sheet feature.

Managing Shared Workbooks. We’ll finish off the course by learning how to maintain and optimize your workbooks for sharing with others. We’ll start by learning how to lock and unlock cells in a worksheet so you can apply protection to the worksheet. You then protect the worksheet and learn how to show and hide formulas. You’ll also work with protecting workbooks, password protecting workbooks and marking a workbook as final. To ensure optimal compatibility, you’ll learn how to inspect workbooks, check document compatibility and accessibility, and finally, how to coauthor and share an Excel workbook.


My Promise to You!

I'll be here for you every step of the way so if you have any questions at all that come up as you’re working through the course, please let me know. Feel free to post your question in the course or send me an email.

I want to ensure that this is the best course on how to use Microsoft Excel so if you have any suggestions on how I can improve the course and make it better, please let me know.

Are you ready to begin your Microsoft Excel journey? Then, click the enroll icon and let’s get started!

- Roger

Who this course is for:
  • Beginner to Advanced
Course content
Expand all 183 lectures 10:14:50
+ Excel Basics
11 lectures 39:19
Examining the Excel Environment
09:26
Opening an Existing Workbook
06:02
Changing the Save Format
01:33
Moving Between Workbooks
01:45
Setting Excel Options
01:59
Switching Between Views
02:03
Using Tell Me to Obtain Help
03:14
Closing and Exiting Excel
02:16
+ Lesson 2 - Working with Data
10 lectures 32:31
Entering Text and Numbers
05:19
Entering Simple Formulas
06:14
Using AutoSum
03:08
Changing and Deleting Data
03:35
Using Undo and Redo
02:28
Using Find and Replace
02:39
Using the Go To Command
02:00
Inserting Symbols
02:26
Spell Checking Your Worksheet
02:36
Using Smart Lookup
02:06
+ Lesson 3 - Editing a Worksheet
10 lectures 32:53
Working with Ranges
04:16
Copying and Pasting Data
04:04
Using the Office Clipboard
03:09
Cutting and Pasting Data
01:49
Copying & Moving Cells using Drag-and-Drop
02:02
Changing Column Width
04:13
Change Row Height
01:39
Inserting and Removing Rows & Columns
04:30
Copying Data and Formulas with AutoFill
04:41
Filling in Cells using Flash Fill
02:30
+ Lesson 4 - Formatting a Worksheet
12 lectures 39:06
Formatting Text
05:55
Using the Format Cells Dialog
02:11
Formatting Values
04:37
Using Format Painter
02:01
Alignment and Text Wrapping
04:30
Merging Cells & Centering Text
01:48
Adding Cell Borders
02:24
Applying Colors and Shading to Cells
02:11
Apply Cell Styles
04:39
Hiding and Unhiding Rows and Columns
02:19
Freezing and Unfreezing Rows and Columns
02:13
Inserting and Removing Page Breaks
04:18
+ Lesson 5 - Page Setup and Printing
8 lectures 23:41
Adjusting Margins
02:52
Setting Page Orientaiton
01:42
Setting Paper Size
02:00
Defining a Print Area
02:05
Printing Worksheet Titles
03:06
Forcing a Worksheet to Fit
02:45
Inserting Headers & Footers
06:11
Printing a Worksheet
03:00
+ Lesson 6 - Formulas and Functions
6 lectures 18:31
Relative References
02:59
Absolute References
02:42
Mixed References
02:47
Copying Formulas
01:33
Additional Aggregate Functions
03:45
The Insert Function Button
04:45
+ Lesson 7 - Modifying Workbooks
7 lectures 20:47
Adding and Deleting Worksheets
03:20
Copying Worksheets
02:56
Renaming Worksheets
02:07
Repositioning Worksheets
01:28
Grouping Worksheets
03:03
Changing Worksheet Tab Colors
02:09
Using 3-D Formulas and References
05:44
+ Lesson 8 - Working with Tables
9 lectures 25:12
Working with Tables
04:08
Entering Data into a Table
02:22
Deleting Rows and Columns
01:44
Formatting a Table
03:09
Totaling Data in a Table
01:37
Sorting Data in a Table
04:01
Filtering Data using AutoFilter
03:17
Creating Custom Filters
03:26
Converting a Table to a Range
01:28
+ Lesson 9 - Working with Charts
16 lectures 56:10
Creating a Chart
05:40
Changing the Layout and Style
03:15
Labeling Chart Elements
04:58
Formatting Chart Text
04:15
Formatting Chart Elements
05:49
Changing Chart Type
02:10
Showing or Hiding Gridlines
02:33
Customizing Axes
04:26
Creating a Pie Chart
03:42
Creating a Map Chart
03:04
Creating a Funnel Chart
02:16
Changing a Chart's Source Data
02:46
Moving a Chart to a Different Worksheet
02:08
Saving a Chart Template
03:06
Filtering Chart Data
01:37
Using Sparklines
04:25
+ Lesson 10 - Working with Graphics
14 lectures 49:12
Adding Pictures
02:43
Inserting Online Images
03:17
Adding Shapes
03:58
Adding Icons
04:12
Adding 3-D Models
05:18
Formatting Drawing Objects
04:06
Inserting WordArt
04:10
Inserting SmartArt
05:36
Inserting an Organization Chart
03:07
Modifying an Organization Chart
02:58
Taking a Screen Shot
02:39
Using Drawing Tools
02:19
Drawing Simple Math Equations
01:54
Generating Complex Equations
02:55