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 (9 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.
671 students enrolled
$40
Take This Course
  • Lectures 22
  • Contents Video: 4 hours
    Other: 0 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 3/2013 English

Course 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>

What are the requirements?

  • None

What am I going to get from this course?

  • 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

What is the target audience?

  • Beginner, Novice

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 Joel Levy/PC Applications
01:43
Learn About Joel Levy/PC Applications and His 20 Years of Instructor Led Software Training Experience
00:55
I Explain Why YOU Might Want to Take a Course From ME (Joel Levy).
01:11
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.
Section 2: Understanding Excel, the Excel Window and User Interface
12:45
Learn Why You Would Use Excel, Understand the Excel Window and the User Interface.
12:31
Learn How to Customizing the Quick Access Toolbar and Ribbon and Change View Options.
14:54

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.

Section 3: Creating and Saving Worksheets and Workbooks
12:11

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

04:24
Learn How to Save a File (Workbook), Understand File Names and Extensions.
12:53
Learn How to Move or Copy Data (Text or Numbers) by Using the Clipboard or Mouse Methods (Click and Drag/Drop).
23:08
Learn How to Create Formulas and Use Functions; Create Calculations Using Numbers or Cell Addresses, Understand Order of Preference of Operations.
24:20
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.
12:04
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.
23:03

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

06:15

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

19:29

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.

14:15

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

Section 4: Create Basic Charts
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.
Section 5: Proofing and Printing
06:37
Learn How to Find and Replace Data, and Use Spell Check.
18:46

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.

06: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
Section 6: Thank You!
Thank you very much!
Preview
00:25
Section 7: All Course Files
Article
Here are all of the course files for download.  Read Lesson Description...

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Instructor, Trainer, Consultant Joel Levy, ...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.

Ready to start learning?
Take This Course