Excel 2013 Basics for Business

Start up guide to creating powerful Excel 2013 spreadsheets for data analysis in a business setting.
3.2 (3 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.
19 students enrolled
$20
Take This Course
  • Lectures 23
  • Contents Video: 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • 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 8/2014 English

Course Description

I have been using Excel for over twenty years. In that time, I have seen a lot of changes to the appearance of the program, as well as improvements to how the program itself functions.

In this course, students will learn how to create a basic spreadsheet in Excel 2013. We will create a live example to demonstrate the functionality of Excel. This course focuses on the basics of Excel, including formatting, data analysis, and common formulae.

The course is approximately 75 minutes long and includes a combination of presentation slides and live examples. I create a spreadsheet in real time so that the student can see how easy it can be.

You should take this course if you want to become familiar with the functionality in Excel 2013. This course can serve as a great introduction or a refresher to using Excel.

What are the requirements?

  • There are no pre-requisites to this course. I highly recommend that you have access to Excel 2013.

What am I going to get from this course?

  • By the end of this course, you will be able to create, edit, and properly format Excel spreadsheets.
  • You will be introduced to business analysis in this course, at a high level.

What is the target audience?

  • This course is intended for people in business who would like to learn how to use the power of Excel to analyze their data.

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
Introduction
Preview
02:28
Section 2: Quick Tour of Excel
Quick Tour of Excel
Preview
07:52
How to Name and Save Workbooks and Worksheets
02:25
Basics of Text Formatting
06:48
Entering Data
05:00
Section 3: Excel Features
Assign Cell Formats
04:23
Autofill Data in Sequence
02:49
Section 4: Excel Functions (formulae)
Calculating Totals with AutoSum
03:06
Averages, Minimum, and Maximum Values
04:26
Absolute Referencing
03:16
Essential Formulae
09:15
Section 5: Navigation
Freezing Columns and Rows
03:38
Navigation Shortcuts
01:47
Advanced Formatting - merge and center
02:25
Section 6: Advanced Features
Best Practices for Spreadsheets
06:04
Copying and Moving Spreadsheets
02:55
Introduction to Charts
02:23
Adding Comments
01:35
Sorting
01:33
Filtering
02:34
Formatting for Printing
03:04
Pivot Tables
05:02
Section 7: Conclusion
Conclusion
00:36

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jeff Borschowa, Growth Strategist

I have been in the accounting industry for over 20 years. In that time, I have pursued every opportunity to advance my knowledge in the field of practice management and technology. The result is a unique combination, someone with the ability to interpret accounting and technology and translate the two into everyday language.

I provide training and consultation for accounting firms and bookkeeping businesses that are specifically looking to grow.

Ready to start learning?
Take This Course