KT-9370 Excel Power Skills Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Excel Power Skills


Description: 

Just about everyone knows how to construct a simple spreadsheet. Most business users can add IF statements and SUM function to do heavy-duty number crunching. But if you really want to set your Excel skills apart from the rest of the pack, you have to move on to the advanced functions. Knowing how to create sophisticated spreadsheets capable of not only displaying data but of producing refined analysis of the data.

The Excel training class was designed with your real-world problem solving needs in mind. In each of its subject modules it first provides you with a quick overview of the concept followed by a step-by-step introduction as to how Excel implements the concept. Once these essentials have been mastered, you will move on to more sophisticated models that provide real-value to solving real-world situations. You will leave the course proficient in power functions and techniques that others do not even know exist. You will be set to immediately begin implementing what you have learned to the benefit of your job and your career.

  • Learn how to find optimal solutions to any number of business problems using Solver
  • Master the use of Monte Carlo analysis for a wide range of estimating situations
  • Develop predictive models that can incorporate both quantitative and qualitative factors
  • Quickly standardize databases of information by applying text functions
  • Discover information buried in your data that you did not know existed
  • Be able to display data in a manner that enhances understanding
  • Develop sophisticated risk models for your project, product, or operation
  • Find relationships between data using correlations and statistical analysis
  • Master the functions that will serve as the building blocks of your future databases
  • Learn how to combine any number of functions and tools for one-of-a-kind Excel analysis

Who should attend:

Anyone who wants to take their Excel skills to the next level can benefit from this class, but it will be especially useful for: 

  • Product owners
  • Project managers
  • Product analysts
  • Functional managers
  • Small business owners
  • Non-profit managers
  • Professionals seeking deeper insights into their data

 
Click here to view the Course Outline
     
Prerequisite: 

Prospective students should know how to create, save, and load spreadsheets; how to copy and paste, format data and use Format Painter; and how to navigate using the Excel ribbon.

 
   
     
Duration: 
2 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.