Microsoft Excel 2010 Business Training for Beginners

Learn how to use Excel 2010 professionally in a business environment with Step By Step Training
5.0 (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.
524 students enrolled
$30
Take This Course
  • Lectures 33
  • Contents Video: 4 hours
    Other: 37 mins
  • 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 5/2014 English

Course Description

This course is designed for those without any or very little prior experience with Excel who desire the knowledge to use it on a professional level. Step by step tutorials guide and teach you how to use the many tools that Excel offers for use at work, for small businesses, or at home. This course begins with the very basics of Excel with how to open a workbook and transitions you into more in depth skills such as working with multiple worksheets and creating formulas and calculations. In addition, this course offers a free downloadable training manual which provides step by step instructions at your fingertips covering all of the topics taught in this course.

The content of this course was designed based on feedback from Excel 2010 students from live classrooms who are employed and use Excel in many types of business professions.

What are the requirements?

  • For Beginners, no prior knowledge of Excel Needed!

What am I going to get from this course?

  • By the end of this course you will be able to use Excel in a business setting and have the knowledge and skills needed to create Excel workbooks, understand the ribbon and how to use it, work with multiple spreadsheets at once, format spreadsheets, create formulas and calculations, work with zipped files, and much more!

What is the target audience?

  • Beginners with no prior or very little experience using excel who desire to use it on a professional 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: Getting Started with the Basics
05:31

This tutorial demonstrates how to open Excel and create a default workbook.

01:15

How to change HD setting to clear us fuzzy tutorial videos.

07:13

This tutorial explains what the ribbon is and the locations and grouping of various tools and how to use them.

06:54

This tutorial explains and demonstrates how to use and customize the quick access toolbar.

08:41

This tutorial explains the various auto recovery options and how to set up auto recovery options; as well as, how to recover an unsaved workbook.

07:05

This tutorial demonstrates how to make a copy of a workbook using the save as option, as well as how to save a workbook.

06:23

This tutorial explains what are columns and rows, as well as how to access and maniplulate them.

02:40

This tutorial demonstrates how to use Excel in different view types and how to get back to a normal view.

05:22

This tutorial explains what a zipped files is and demonstrates how to create or open one.

37 pages

This section includes an Excel training manual as well as two data files that are used in upcoming tutorials; all of these are available for free download.

Section 2: Working With Data
09:08

This tutorial demonstrates how to enter data into an excel spreadsheet as well as how to move between cells, columns, and rows.

07:21

This tutorial demonstrates how to delete data from an excel spreadsheet; explaining the difference between deleting with the keyboard versus deleting with a mouse.

19:35

This tutorial demonstrates how to format an excel spreadsheet with bold and underline; as well as how to change cell and font colors.

05:27

This tutorial demonstrates how to merge and center cells using the ribbon and the mouse.

09:32

This tutorial demonstrates how to right, left, or center align data across entire columns, rows, or individual cells.

07:24

This tutorial demonstrates how to cut, copy, and paste data using the mouse or the ribbon.

06:39

This tutorial demonstrates how to use format painter to apply selected formatting to rows, columns, or individual cells.

05:40

This tutorial demonstrates how to adjust column and row width with auto fit, dragging with the mouse, and adjusting to a specific size using the demensions displayed on a column or row.

13:46

This tutorial demonstrations how to format various types of numeric data; for example, into currency or percentages.

14:29

This tutorial demonstrates how to use predefined auto fill list included with Excel; as well as, how to create and use your own list.

Section 3: Managing Worksheet information
06:54

This tutorial demonstrates how to add additional sheets to a workbook; as well as, how to delete sheets from a workbook.

06:45

This tutorial demonstrates how to format multiple spreadsheets all at once with font and color.

13:00

This tutorial demonstrates how to add data and formatting to multiple spreadsheets all at once.

05:05

This tutorial demonstrates how to use the multiple freeze pane options to allow the top row, selected columns and rows, or selected column to remain visible while scrolling through the spreadsheet.

13:44

This tutorial demonstrates how to use sorting or filters and explains the difference between these options.

09:53

This tutorial demonstrates how to adjust page breaks for more uniformed printing.

12:02

This tutorial demonstrates how to print a spreadsheet or entire workbook with different page layouts while eliminating blank pages during printing.

Section 4: Working with Calculations
04:15

This tutorial demonstrates how to enter numeric values and use the auto sum feature to total the values. In addition, this tutorial demonstrates how to manually type in the sum formula and explains the format of the formula.

03:57

This tutorial demonstrates how to perform multiplication calculations using formulas.

05:29

This tutorial explains what an absolute reference is and how to use it with multiplication formulas.

03:20

This tutorial demonstrates how to create multiplication and addition formulas across multiple spreadsheets all at once.

09:43

This tutorial demonstrates how to include data from other spreadsheets and use those in calculations.

02:32

What steps to take next and how to get help.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Angela Wallace, Business Intelligence Analyst

I hold a degree in Computer Science for Software Development and am employed as a Business Intelligence Analyst and Software Developer for an IT consulting firm. On a daily basis I build software, create websites, and both manage and create Sql and Access databases. The firm that I work for also offers instructor lead training classes to our members who are taught in person in a classroom.

Over the past two years I have taught the entire Microsoft Office Suite professionally in a class room to hundreds of business professionals who use the software daily in their professions. My teaching philosophy is that it is important to teach in a way that uses real life examples and analogies and breaks down and simplifies processes and techniques. Using real life examples and teaching in small simplified topic blocks allows others to learn easily. I have learned through real life teaching experience that not all students come to a class with the same knowledge base; so it is important to teach each topic thoroughly step by step. This means that every step is explained and demonstrated without making assumptions that a student will know how to complete some parts of a task already. This allows students to focus on the concept of what is being taught instead of focusing on a step that was not demonstrated that they are unsure of how to complete.

Ready to start learning?
Take This Course