Microsoft Excel 2010 Business Training for Beginners
4.7 (5 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.
529 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2010 Business Training for Beginners to your Wishlist.

Add to Wishlist

Microsoft Excel 2010 Business Training for Beginners

Learn how to use Excel 2010 professionally in a business environment with Step By Step Training
4.7 (5 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.
529 students enrolled
Created by Angela Wallace
Last updated 5/2014
English
Current price: $10 Original price: $30 Discount: 67% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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!
View Curriculum
Requirements
  • For Beginners, no prior knowledge of Excel Needed!
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.

Who is the target audience?
  • Beginners with no prior or very little experience using excel who desire to use it on a professional level.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
33 Lectures
04:43:44
+
Getting Started with the Basics
10 Lectures 51:04

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

Preview 05:31

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

Preview 01:15

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

Preview 07:13

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

Customize the Quick Access Toolbar
06:54

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.

Recovering an Unsaved Workbook and Setting Auto Recovery
08:41

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

Saving a Workbook with Save and Save As
07:05

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

Working with Columns and Rows
06:23

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

Customize Your Work area (Oh My! Where are My Column Headings and Toolbar?)
02:40

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

Creating and Opening Zipped Files
05:22

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.

Download me First
37 pages
+
Working With Data
10 Lectures 01:39:01

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

Entering Data into a Spreadsheet
09:08

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

Deleting Data and Cells
07:21

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

Bold, Underline, and Change Cell and Font Color
19:35

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

Merge and Center Cells
05:27

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

Aligning Data over Entire Columns or Rows
09:32

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

Cut, Copy, and Paste
07:24

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

Format Painter
06:39

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.

Adjusting Column and Row Width
05:40

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

Formating Numbers
13:46

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

Using Autofill and Creating Custom Lists
14:29
+
Managing Worksheet information
7 Lectures 01:07:23

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

Add and Delete Sheets from a Workbook
06:54

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

Formating Multiple Sheets at One Time
06:45

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

Adding Data to Multiple Sheets all at Once
13:00

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.

Freeze Panes
05:05

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

Using Filters and Sorting Data
13:44

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

Adjusting Page Breaks
09:53

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

Printing a Workbook or Single Spreadsheet (Without Blank Pages)
12:02
+
Working with Calculations
6 Lectures 29:16

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.

Using AutoSum Calculations and Formulas
04:15

This tutorial demonstrates how to perform multiplication calculations using formulas.

Creating Multiplication Calculations and Formulas
03:57

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

Absolute Referance
05:29

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

Create Calculations for Multiple Spreadsheets all at Once
03:20

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

Calculations using Data from Multiple Spreadsheets
09:43

What steps to take next and how to get help.

Conclusion
02:32
About the Instructor
Angela Wallace
4.7 Average rating
5 Reviews
529 Students
1 Course
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.