Excel Essentials PC 2013
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
Wishlisted Wishlist

Please confirm that you want to add Excel Essentials PC 2013 to your Wishlist.

Add to Wishlist

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
Created by Excel Rain Man
Last updated 3/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • PC Excel 2013 (Office 365) and a working internet connection, so you can watch, download , learn and practice!!!
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!

Who is the target audience?
  • Beginners: We'll teach you Excel, and make you good!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 52 Lectures Collapse All 52 Lectures 07:13:44
+
Getting Started
7 Lectures 41:34

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

Preview 09:27

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

Preview 2 pages

Using Freeze Panes to efficiently view spreadsheets, Unfreeze Panes

Freeze Panes
04:04

Sorting Data Capabilities

Sorting
08:23

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

Filters
08:00

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

Paste Special
09:27
+
Formatting Tips
4 Lectures 42:39

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

Formatting Fonts
13:13

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

Formatting Alignment
08:59

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

Formatting Numbers
09:38

Enhancing reports with Conditional Formatting

Preview 10:49
+
Intro to Formulas
8 Lectures 57:32

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

Preview 06:29

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

Function Wizard
06:12

Utilizing absolute and relative references and partial absolute references

Absolute Referencing
07:23

Understanding named ranges and creating them to make spreadsheets more efficient

Named Ranges
11:34

Excel can detect and perform repetitive data entry or formatting

Flash Fill
05:56

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

More Functions 1
07:47

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

More Functions 2
06:39

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

More Functions 3
05:32
+
Intermediate Formulas
5 Lectures 44:51

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

IF and Nesting
14:55

Using many of Excel's text based functions

Text Functions
15:25

Parsing data using the TextToColumns feature

TextToColumns
06:03

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

Remove Duplicates
03:02

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

Preview 05:26
+
Tables, Validation, Other Tools
5 Lectures 47:25

Analytical tool including working formulas backwards!

Goal Seek
06:17

Creating Tables and features that Excel has added to this functionality

Working with Tables
13:30

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

Find and Replace
07:01

Slicers provide an excellent tool to visually detail applied filters

Slicers
05:58

Data Validation
14:39
+
PivotTables
5 Lectures 50:10

What is a PivotTable? Sample PivotTables…

Preview 03:01

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

Build Simple PivotTables
11:57

Utilizing Excels library of automatic formats for PivotTables

Formatting PivotTables
17:14

Useful ways for sorting and filtering in PivotTables

Manipulate PivotTables
13:54

Adding and removing subtotals and grand totals to rows in PivotTables

PivotTable Totals
04:04
+
Advanced PivotTables
6 Lectures 51:56

Adding multiple values or metrics to PivotTables

Multiple Data Points
07:45

Creating new metrics via a calculation in PivotTables

Calculated Fields
09:32

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

PivotTable Maintenance
08:23

PivotTables can be easily and more dynamically changed using Excel Slicers

Slicers
12:52

Creating dynamic charts linked to PivotTables to graphically display your data

PivotCharts
07:09

Comparing PivotTable or PivotChart data over different time periods

Timeline
06:15
+
Printing and Screen Settings
5 Lectures 34:29

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

Viewing Part 1
04:59

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

Viewing Part 2
05:16

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

Print Settings
10:24

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

Preview 05:45

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

Headers and Footers
08:05
+
Charting
7 Lectures 01:01:08

Building a chart reviewing a few basic options

Preview 10:35

Introduction to charting, examining charting options and utilizing them

Basic Charting
08:55

Formatting techniques and optimizing formatting to make your chart stand out

Formatting a Chart
15:38

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

Data Labels and Data Tables
06:26

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

Formatting the Y-Axis
07:02

Modifying the scale of the X axis plus additional options

Formatting the X-Axis
07:00

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

Sparklines
05:32
About the Instructor
Excel  Rain Man
4.4 Average rating
9 Reviews
159 Students
2 Courses
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>