Practical Excel 2010 Tips & Tricks
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
Wishlisted Wishlist

Please confirm that you want to add Practical Excel 2010 Tips & Tricks to your Wishlist.

Add to Wishlist

Practical Excel 2010 Tips & Tricks

Sharpen your spreadsheet skills by learning really cool tricks you can apply at work. Save time and become a power user.
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
Created by Optima Train
Last updated 2/2016
English
Price: $25
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Basics of copying & pasting cells, paste preview and other special paste options
  • Formatting basics, live preview, font dialog, format painter, mini toolbar
  • See the amazing paste transpose feature to flip a spreadsheet
  • A clear & simple explanation of absolute and relative references in formulas
  • Detect worksheet errors individually and in the errors tool, and correct them
  • See how to do audits and traces in a worksheet
  • See how to create a table, format, sort & filter it with smart headings
  • Build a chart from scratch, format it and plot trend lines
  • How to build a PivotTable from scratch, customize and filter
  • Using Slicers to filter Pivots for ease and clarity
  • Using Sparkline charts to create an effective chart in a single cell
  • How to use Conditional Formatting to clarify worksheet data
  • See printing options, page layout and formatting headers & footers
View Curriculum
Requirements
  • Microsoft Office 2010
Description

This course covers Tips & Tricks on Microsoft Excel 2010. It assumes you have used Excel and are familiar with creating, editing & formatting worksheets. In a quick and lively manner this will cover what is new in this version of Excel and also show you some tips to increase your productivity in Excel and widen your skills. These tips also apply to Excel 2013 so videos 1,2,4,8 & 11 would be good background for Excel 2013 users.

The course begins with a review of some basics of cell selection, copy, paste and formatting. Use of the format painter is shown in detail. A review of formula entry and the difference between absolute and relative formulas is covered. How to deal with errors and audit a worksheet is demonstrated. Intro to tables is next with examples of sorting & multilevel filtering. A Pivot Table is built from scratch in a simple and easy to understand manner and then it is filtered using data slicers and charted with Sparkline charts. The basics of creating & editing a chart, plotting trend lines, and other fancy chart formatting are demonstrated. The powerful analysis of conditional formatting is introduced and custom settings reviewed. Finally some basics on printing and spreadsheet layout are covered. Throughout the course the videos are quick, lively and clearly explained. If you don't have all day to spend on a course this will cover the highlights of what's new, a few basics and a little bit more in under an hour.

***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****

***** COURSE UPDATED: February 2016 *****

Over 90% of businesses today and 100% of colleges use Excel. If you do not know Excel you will be at a distinct disadvantage. Whether you're a teacher, student, small business owner, scientist, homemaker, or big data analyst you will need to know Excel to meet the bare minimum requirements of being a knowledge worker in today's economy. But you should also learn Excel because it will simplify your work and personal life and save you tons of time which you can use towards other activities. After you learn the ropes, Excel actually is a fun application to use.

Amplify your spreadsheet skills by learning a series of really neat tips and tricks that you can immediately apply at your workplace or school or home.

If you want to learn Excel quickly, land that job, do well in school, further your professional development, save tons of hours every year, and learn neat Excel tricks in the quickest and simplest manner then this course is for you!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions.

We are so confident that you will get tremendous value from this course. Take it for the full 30 days and see how your work life changes for the better. If you're not 100% satisfied, we will gladly refund the full purchase amount!

Take action now to take yourself to the next level of professional development. Click on the TAKE THIS COURSE button, located on the top right corner of the page, NOW…every moment you delay you are delaying that next step up in your career…

Who is the target audience?
  • Busy Excel users of any skill level who want a quick look at what is new and can save them time. Those needing a review of some basics. You should have some basic skills in editing, formatting and working with Excel worksheets.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 14 Lectures Collapse All 14 Lectures 58:23
+
Practical Excel 2010 Tips & Tricks
14 Lectures 57:24

Introduction to Excel 2010 Tips & Tricks Course

Preview 01:22

How to download Exercise Files and Handouts
00:23


Copy, paste, Transpose,Paste Preview and other paste special like paste values

Preview 05:16

Formatting basics, live preview, font dialog, format painter, minitoolbar

Formatting
06:15

Show examples of relative and absolute and how to manage these

Preview 03:21

Detect errors individually and in Errors tool.Do audit traces & print audit reports.

Errors & Auditing
05:42

Creating a table, finding duplicates, sorting & filtering a table

Tables
06:36

Creating a basic Pivot table, formatting & pivoting views

PivotTables
08:37

Adding data slicers to a pivot table

Slicers
03:19

Creating a chart & formatting options

Charts
04:58

Adding a Sparkline chart to a worksheet, formatting

Preview 02:04

Intro & examples of Conditional formatting including editing conditions

Conditional Formatting
05:11

Printing options, page setup, formatting headers and footers

Page Layout & Printing
04:20
About the Instructor
Optima Train
4.4 Average rating
536 Reviews
4,518 Students
25 Courses
Practical Training for Today's Knowledge Worker

Optima Train is a US-based training company using cutting-edge adult learning methodology to make our customers more effective in the workplace.

Optima Train has the most comprehensive coverage of content created by experts with deep knowledge of how applications are used in the workplace.

We are intricately linked to our customers. While most training companies have a tool-centric approach that leads to relatively low knowledge retention, Optima Train has a results-oriented approach.