Practical Excel 2010 Beginners - for the Workplace

No more struggles. Learn Excel the easy way. Master Excel to succeed at any work place and get that deserved promotion
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.
48 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 67
  • Length 4 hours
  • Skill Level Beginner Level
  • 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 7/2015 English

Course Description

This introductory course covers the fundamentals of Microsoft Excel 2010. It assumes you have used Excel, at least at an elementary level, such as opening and saving an Excel file. This course will drastically increase your productivity and broaden your Excel skills.

The course begins with the Excel user interface: the tabs and ribbons, the backstage view, and the Quick Access Toolbar. It then teaches you methods for performing common Excel tasks, such as moving around large worksheets, selecting ranges, copying and pasting, working with formulas, creating and modifying charts, and printing. It also teaches you best spreadsheet practices for making your spreadsheets attractive and understandable by others. Throughout, the focus is not just on performing common tasks in Excel, but performing them efficiently. To learn Excel quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.

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

***** CLEAR AND CRISP VIDEO RESOLUTION *****

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

“As an Accountant, learning the Microsoft Office Suite really helps me out. All of the accounting firms out there, whether Big 4 or mid-market, want their employees to be well-versed in Excel. By taking these courses, I become a stronger candidate for hire for these companies." - Robert, ACCOUNTANT

There are two questions you need to ask yourself before learning Excel. 1. Why should you learn Excel in the first place? 2. What is the best way to learn?

The answer for the first question is simple. 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.

The answer to the second question is you learn by doing. Simple as that. Learn only that which you need to know to very quickly get up the learning curve and performing at work or school. Our course is designed to help you do just that. There is no fluff content and the course is packed with bite-sized videos and downloadable course files (Excel workbooks) in which you'll follow along with the instructor (learn by doing).

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 Excel 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…

What are the requirements?

  • Microsoft Office 2010

What am I going to get from this course?

  • An understanding of the Excel user interface, including changes to Excel since 2007
  • Efficiency tips on moving around worksheets and selecting large ranges
  • Efficiency tips on copying, cutting, and selecting formulas and ranges
  • How to manipulate rows, columns, and worksheets
  • How to take control of printing worksheets
  • How to format efficiently and effectively
  • How to work effectively with formulas, including auditing for correctness
  • How to create and modify charts effectively
  • How to use common but powerful Excel functions, including IF and VLOOKUP
  • Best practices for creating attractive and understandable spreadsheets

What is the target audience?

  • Any beginning Excel users who want to become more efficient and take their Excel skills to the next level.

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: Introduction to Course
01:12

Download these files before starting the course.

How to download Exercise Files and Handouts
Article
REMINDER: Turn on HD
Preview
1 page
Intro to Optima Train Tutorial
Preview
02:45
Section 2: Evolution of Excel
Changes in Excel
Preview
01:16
Section 3: Excel User Interface
Intro to Excel User Interface
Preview
02:10
Tabs and Ribbons
Preview
04:22
Customizing Ribbons
Preview
05:01
File Menu
Preview
01:41
Quick Access Toolbar
Preview
01:54
Opening Recent Files
Preview
03:49
Excel Options
Preview
04:18
File Extensions
Preview
03:37
Section 4: Excel Basics
Intro to Excel Basics
01:00
Intro to Moving and Selecting
01:36
Going Home to Cell A1
00:49
Splitting the Screen
01:38
Selecting a Range with Keys
04:03
Selecting a Range by Pointing
01:57
Selecting Multiple Ranges
01:19
Go To Options
02:43
Section 5: Copying, Cutting, & Pasting
Intro to Copying, Cutting, Pasting
00:58
Copying and Pasting
05:52
Cutting and Pasting
01:39
Paste Special Options
07:27
Transposing a Range
03:22
Office Clipboard
04:11
Section 6: Other Basic Tools
Intro to Other Basic Tools
00:43
Undoing Actions
02:12
Right-Clicking
02:29
Shortcut Keys
00:40
Number Formats
09:54
Manipulating Rows, Columns
02:29
Manipulating Worksheets
04:03
Printing
03:08
Cell Borders
03:43
Shapes and Pictures
02:35
Filling a Series
01:35
Sorting and Custom Lists
08:15
Adding Hyperlinks
04:38
Templates
03:36
Section 7: Formulas
Working with Formulas
00:52
Relative, Absolute Addresses
09:18
Calculation Options
03:52
AutoSum Button
02:42
Error Codes
04:36
Range Names 1
07:51
Section 8: Charts
Intro to Charts
02:15
Creating a Chart
08:40
Modifying a Chart
07:28
Locating a Chart
03:28
Sparklines
01:58
Section 9: Functions
Intro to Functions
01:01
Function Help
02:51
Intro to Basic Summarizing Functions
00:43
SUM, AVERAGE, PRODUCT
04:45
COUNT, COUNTA, COUNTBLANK
03:43
SUMPRODUCT
02:17
Intro to Two Essential Functions
01:00
IF
07:45
VLOOKUP
10:31
Section 10: Spreadsheet Best Practices
Intro to Spreadsheet Best Practices
00:27
Documenting Your Work
06:21
Themes
03:56
Styles
05:37
Conditional Formatting
09:56
Section 11: Conclusion to Course
Conclusion to Fundamentals Course
01:07

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Optima Train, 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.

Ready to start learning?
Take This Course