Beginner Microsoft Excel 2013 / 2016 Data Analysis
4.3 (57 ratings)
5,737 students enrolled

# Beginner Microsoft Excel 2013 / 2016 Data Analysis

Beginner Microsoft Excel 2013 / 2016 training: Excel spreadsheet based data analysis using formulas
4.3 (57 ratings)
5,737 students enrolled
Created by Brian Jackson
Last updated 3/2017
English
English
Current price: \$13.99 Original price: \$19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 3 hours on-demand video
• 3 articles
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

What you'll learn
• Use Excel to produce charts and graphs
• Format Excel reports for printing
Requirements
• You should already have purchased and installed Excel 2013 for Windows
Description

Want to learn Excel but you're afraid you don't have the time?

Or maybe you're worried that Excel will be too complicated.

Then again, maybe you already tried but got bogged down wading through hours of detailed training material.

Learn Microsoft Excel 2013/2016 the Fast and Simple Way

Maybe it's time you tried the fast and simple approach to learning Excel... and do it all in under 2 1/2 hours.

Hi, my name is Brian Jackson and I'd like to teach you Excel the fast and simple way, by focusing on the features of the program most commonly used in simple spreadsheets. We'll begin with the basics:

• Starting, Stopping, Saving, Windows and Menus

• Assigning Values to Cells & Performing Arithmetic Operations

• Relative and Absolute Cell References and Ranges

• Common Math Functions: SUM, AVERAGE, MIN, MAX & COUNT

• Editing Columns, Rows and Cells

• Formatting Columns, Rows and Cells

That's all it takes is 6 lessons to learn the basics, then the section concludes with a super simple sample baseball spreadsheet.

Go Beyond the Basics to Add Some Polish

• Working with Worksheets and Workbooks

• Freezing Rows and Columns

• Functions

• Using Date Functions to Make Monthly Projections

• Sorting

• Conditional Formatting

• Charts and Graphs

• Formatting and Printing Reports

The course concludes with 2 sample projects in which we construct book revenue and Udemy review tracking spreadsheets.

Are You Finally Ready to Learn Excel?

If you're ready then come along with me and let me teach you Excel the fast and simple way...

---Brian

Who this course is for:
• This course is intended for those new to Excel
• This course is not appropriate for anyone possessing prior Excel knowledge
• This course demonstrates the use of Excel on Windows 8.1
Course content
Expand all 28 lectures 02:53:42
+ Introduction
3 lectures 08:41

This is an introduction to the course providing details on each of the lectures.

Preview 02:31

In the Life and Times of Brian Jackson I provide an overview of my life so far.

Preview 05:55

This is a downloadable Excel 2013 Workbook containing multiple worksheet examples taken from the course. Use this material to review course product results.

Sample Excel Workbook
00:15
+ Basic Functionality
7 lectures 48:05

In this lecture you'll learn to start and stop Excel and how to configure your Windows 8.1 environment for easy access to Excel. You'll also learn the elements of the Excel Window and Menus.

Starting, Stopping, Saving, Windows and Menus
08:09

In this lecture you'll begin entering values into the cells of a spreadsheet and enter arithmetic values.

Assigning Values to Cells & Performing Arithmetic Operations
05:52

In this lecture you'll learn how to refer to relative and absolute cell references and ranges in arithmetic operations and function calls.

Relative and Absolute Cell References and Ranges
05:52

In this lecture you'll learn to use the most common Excel functions required to perform everyday operations.

Common Math Functions: SUM, AVERAGE, MIN, MAX & COUNT
06:01

In this section you'll learn to copy, cut and paste cell contents in addition to inserting and deleting columns and rows.

Editing Columns, Rows and Cells
08:19

In this lecture you'll learn to format Excel spreadsheets to enhance their visual appeal and performance.

Formatting Columns, Rows and Cells
05:15

In this lecture you'll apply everything we've learned in this section to produce a simple baseball run tracker. Note that the spreadsheet created in this lecture is available for download as part of the Sample Excel Workbook referenced in the introduction.

08:37
9 lectures 51:38

In this lecture you'll learn how to add multiple worksheets (spreadsheets) to a single Excel workbook and how to reference cells in one spreadsheet from another.

Working with Worksheets and Workbooks
03:23

In this lecture you'll learn how to freeze columns and rows on the screen so that they do not scroll while the data of the spreadsheet does.

Freezing Rows and Columns
02:43

In this lecture you'll learn how to find functions to perform virtually any arithmetic calculation.

Functions
03:16

In this lecture I divolge my formula for projecting monthly sales figures for the month in progress.

Using Date Functions to Make Monthly Projections
11:53

In this lecture you'll learn how to sort the contents of a spreadsheet.

Sorting
01:20

In this lecture you'll learn to use conditional formatting to applying colors to cells to highlight the relative magnitude of related values.

Conditional Formatting
03:03

In this lecture you'll learn the basics of producing charts and graphs for inclusion in reports including Excel data.

Charts and Graphs
08:34

In this lecture you'll learn to beautify and print your Excel reports.

Formatting and Printing Reports
09:40
IF and IFS Functions
07:46
+ Sample Projects
6 lectures 48:16

In this lecture you'll produce a spreadsheet which can be used to track Amazon book sales while projecting monthly sales. Note that the spreadsheet created in this lecture is available for download as part of the Sample Excel Workbook referenced in the introduction.

Book Revenue Tracker
19:56

In this lecture you'll see how to create a Udemy review tracking tool as a further demonstration of the techniques contained in this course. Note that the spreadsheet created in this lecture is available for download as part of the Sample Excel Workbook referenced in the introduction.

Udemy Review Tracker
11:01
Overview of my Udemy Review Tracker - 1/8/2016
11:53
Udemy Review Tracker - 1/8/2016
00:24
+ Conclusion
3 lectures 17:01
Student Request: More on Formatting and Printing Reports
12:10

An overview of my other Udemy courses.

Where Do I Go From Here?
03:10

A short video demonstrating how easy it is to leave a review after completing a course.

How Do I Leave a Review?
01:41