ERROR #3704: Operation is not allowed when the object is closed. 599CD.com Computer Training - Web Database Course List - Excel Seminar
 

4/24/2017: You may see an "operation not allowed" error on the site. We're working on fixing the problem. Nothing seems to be affected, it's just annoying. Carry on. :)   [dismiss]
 
Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
NEW Release: Access Advanced Level 4 and Level 5   dismiss
 
 

Learn Microsoft Excel

 
 
Seminars - Microsoft Excel
Description: Video recorded from our Live Microsoft Excel Seminar
Versions: Applicable to Excel 97, 2000, XP, 2003
Some minor cosmetic differences with 2007
Running Time: Three (3) Hours
Cost: $49
 
Learn how to build Excel spreadsheets from the ground up. This course will teach you everything from the basics of data entry all the way up to the more advanced features such charting and pivot tables. The course consists of THREE (3), one-hour sessions. Registration for all four classes is only $49


 

Why Microsoft Excel? Excel is the world standard in spreadsheets. Most businesses in the world today use Microsoft Excel. It's a valuable skill to have!

Who should attend? Anyone who is looking to learn how to use Excel more efficiently, and to learn additional features, tips, and tricks. No prior experience is necessary.  

What will be covered? See below for an outline of the topics covered in class.

Where will the course be held? Wherever you are! That's the best thing about online courses - you can learn from the comfort of your home or office. All you need is a Web browser and Windows Media Player, which is a free download from Microsoft if it's not already installed on your computer (and it probably is).

How much is registration, and what do I get? The cost is only $49 per student (quantity discounts available, please call). Registration includes enrollment for the course and a downloadable workbook outlining everything taught in class.

Why Amicron? Why should you trust Amicron for your online training? We have been providing classroom-based training since 1994. We don't just cover the material in some off-the-shelf textbook. We have written all of our own course materials and we know what you need to learn from practical experience. Every computer training company will say this, but we really mean it: our instructors are true experts. We're not just teachers who know computers. We're computer programmers, database developers, and technicians who teach. 

Who is the instructor? Richard Rost is the instructor for this course. He is a self-taught computer programmer, database developer, and web designer by trade. Richard started his career in computer training working in the technical support industry. He was in charge of training computer technicians to help customers solve their problems over the phone. From there, Richard founded Amicron Technology Services in 1994. When he's not teaching, he's building Access database solutions and for clients nationwide. He also builds web sites and online databases.

Where do I sign up? You can enroll for the class by clicking on the link below. We accept all major credit cards. You can also pay by check or money order. Yes, we will accept original, signed and dated purchase orders from accredited colleges and universities, and Fortune 1000 corporations.


This course covers everything from the basics of getting started with Excel all the way to up some of the more advanced features. In class one, we cover the basics, such as entering data, using AutoFill, basic calculations like Sum and Average, and basic charting and graphing. In the second class, we teach you decision making (If/Then), more advanced charting, and even more functions - we even show you some advanced financial calculations. In the third class, we cover advanced functions, macro programming, workbook security, and much more. If you want to know everything about Excel, this is the course.

PreRequisite: Windows Basics. Students should have a good understanding of how to use Windows, and a computer in general. No prior spreadsheet experience is required. We also recommend our Microsoft Word course before taking this one, as the interface is very similar, however this is not a requirement.

Excel 1: Parts of the Excel interface, Title Bar, Menu Bar, Toolbars, columns and rows, scroll bars, entering data, data, labels, formulas, formatting your spreadsheet, highlighting and selecting cells, alignment, colors, borders, working with calculations, addition, subtraction, multiplication, division, math order of operations, deleting cells, functions, SUM, AVERAGE, COUNT, MAX, MIN, inserting rows and columns, cut, copy, paste, paste format, keyboard shortcuts, AutoFill, creating a calendar in Excel using AutoFill, saving and loading workbooks, rounding data, resizing columns and rows, printing, page setup, scaling, margins, headers & footers, sorting data, graphing & charting, column chart, 3D column chart, pie chart, chart formatting, rotating your chart, spell check, find & replace, naming your sheet tabs.

 

Excel 2: Format cells, conditional statements, IF function, relative v. absolute references, using Named cells and ranges, VLOOKUP function, referencing subtables, referencing data on other sheets, or in other files, password protecting your data, protecting specific data in a sheet, linking data between Excel and Word or other office applications, paste v. embed v. link, freeze panes, splitting your sheet, cell comments, cell formatting, customizing toolbars, MEDIAN, ROUND, NOW functions.

Excel 3: 3D Ranges across multiple sheets, range intersections, arrays, auditing, data grouping, using form controls, drop-down menus, check boxes, autofilter data, pivot tables, macros, loan calculator, optional (time permitting): amortization, advanced graphics & drawing, advanced charting options, advanced macro techniques, advanced financial calculations.

 

So if you're serious about learning how to use Excel, this seminar is for you. This is the complete video recorded from one of our previous Excel seminars. It covers all three-hours of the course.

Please note: this seminar was recorded from a LIVE webcast event. The quality of the video is not up to the high standards of our normal 599CD courses. There are a couple of skips and short blackouts during this video, but it is still very instructional.

 

 

 
 
 

Student Interaction: Microsoft Excel Seminar

Richard on 1/1/2007:  Learn how to build Excel spreadsheets from the ground up. This course will teach you everything from the basics of data entry all the way up to the more advanced features such charting and pivot tables.
Chrissie on 6/15/2011: HaHa 44:54

Reply from Richard Rost:

Thanks. After almost 10 years someone finally laughed. :)

 Chrissie on 6/15/2011: Really...not a lot of people out there with a sense of humor.
You're welcome :o)

manuel zurbano on 10/8/2011: hi richard,
hi richard,
i would like to put a button to an excel file that would attached and send that file through outlook. is it possible?

excel user on 10/11/2011: hi richard would like to consolidate total with different row labels and column label. what is th best way.
John Casey on 2/9/2012: Is there a list of formulas in Excel?
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP