Mobile Technical Institute

Human Resources Consulting

A confidential resource to help with employee situations as a group or one on one.

Web & Database Development

Provide your customers with timely information and generate new customers.

Secured Testing Center

We are Mobile's largest testing center providing both onsite & offsite testing services.

Training & Education

Monthly training seminars to meet the needs of today's business.

Excel Intermediate

Next Available Class

Thursday, March 1, 2012 - 8:30am - 3:30pm

Excel Intermediate

Training Level:

Intermediate

Class Type:

Classroom

Total Training Hours:

6hrs.

Approved Continuing Education Credit:

AL CPAs

AL Engineers and Land Surveyors

AL Nursing Home Administrators

Need to learn the intermediate functions of Excel to create powerful computerized spreadsheets? If you've already mastered the basics of Excel, MTI's hands-on intermediate class is exactly what you need!

If you are well versed in the basics of Excel and are ready to go to the next level of this powerful application, this class is designed to meet your needs. Skilled Excel users can fully utilize the functionality of Excel to develop spreadsheets that can effectively be used as management tools in their organizations. This course is recommended only for those who already possess basic skills in Excel.

Learning Objectives

This course is designed to provide skilled Excel users with advanced training in this powerful software application. This hands-on seminar is taught in a computer lab. Participants will receive practical, hands-on training on an individual PC. Participants can choose to work on Excel version 2003, 2007 or 2010.

Topics Covered Include:

A refresher of the basics with an intro into the more advanced functions which will build the foundations for the advanced course.

3-D References
VLookup, HLookup
Sorting Data
Filtering Data
Date and Time Functions
If Functions
Hide/show formulas/values
Images and Drawing Objects
Inserting & Formatting Images
Group Editing / Collaboration Tools
Charts & Tables
Pivot Tables

Want to bring this seminar to your company or association? Contact MTI for information about on-site training options, available at any U.S. location.

Click here for MTI's current open enrollment training schedule.

$150.00

Superior Retail Services

“MTI provided an affordable solution for creating our new marketing-oriented small business website. They handled everything, from moving our domain name to creating and hosting a professional website. When we need to make a change or add a link, they take care of it right away.“ ~~ Karen Willingham, Superior Retail Services

ST Mobile Aerospace

We have continually and often used the services of MTI since 2005. All requests for specialized or customized database reports have always been met with a positive attitude and successful resolution. I can fully recommend MTI . The services they provide are unequaled and the results have always been exemplary.”~~ David Doughty, Mobile Aerospace Engineering

National Application Processing & Screening, Inc.

"At NAPS, we are constantly monitoring our new business development strategies and continually searching for ways to increase our presence. While looking for opportunities in the Mobile, AL area, we turned to Mobile Technical Institute for assistance in promoting our educational seminars.

MTI is without a doubt one of our greatest connections we have made in promoting our company to our target market. MTI’s professional staff is exceptionally accommodating, caring and supportive in making sure our needs are met. MTI ensures our company is promoted in a professional and effective manner and the quality exposure we receive is superior. "~~Sam Ciulla, Vice President, National Application Processing & Screening, Inc., Birmingham, AL

MTI Business Solutions is a division of Mobile Technical Institute, inc. Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation. Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this website serves informational purposes only.