Mastering Excel 2010

Learn Everything You'd Want To Know About Microsoft Excel
4.3 (2 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.
22 students enrolled
$20
Take This Course
  • Lectures 68
  • Contents Video: 9.5 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 6/2014 English

Course 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!

What are the 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.

What am I going to get from this course?

  • This course covers everything you need to know about Microsoft Excel, from the very basics to the most advanced features.

What is the target audience?

  • Anyone who uses Excel

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: Excel 2010: The Basics
What Is Excel?
Preview
09:12
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
Undo and Redo
Preview
04:37
Section 2: Text and Formatting
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
Section 3: Shapes and Graphics
Shapes, Part 1: Inserting and Formatting
Preview
11:15
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
Section 4: Data, Formulas, and Functions
Entering Data in Series
Preview
08:51
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
Section 5: Working with Tables
Tables
12:34
Sorting and Filtering
11:51
Subtotals
06:34
Creating Pivot Tables
Preview
07:48
Customizing Pivot Tables
14:33
Importing Data
08:52
Section 6: Visualizing Information with Charts
Intro To Charts
04:24
Chart Design and Styles
05:33
Optimizing Chart Data
Preview
03:46
Advanced Chart Formatting
11:34
Pivot Charts
02:54
Sparklines
05:23
Section 7: Advanced Features
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 / Scenario Manager
Preview
07:28
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Chip Reaves, 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.

Ready to start learning?
Take This Course