Seminar Information Service

Seminars and Training Since 1981 · SeminarInformation.com · (877) SEM-INFO  

Home   About Us   Contact Us  



Power Excel: Making Better Decisions

QuickCode:
QQBTJH
See Dates and Sign Up  View Dates & Sign Up ·  Print this Brochure  Print Brochure ·  Email this Page  Email Page ·  Bring Seminar On-site  Bring On-site

 
  Upcoming Dates
*Click on a Date to Sign Up
May 19-20 · ROCKVILLE, MD
Jun 2-3 · IRVING, TX
Jun 2-3 · ALEXANDRIA, VA
Jun 9-10 · ROSELAND, NJ
Jun 9-10 · RESTON, VA
Jun 16-17 · NEWPORT BEACH, CA
Jun 16-17 · BALTIMORE, MD
Jun 23-24 · NEW YORK, NY
Jul 14-15 · OTTAWA, CN
Jul 14-15 · PHILADELPHIA, PA
Jul 21-22 · CHICAGO, IL
Jul 21-22 · ROCKVILLE, MD
Jul 28-29 · EL SEGUNDO, CA
Aug 5-6 · TORONTO, CN
Aug 11-12 · RESTON, VA
Aug 18-19 · ATLANTA, GA
Aug 25-26 · NEW YORK, NY
Sep 8-9 · SCHAUMBURG, IL
Sep 8-9 · ALEXANDRIA, VA
Sep 15-16 · ROCKVILLE, MD
Show All 33 Dates
 
 

 
 
Provider:
Learning Tree International
$1,750 

Topic: Computers & Software > Programming & Software

General Overview:
You will learn how to: Leverage advanced features of Microsoft Excel to facilitate business decisions; Perform 'what-if' analysis for developing budget and project plans; Predict potential business developments using trend analysis; Consolidate and process multidimensional worksheets; Summarize and analyze large amounts of data using PivotTables and Excel features; Automate Excel processes and enhance worksheet models; Generate interactive Web-based worksheet models. Fee per person: $1750

Who Should Attend?
This course is valuable for everyone who makes business decisions based on data. Experience with Excel at an introductory level is assumed.

We Also Recommend:
· Advanced Training for Microsoft Excel

 
 

Detailed Overview/Outline

You will learn how to

  • Leverage advanced features of Microsoft Excel to facilitate business decisions
  • Perform "what-if" analysis for developing budget and project plans
  • Predict potential business developments using trend analysis
  • Consolidate and process multidimensional worksheets
  • Summarize and analyze large amounts of data using PivotTables and Excel features
  • Automate Excel processes and enhance worksheet models
  • Generate interactive Web-based worksheet models

Course benefits
In today's fast-paced business climate, it is vital that decisions are made quickly and accurately. The power of Microsoft Excel can be used to analyze business problems, identify solutions and make sound decisions to achieve a competitive advantage.

In this course, you use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform "what-if" analysis, apply functions, manipulate PivotTables and present your results to make better decisions for planning, budgeting and more.

Who should attend
This course is valuable for everyone who makes business decisions based on data. Experience with Excel at an introductory level is assumed.

Hands-on training
Throughout this course, extensive hands-on exercises, performed under the guidance of an expert instructor, provide you with practical experience using Excel, including:

  • Performing statistical and financial calculations
  • Reducing speculation with "what-if" analysis
  • Implementing consolidation techniques
  • Summarizing data contained in 3-D worksheets
  • Defining the best combination of values to solve complex business problems
  • Projecting business trends
  • Creating interactive data reports with PivotTables
  • Developing macros to simplify data analysis
  • Presenting your Excel results on the Web

Course content
BUSINESS SOLUTIONS AND EXCEL

  • Overview of Excel features
  • Incorporating Excel into the decision-making process
  • Designing effective worksheet models

ANALYZING AND DECIPHERING DATA

  • Evaluating data with Excel functions
  • Applying basic financial functions
  • Differentiating serial dates and date presentations
  • Interpreting data using the Analysis Toolpak
  • Scrutinizing data anomalies with conditional tests
  • Optimizing solutions with "what-if" analysis
  • Planning costs with Solver
  • Determining profits with Goal Seek
  • Comparing and contrasting data sets with Scenario Manager
  • Building scenario reports

CHARTING YOUR BUSINESS FUTURE

  • Interpreting data with charts
  • Reporting data in embedded charts and chart sheets
  • Manipulating and formatting charts
  • Performing trend analysis
  • Establishing data patterns for detailed analysis
  • Adding trend lines to project future values
  • Data extrapolation with AutoFill

SUMMARIZING BUSINESS INFORMATION

  • Organizing information
  • Arranging multiple workbooks with Workspaces
  • Managing external links
  • Consolidating ranges
  • Building 3-D formulas to analyze worksheet data
  • Summarizing multiple sources of Excel information into one worksheet

FORMULATING DECISIONS FROM DATABASE INFORMATION

  • Distilling lists for data analysis
  • Analyzing lists with filters and aggregation
  • Calculating subtotals and grand totals
  • Defining subsets of data with Microsoft Query
  • Withdrawing data from external data sources
  • Filtering and sorting data
  • Controlling properties of an external data extract
  • Condensing and refining data with PivotTables and PivotCharts
  • Creating interactive PivotTables and PivotCharts for real-time data analysis
  • Comparing related totals dynamically
  • Extracting and filtering records
  • Defining data summaries interactively
  • Presenting PivotTable reports effectively
  • Exploiting OLAP cubes as a data source

AUTOMATING EXCEL USAGE

  • Recording and executing macros
  • Performing repetitive tasks with macros
  • Invoking macros with Form controls
  • Recognizing the code behind a macro
  • Working with the Visual Basic Editor
  • Stepping through and interpreting code in a macro procedure

