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.8 (26 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.
3,685 students enrolled
$19
$95
80% off
Take This Course
  • Lectures 27
  • Length 2.5 hours
  • Skill Level Beginner Level
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English Closed captions available

Course 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

What are the requirements?

  • You should already have purchased and installed Excel 2013 for Windows

What am I going to get from this course?

  • Create simple Excel spreadsheets
  • Use Excel to produce charts and graphs
  • Format Excel reports for printing

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:31

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

05:55

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

Article

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

Section 2: Basic Functionality
08:09

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.

05:52

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

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.

06:01

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

08:19

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

05:15

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

08:37

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.

Section 3: More Advanced Functionality
03:23

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.

02:43

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.

03:16

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

11:53

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

01:20

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

03:03

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

08:34

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

09:40

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

IF and IFS Functions
07:46
Section 4: Sample Projects
19:56

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.

11:01

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.

Overview of my Udemy Review Tracker - 1/8/2016
11:53
Udemy Review Tracker - 1/8/2016
Article
Overview of My Udemy Course Progress Tracker
Preview
04:58
Udemy Course Progress Tracker Excel Spreadsheet
Preview
Article
Section 5: Conclusion
03:10

An overview of my other Udemy courses.

01:41

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Author/Publisher Brian Jackson, 26 Courses, 1,700+ Reviews, 4.60 Stars and 35,000+ Students

Born in Los Angeles 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.

Ready to start learning?
Take This Course