Excel Essentials PC 2013

Learn Excel the FUN way! By working through exercises along with watching video tutorials.
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.
• 1 student enrolled
$19
$20
5% off
Take This Course
  • Lectures 52
  • Length 7 hours
  • 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/2015 English

Course Description

This course was designed to make people better in Excel by talking about things that confuse people every day (VLOOKUPs, PivotTables, printing things on one page). Not only do we teach you how to do all of theses wonderful features in Excel, we'll teach you why. With exercise workbooks that let you work EVERY single example we demonstrate so that you can actually learn how features work, we guarantee that you will feel more at ease with Excel when you're done with this course..

Happy Spreadsheeting!

What are the requirements?

  • PC Excel 2013 (Office 365) and a working internet connection, so you can watch, download , learn and practice!!!

What am I going to get from this course?

  • Teach people new to Excel how to use it well, and have fun with it.
  • Show Experienced users some new features and techniques to use that they have not experienced before

What is the target audience?

  • Beginners: We'll teach you Excel, and make you good!

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: Getting Started
Intro Video
Preview
02:13
09:27

Navigating through the Ribbon and finding everything you need in no time!

2 pages

Keyboard shortcuts and some of Excel Rain Man's go-to moves for PC spreadsheeters

04:04

Using Freeze Panes to efficiently view spreadsheets, Unfreeze Panes

08:23

Sorting Data Capabilities

08:00

Setting up Filters, Using Custom Filters, AutoFilters (Advanced Filtering Techniques)

09:27

Copy/Paste Refresher, Paste Special (Formulas, Values, Transpose)

Section 2: Formatting Tips
13:13

Formatting via the Font Section of the Home Tab and the Format Cells Dialog Box

08:59

Formatting via the Alignment Section of the Home Tab and the Format Cells Dialog Box

09:38

Formatting via the Number Section of the Home Tab and the Format Cells Dialog Box

10:49

Enhancing reports with Conditional Formatting

Section 3: Intro to Formulas
06:29

The basics... Entering formulas in Excel and copying them

06:12

Using Excel's function Wizard and the formulas ribbon to access an extensive library of predefined functions

07:23

Utilizing absolute and relative references and partial absolute references

11:34

Understanding named ranges and creating them to make spreadsheets more efficient

05:56

Excel can detect and perform repetitive data entry or formatting

07:47

Exploring more advanced functions and having criteria applied to sum, count and average functions

06:39

Exploring more advanced functions and having criteria applied to sum, count and average functions

05:32

Exploring more advanced functions and having criteria applied to sum, count and average functions

Section 4: Intermediate Formulas
14:55

Using the IF function to add logic to formulas and to nest functions ctions

15:25

Using many of Excel's text based functions

06:03

Parsing data using the TextToColumns feature

03:02

Creating a unique list of items from a column or table with many duplicates

05:26

Utilizing one of Excel's most valuable (and used) functions for looking up data

Section 5: Tables, Validation, Other Tools
06:17

Analytical tool including working formulas backwards!

13:30

Creating Tables and features that Excel has added to this functionality

07:01

Using one of Excels more basic tools, to help troubleshoot data

05:58

Slicers provide an excellent tool to visually detail applied filters

Data Validation
14:39
Section 6: PivotTables
03:01

What is a PivotTable? Sample PivotTables…

11:57

The basics... Learning how to build rudimentary PivotTables from Excel data

17:14

Utilizing Excels library of automatic formats for PivotTables

13:54

Useful ways for sorting and filtering in PivotTables

04:04

Adding and removing subtotals and grand totals to rows in PivotTables

Section 7: Advanced PivotTables
07:45

Adding multiple values or metrics to PivotTables

09:32

Creating new metrics via a calculation in PivotTables

08:23

Keeping PivotTables up to date with new data, or data from a different source

12:52

PivotTables can be easily and more dynamically changed using Excel Slicers

07:09

Creating dynamic charts linked to PivotTables to graphically display your data

06:15

Comparing PivotTable or PivotChart data over different time periods

Section 8: Printing and Screen Settings
04:59

Utilizing Excels different viewing elements including turning on and off gridlines and column headings

05:16

Utilizing Excels different viewing elements including turning on and off gridlines and column headings

10:24

Preparing a document to print by setting print area, adjusting page layouts, and printing titles, Inserting page breaks, addressing scaling and sizing issues

05:45

Use custom views to set up and save print and screen view settings g scaling and sizing issues

08:05

Adding headers and footers to print important information on each printed page of your workbook td>

Section 9: Charting
10:35

Building a chart reviewing a few basic options

08:55

Introduction to charting, examining charting options and utilizing them

15:38

Formatting techniques and optimizing formatting to make your chart stand out

06:26

Adding labels to chart data points and series to add emphasis to your presentation

07:02

Displaying the numbers in different units, using a logarithmic scale, other key options

07:00

Modifying the scale of the X axis plus additional options

05:32

Visual representations of data showing trends including low points and high points

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Excel Rain Man, Providing expertise in the art of Excel Spreadsheet Customization, Outsourcing & Education.

ExcelRainMan.com is designed to help users of every level with problems concerning Excel spreadsheets. Regardless of what industry you are in, most individuals at some point find themselves dealing with the utter aggravation of Microsoft Excel. As the Excel Rain Man Team, people can send us their spreadsheet related questions/problems and in turn, we bring our mad skills to solve whatever the issue may be. We also offer customized classes as well as video tutorials. Check us out at www.excelrainman.com.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /></font>

Ready to start learning?
Take This Course