Excel 2010 - Level 1: From Zero to Hero; Beginner-Novice
5.0 (11 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.
682 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2010 - Level 1: From Zero to Hero; Beginner-Novice to your Wishlist.

Add to Wishlist

Excel 2010 - Level 1: From Zero to Hero; Beginner-Novice

A comprehensive introductory excel basics course; starts at the beginning and gets you up to speed fast using Excel 2010
5.0 (11 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.
682 students enrolled
Last updated 8/2014
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
To Become Comfortable, Confident, and Efficient In Using Excel
Learn How to Create and Save Workbooks
Learn About the Excel Window and User Interface
Learn About Data Types and Entering and Editing Data
Learn How To Create Formulas and Understand Cell Address Types
Learn How to Use Functions
Learn About Character and Numerical Formatting and How to Apply Them
Learn How to Create Basic Charts
Learn How to Setup and Manipulate the Print Job
Learn How to Create Headers and Footers
Have Fun Learning About Computer Software
View Curriculum
Requirements
  • None
Description

By taking this Excel For Beginners course, you will learn excel basics and other important details on your way to becoming an Expert in using Excel.  Joel Levy of PC Applications with 20 years of Instructor Led Computer Training Experience will take you step by step through the entire process of creating a Worksheet with Net Income and Commission Calculations, Basic Function Calculations (including Average), and a Sales Chart as an example of how to create, save and print an Excel Workbook.  Many important underlying concepts about working with Excel are explained in detail using plain simple terms.  Course files are provide so you can work right along with each lesson for the "hands on experience".

Along the way, you will learn about what Excel can be used for, the Excel Window and Using Tabs and Ribbons, Opening, Creating and Saving Workbooks, Excel File Types, Entering Data and Data Types, Creating Formulas and Functions, Cell Addresses and Cell Address Types, Moving and Copying Data and Formulas, Editing Data and Worksheets, Formatting Data and Worksheets, Creating Basic Charts, Proofing and Printing Including Headers and Footers in this excel for beginners. Many shortcuts are covered.  This excel basics course contains 17 Lessons with almost 4 Hours of video content.

Although this excel for beginners course assumes you "know nothing", it could be very worthwhile even if you have already "fumbled around" with Excel as important "fundamental" details are covered.  The course starts at the beginning and gets you well down the road in being functional in applying Excel to get the work done, FAST!  This course covers the same information that I cover in my full day, 7 hour instructor led class that I teach in my business.  I also have Level 2 and Level 3 courses.

See why many people have told me "Best computer training I've ever had!"

I guarantee you will find this course well worth your while.

Take this Excel Basics course right now and learn excel for beginners -Novice.

</p>
Who is the target audience?
  • Beginner, Novice
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 22 Lectures Collapse All 22 Lectures 04:02:34
+
Introduction to Joel Levy/PC Applications
3 Lectures 03:49
Learn About Joel Levy/PC Applications and His 20 Years of Instructor Led Software Training Experience
Preview 01:43

I Explain Why YOU Might Want to Take a Course From ME (Joel Levy).
Preview 00:55

See If This is the Right Course for YOU to Invest In; Get an Idea of the Course Content and Why to Take the Course.
Preview 01:11
+
Understanding Excel, the Excel Window and User Interface
3 Lectures 40:10
Learn Why You Would Use Excel, Understand the Excel Window and the User Interface.
Preview 12:45

Learn How to Customizing the Quick Access Toolbar and Ribbon and Change View Options.
Working with the Quick Access Toolbar and Ribbons
12:31

Learn How to Open a File (The Finished Course File), Understand the Active Cell, Cursor Shapes, Ranges and Making Selections, Cell Contents and the Formula Bar, Moving Around the Worksheet, Shortcut Keys, the Name Box and How to "Go To", Closing a File.

Open an Existing File, Looking and Moving Around
14:54
+
Creating and Saving Worksheets and Workbooks
10 Lectures 02:32:02

Learn How to Enter and Edit Data, Data Types and Default Alignment, Using the Formula Bar, F2 Function Key, and Undo/Redo.

Preview 12:11

Learn How to Save a File (Workbook), Understand File Names and Extensions.
Saving a Workbook
04:24

Learn How to Move or Copy Data (Text or Numbers) by Using the Clipboard or Mouse Methods (Click and Drag/Drop).
Move or Copy Data (Text or Numbers)
12:53

Learn How to Create Formulas and Use Functions; Create Calculations Using Numbers or Cell Addresses, Understand Order of Preference of Operations.
Create Basic Formulas and Use Basic Functions
23:08

Learn How to Copy and Move Formulas with Cell Addresses, Understand Cell Address Types, Using the F4 Function Key, and Using the Fill Handle and Fill Pointer.
Copy or Move Formulas (Part 1)
24:20

Learn About Mixed Cell Addresses and How to Use Them in Formulas, Using the F4 Function Key, More About Using the Fill Handle and Fill Pointer, Moving Formulas with Cell Addresses and Moving Cell Referenced in Formulas.
Copy or Move Formulas (Part 2)
12:04

Learn about Inserting and Deleting Cells, Columns, and Rows, Adjusting Column Width And Row Height, What “Long Text” and “Long Values” Mean and how to work with them, Wrap Text, Merge And Center

Modifying Or Formatting A Worksheet (Part 1)
23:03

Learn How to Rename a Sheet, Add Color to a Sheet Tab, and How to Move or Copy a Worksheet,

Modifying Or Formatting A Worksheet (Part 2)
06:15

Learn How to Apply Character Formats (Font, Size, Font Color, Bold, Italic, Underline, Alignments), Borders and Shading, Use the Format Painter, Understand and Apply Styles, Understand and Use Delete and Clear.

Formatting Data And Cells (Part 1)
19:29

Learn About Number Formats: Currency and Accounting, Dates And Time (Date And Time Value), Percent, and Scientific Notation

Formatting Data And Cells (Part 2)
14:15
+
Create Basic Charts
1 Lecture 12:31
Learn How to Create Column And Bar Charts, Line Charts, Pie And Donut Charts, Understand Data Range Use For A Chart, Chart Types And Interchangeability, and Chart Contextual Tabs.
Create Basic Charts
12:31
+
Proofing and Printing
3 Lectures 32:09
Learn How to Find and Replace Data, and Use Spell Check.
Proofing Tools
06:37

Learn How to Modify the Print Job Using Print Preview (Backstage View in 2010 and the Print Preview Contextual Tab/Ribbon in 2007), Work with the Page Setup Dialog Box, Page Break Preview, Viewing and Modifying Page Breaks, Print Range, Copies/Collate, and Printer Options.

Printing (Part 1)
18:46

Learn How to Create Headers and Footers by Using Page Layout View and the Header and Footer Tools Design Tab/Ribbon, Adding Header or Footer Information by Typing or Adding Header or Footer Elements
Printing (Part 2)
06:46
+
Thank You!
1 Lecture 00:25
+
All Course Files
1 Lecture 00:18
Here are all of the course files for download.  Read Lesson Description...
All Course Files
00:18
About the Instructor
Instructor, Trainer, Consultant Joel Levy
5.0 Average rating
11 Reviews
682 Students
1 Course
...Best Computer Training I Have Ever Had

My first career involved working as a professional geologist for 10+ years after receiving a MS in Geology from Lehigh University in 1976.

After getting my first “386” PC over 20 years ago, my strong personal interest and desire for understanding led to my vast knowledge of software including DOS, Word Perfect, and Lotus and then Windows and MS Office.  Coupled with my passion for teaching, I taught computer applications (DOS, Word Perfect, Lotus, Windows, Word, Excel, Access, and PowerPoint) at a local community college from 1994 -1996 and started my own business, PC Applications (computer training and consulting) in 1995. I have been providing Windows and MS Office (Word, Excel, Access, PowerPoint, Outlook, and Publisher) training and consulting services to individuals, small businesses, corporations, and town, city, and county governments ever since.

Although I teach and consult all of the Office applications at all levels, I have particular expertise with Excel and Access. My strong math and analytical skills have allowed me to understand the nature of relational database design, VBA programming, and overall concepts of data analysis and Database Administration. I have designed many applications using MS Access; interfaced Access with data systems for analytical/reporting purposes, especially Excel. My strengths are being able to assimilate information, understand a problem, and come up with a solution using software applications.