Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 

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.

 

 

 
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 7:15:37 AM. PLT: 0s