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>
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.
Learn How to Enter and Edit Data, Data Types and Default Alignment, Using the Formula Bar, F2 Function Key, and Undo/Redo.
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
Learn How to Rename a Sheet, Add Color to a Sheet Tab, and How to Move or Copy a Worksheet,
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.
Learn About Number Formats: Currency and Accounting, Dates And Time (Date And Time Value), Percent, and Scientific Notation
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.
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.