Excel 2013 Basics for Business
3.6 (4 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.
21 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013 Basics for Business to your Wishlist.

Add to Wishlist

Excel 2013 Basics for Business

Start up guide to creating powerful Excel 2013 spreadsheets for data analysis in a business setting.
3.6 (4 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.
21 students enrolled
Created by Jeff Borschowa
Last updated 8/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • There are no pre-requisites to this course. I highly recommend that you have access to Excel 2013.
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
01:25:24
+
Introduction
1 Lecture 02:28
+
Quick Tour of Excel
4 Lectures 22:05

How to Name and Save Workbooks and Worksheets
02:25

Basics of Text Formatting
06:48

Entering Data
05:00
+
Excel Features
2 Lectures 07:12
Assign Cell Formats
04:23

Autofill Data in Sequence
02:49
+
Excel Functions (formulae)
4 Lectures 20:03
Calculating Totals with AutoSum
03:06

Averages, Minimum, and Maximum Values
04:26

Absolute Referencing
03:16

Essential Formulae
09:15
+
Navigation
3 Lectures 07:50
Freezing Columns and Rows
03:38

Navigation Shortcuts
01:47

Advanced Formatting - merge and center
02:25
+
Advanced Features
8 Lectures 25:10
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
+
Conclusion
1 Lecture 00:36
Conclusion
00:36
About the Instructor
Jeff Borschowa
4.0 Average rating
55 Reviews
4,407 Students
5 Courses
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.