Mastering Excel 2010
3.0 (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.
26 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering Excel 2010 to your Wishlist.

Add to Wishlist

Mastering Excel 2010

Learn Everything You'd Want To Know About Microsoft Excel
3.0 (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.
26 students enrolled
Created by Chip Reaves
Last updated 6/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course covers everything you need to know about Microsoft Excel, from the very basics to the most advanced features.
View Curriculum
Requirements
  • This course expects you have a working copy of Microsoft Excel 2010, though most features apply equally well to Excel 2007 or Excel 2013.
Description

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were

If you’ve mastered Microsoft Excel 2010 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your path to first learning, then even mastering Excel.

This is our most requested training course! If you learn to use Excel 2010, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. Of course, you may have a rudimentary knowledge of how Excel works, but if you want to learn to get the most of it, then take this course. Let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through everything you’ve ever wanted to know about Microsoft Excel 2010, including:

    ·How to customize Microsoft Excel 2010 to work better for you

    ·Easily creating & modifying PivotTables

    ·The best way to create easy-to-view Charts & Graphs

    ·Using Conditional Formatting and Sparklines to Highlight Data Trends

    ·Tips & Tweaks for over 120 Excel 2010 functions and features!

Who is the target audience?
  • Anyone who uses Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
68 Lectures
09:23:06
+
Excel 2010: The Basics
11 Lectures 01:42:40

Adding/Changing Workbooks
06:36

Basic Text and Number Entry
12:55

The Interface: Ribbon and Quick Access Toolbar
06:34

The Interface: Status Bar and View Options
14:58

Keyboard Shortcuts
09:59

File Types
09:39

Open, Save, and AutoSave
14:36

Templates
07:48

AutoCorrect
05:46

+
Text and Formatting
8 Lectures 01:05:27
Text Formatting - Part 1: Font Style, Size, Color
08:58

Text Formatting - Part 2: Alignment, Numbers
09:23

Adding Hyperlinks
04:27

Scientific Equations
06:42

The Windows Clipboard (Paste Options)
12:14

The Office Clipboard (Advanced Cut and Paste)
06:29

Find and Replace
08:07

Spellcheck and Reference
09:07
+
Shapes and Graphics
8 Lectures 01:13:16

Shapes, Part 2: Arranging and re-Shaping
08:39

Pictures
11:11

Pictures: Advanced Effects
04:01

Clip Art and SmartArt
10:07

Text Boxes
05:59

Navigating and Highlighting in a Spreadsheet
11:51

Insert, Delete, Hide, Unhide
10:13
+
Data, Formulas, and Functions
10 Lectures 01:33:29

Formulas - Order of Operations, Absolute vs Relative
13:02

Intro to Functions
08:56

Financial Functions
09:53

Time and Date Functions
09:07

Formulas Tab: Text Functions
07:48

Logical, Math, and Statistical Functions
08:36

vLookup and More Functions
08:32

Formatting Cells and Ranges
08:07

Number Formatting
10:37
+
Working with Tables
6 Lectures 01:02:12
Tables
12:34

Sorting and Filtering
11:51

Subtotals
06:34


Customizing Pivot Tables
14:33

Importing Data
08:52
+
Visualizing Information with Charts
6 Lectures 33:34
Intro To Charts
04:24

Chart Design and Styles
05:33


Advanced Chart Formatting
11:34

Pivot Charts
02:54

Sparklines
05:23
+
Advanced Features
19 Lectures 02:12:28
Customizing Your Worksheet View, Part 1
12:45

Customizing Your Worksheet View, Part 2
03:47

Advanced Worksheet Formatting
07:43

Advanced Data Copy Techniques
08:32

Transforming Data With The Clipboard
02:50

Manipulating Text With Functions
08:35

Printing
11:34

Print Area
05:27

Using Data Validation
10:31


Analyzing Data: What-If Analysis / Data Tables
07:48

Analyzing Data: What-If Analysis / Goal Seek
02:59

Text To Columns
04:35

Consolidating Data
03:37

Creating Macros
08:16

Advanced Macros
05:52

Creating Random Numbers and Custom Series
06:46

Calculating Functions Across Multiple Workbooks
03:55

Customizing The Ribbon and Quick Access Toolbar
09:28
About the Instructor
Chip Reaves
4.3 Average rating
792 Reviews
7,990 Students
39 Courses
Bigger-Brains

Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.

Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.

Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.