microsoft excel
macro tutorial

Microsoft Excel Macro Tutorial Online

Microsoft Excel Macro: Naming Ranges Working with Macros and Customizing Toolbars shows users how to create and use named ranges and how to use lookup functions. It also shows how to record run and edit a excel macro as well as hide display and customize toolbars.

This tutorial is for anyone preparing for the MOUS Excel 2000 Expert certification exam.
This is self-paced Microsoft Excel 2000 tutorial -- there are no books to purchase and no scheduled classes to attend.

Excel Training

Excel 2000

Importing Exporting Data

Templates Links Reports

Formatting Sorting Filtering

Macros and Toolbars

Validating and Auditing

Worksheetd and Workbooks

Formulas and Functions

Charts and Objects

Training Courses
Info and Order

Computer Training

Fast Weight
Loss Program

Fruta Vida

Vitamins Supplements

Our Microsoft Excel 2000 course offer unique benefits unavailable from other self-paced vendors. Each course is developed using a rigorous set of criteria that includes quality content, interaction, graphics, and interspersed questions, making learning fun, interesting, and effective.

Working with Macros and Customizing Toolbars Course Objectives

Add and delete a named range
Use a named range in a formula
Use lookup functions (HLOOKUP and VLOOKUP)
Assign a macro to a toolbar button
Hide display and customize toolbars

Working with Macros and Customizing Toolbars Course Topics

Adding Using & Deleting a Named Range
- Adding and deleting a named range
- Using a named range in a formula
Using Lookup Functions
- Using the Lookup Wizard
- Using the HLOOKUP function
- Using the VLOOKUP function
Recording and Running
- Recording
- Running
Editing
- Using the Visual Basic Editor
- Editing the keyboard shortcut
- Assigning a to a toolbar button
Working with Toolbars
- Hiding and displaying toolbars
- Customizing a toolbar

Features:

Instructional steps -- walk through a procedure
Exercises -- try it out
Notes - See additional information related to the topic in the text
Tips - See a different, faster, or easier way of doing something
Quick References - See a quick reference guide to the features introduced in a chapter
Details - Display more detailed information related to the current topic
Hotwords - See related information
Navigation Bar - Maneuver easily through the courses
Topics and Index -- with searching feature and hyper-links
Printable Exercises - PDF downloadable files
Sample Application Files - PDF downloadable files
Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which topics you want to focus on and to go directly into that unit.

Technical Requirements

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Learning comes to life with challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. Our proven methodology provides an unequalled experience with exceptional results Learning that's Easy, Convenient and Affordable! Aannual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.

Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.