PRESENTING AND REPORTING DATA

  • Assembling reports
  • Obtaining different perspectives with Views
  • Merging scenarios, views and worksheets with Report Manager
  • Deploying Web reports
  • Composing Web pages with PivotTable data
  • Creating interactive Web-based worksheet models

Sponsor Background:
About Learning Tree

Learning Tree International is a world leader in Hands-on training for Management and Technology Professionals. Since 1974, over 1,700,000 course participants from over 13,000 organizations around the world have enhanced their skills through intensive hands-on exercises under the guidance of expert instructors with real-world experience.

Virtually every major company and government agency has relied on Learning Tree to provide its managers and employees with the skills they need to succeed in their job functions.

10 Reasons to Choose Learning Tree

... over 1.7 million professionals have trained with Learning Tree

1 Benefit from 32 Years of Training Excellence

Learning Tree International has trained over 1,700,000 IT and management professionals and managers from more than 13,000 organizations around the world. Virtually every major technologyoriented organization and government agency has trusted and relied on us to provide their employees with the training they need to master the latest technologies and management skills.

2 Learn from Expert Instructors

Learning Tree instructors are active practitioners who average more than 20 years experience in their field. Because they use the very technologies and skills they teach, they've already solved the same problems you are likely to encounter, so you and your organization gain the knowledge from their years of hands-on expertise. In addition to their extensive real-world experience, our instructors only qualify to teach Learning Tree Courses after completing our rigorous industryleading screening and training program.

3 Experience Superior Course Design

Learning Tree Courses are developed through a stringent, time-tested process that ensures every course is practical and relevant. Our development teams include multiple subject experts drawn from our worldwide network-and our courses are constantly updated to ensure what you learn is always up to date.

4 Courses are Available Anywhere, Anytime

In addition to our Education Centers located in North America, Europe and the Pacific Rim, Learning Tree has the infrastructure and logistical capabilities to assemble, customize and deliver world-class training anywhere in the world. Whether it's a single course at your own facility, or a complete curriculum you need to present in different locations around the globe, location is not a problem.

5 Acquire Practical Skills with Hands-On Instructor-led Training

Each of our intensive hands-on courses is designed to help you gain the skills you need-quickly and in depth. Our courses are taught in a collaborative, supportive classroom-based environment, not on a Web site where you get instruction in a vacuum. And when you return to work, you can apply your new skills, tools and techniques right away, so you and your organization reap the benefits immediately.

6 Retain New Knowledge and Skills Longer

Learning Tree Courses are developed around the principles of Active Learning, the most advanced and effective method of adult education. You are immersed in your subject through individual and group activities that significantly increase your understanding, retention and ability to apply new knowledge and concepts to maximum effect.

7 Learn in a Superb Training Environment

Our modern, comfortable Education Centers are designed to ensure the comfort, ease and maximum effectiveness of your learning experience. We provide state-of-the-art equipment featuring MagnaLearn(tm), our proprietary Instructional Enhancement Technology-which helps you learn more quickly, in greater depth and with increased retention.

8 Achieve Professional Certification

We offer 45 Certification Programs that give you professional recognition and document your expertise. Achieving Learning Tree Certification demonstrates your mastery of the essential skills required to excel in your role.

9 Earn College Credit or Continuing Education Credit

Learning Tree Courses are recommended for college credit to more than 1,500 Universities and Colleges by the American Council on Education (ACE). Our courses are also eligible for PDU credits from the Project Management Institute, as well as CPE credits from the National Association of State Boards of Accountancy.

10 Vendor-Independent Training

Learning Tree was, is and will continue to be independent of vendor influences. That means you get training that is unbiased. We present an objective, evenhanded treatment of the pros and cons of new products, techniques and technology. You even learn about third-party alternatives that the vendors themselves would never tell you about.

Learning Tree Management Training

For over 32 years, Learning Tree has been dedicated to meeting the professional development needs of people like you. Now, more than ever, superior management, leadership and interpersonal skills are critical to individual and organizational success. And it is equally critical to be able to apply those skills in complex, technology-intensive environments.

Experience the Quality...of Learning Tree Hands-On Training

Learning Tree is committed to providing the most effective high-quality education for IT professionals and managers. Our high standards for Course Development, Instructor Training and state-of-the-art facilities provide a learning experience that ensures your training investment produces the results you and your organization expect.

Active Training Ensures That "You Learn by Doing"

For over 32 years, Learning Tree has been a pioneer in the application of Active Training, which is the most advanced and effective method of adult education. And today, we are still leading the way.

In our courses, you learn by doing. Our instructors do more than just lecture--they actively involve you in your training. Brief lectures are followed by hands-on exercises so that you master new skills right away.

Get Real-World Solutions from Expert Instructors

Learning Tree instructors are active practitioners who work full time in high-tech companies, R & D labs and other business environments where they use the very technologies and skills they teach. Because they have already solved the same problems you are likely to encounter, our instructors are equipped to share their real-world experience and practical solutions with you. Everything you learn is practical, relevant and up to the minute.

 
  This seminar has 33 available dates/locations. Click the button below to view them all and to sign up for this seminar. To quickly return to this seminar at a later time, you can search by its QuickCode: QQBTJH.
View Dates and Enroll
 
 

Get updated when new dates are added for this seminar.
Get a free personalized recommendation from our experts!

Questions? Please call us Toll-free at (877) SEM-INFO.


©2008 Seminar Information Service, Inc. All Rights Reserved. (877) SEM-INFO · info@seminarinformation.com
Home | Contact Us | About Us | Advertise | Site Blog | Site Map | Privacy Policy