Microsoft Excel 2013 Basics: Excel 2013 Course for Beginners
4.6 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,457 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 Basics: Excel 2013 Course for Beginners to your Wishlist.

Add to Wishlist

Microsoft Excel 2013 Basics: Excel 2013 Course for Beginners

Use Microsoft Excel 2013 Basics: Excel 2013 Course for Beginners to excel at the most oft used features of Excel 2013
4.6 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,457 students enrolled
Created by Brian Jackson
Last updated 3/2017
English
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create simple Excel spreadsheets
  • Use Excel to produce charts and graphs
  • Format Excel reports for printing
View Curriculum
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 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

In the following section you'll learn more advanced techniques which you can use to make your spreadsheets shine:

  • 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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 28 Lectures Collapse All 28 Lectures 02:53:42
+
Introduction
3 Lectures 08:39

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:13
+
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.

Simple Sample Baseball Spreadsheet
08:37
+
More Advanced Functionality
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
About the Instructor
Brian Jackson
4.4 Average rating
2,347 Reviews
48,808 Students
32 Courses
Author/Publisher 32 Courses, 2330+ Reviews, 48,675+ Students

Born in Los Angeles, California, in the middle of the last century, I have always wanted to be a writer. After twenty-five some odd years spent working in the computer industry in the heart of the Silicon Valley, first for Lockheed as a Systems Programmer and later for Cisco Systems as a test tool developer, I managed to retire early and begin my next career as a self-published author.

Along with writing and publishing my own novels I also publish the works of my wife, Melanie Jackson. During the past four years I’ve published well over 100 books in paperback and eBook formats. Oddly enough this includes eBooks on how to self-publish books and how to create professional looking book covers using the GIMP. I’ve also recorded and distributed a pair of audiobooks available for purchase on Amazon and Audible. Finally, I spend a portion of my time maintaining both my website and my wife’s website, which was developed using WordPress.

My latest endeavor, begun in July of 2014, is to record training courses for distribution via Udemy. My goal is to provide low cost high quality screen cast based educational material focusing on my area of expertise; namely, self-publishing and book cover design using the GIMP. As time permits, I plan to expand my catalog to cover Web page development and Udemy course preparation.

I currently live in the beautiful California wine country with my wife, published author Melanie Jackson, and Butterscotch the cat.