Excel 2013 Essentials Crash Course

Learn 15 top Excel Skills and Essentials to quickly go from basics to pro user status in the shortest time possible.
0.0 (0 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.
16 students enrolled
$30
Take This Course
  • Lectures 12
  • Contents Video: 1 hour
  • Skill Level All Levels
  • 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 10/2014 English

Course Description

No need to spend weeks learning Excel. Look like a pro in the shortest time possible with 12 skill packed videos. This Crash Course in Microsoft Excel 2013 teaches 15 Essential Excel skills recognized by business users and managers world-wide plus additional bonus Excel Power User Skills, including keyboard shortcuts, pivot tables and formatting techniques to give you a professional edge. Add Excel skills to your resume to impress at interviews and satisfy employment requirements or use your new skills to increase office productivity and the way you analyze data. This is a Knowledge Content Course - Created and produced by Richard Bailey of Client by Design.

What are the requirements?

  • Install Microsoft Excel 2013
  • You should have knowledge of Microsoft Windows and Menu Navigation

What am I going to get from this course?

  • Look like and perform like an experienced Excel user
  • Master power user keyboard shortcuts to save time and blaze through spreadsheets with/without a mouse
  • Sum or Count cells, based on any criteria allowing you to generate quick reports and perform rapid data analysis
  • You will quickly master pivot tables to automatically sort, count totals and manipulate and recognize data patterns without disturbing your original spreadsheets
  • Write formulas with absolute and relative references
  • Create a drop down list of options in a cell to give users easier data entry and usability
  • Sort a list without affecting your data
  • Record and edit simple macros to automate complex and tedious tasks
  • Insert/Delete Columns and Rows to build, clean up and edit spreadsheets
  • Create visual charts using worksheet data
  • Apply conditional formatting based on formulas
  • Nest two or more functions in a formula to create really powerful calculations
  • Insert and protect worksheets to really present your data the way you want
  • Perform simple date and time arithmetic (days between dates) to allow counting and analysis based on durations and start end dates
  • Filter unique items from a list to focus only on what you need
  • Basic Spreadsheet formatting (how to make your spreadsheets look sharp and easy to read)
  • Printing sections of spreadsheets to print only what you need... when printing the entire report is unnecessary

What is the target audience?

  • This Excel Crash Course is for anyone looking to learn Excel essentials and skills without any previous knowledge. You can simply follow along and watch as each new technique is taught on screen. Knowledge of basic keyboarding is helpful, but not required.

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: Formatting and Organizing Data
04:54

Basic Spreadsheet formatting (how to make your spreadsheets look sharper and easy to read).

02:10

Sum or Count cells, based on any criteria allowing you to generate quick reports and perform rapid data analysis

02:35

You will quickly master pivot tables to automatically sort, count totals and manipulate and recognize data patterns without disturbing your original spreadsheets

Section 2: Manipulating and Analyzing Microsoft Excel Data
05:04

Write formulas with absolute and relative references to make calculations easier

02:06

Sort Excel data to view what you need the way you need it.

04:14

Create drop-down lists for faster, more reliable and consistent data entry.

06:35

Perform simple date and time arithmetic (days between dates) to allow counting and analysis based on durations and start end dates and learn how to insert and delete rows and columns.

03:57

Nest two or more functions in a formula to create really powerful calculations

Section 3: Automation and Presenting Your Data
04:03

Apply conditional formatting and data filtering based on formulas to make your data standout and easier to read.

04:46

Create visual charts using worksheet data

05:43

Create and edit simple macros to automate complex and tedious tasks

04:41

Protect, Move and Print sections of spreadsheets

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mr. Richard Bailey, Guerrila Marketing Coach, Instructor, Advisor, Technologist

Richard Bailey is a Certified Guerrilla Marketing Coach, Author and Technology developer. With vast experience in marketing, software and web development along with live and online/distance training, he creates learning content and applications for a variety of clients and subjects. His team of learning and knowledge experts can deliver training for a large range of business and technology centered topics through Client by Design, LLC's Knowledge Content Training Systems.

Ready to start learning?
Take This Course