Excel on steroids 2013

excel on stebig   Microsoft® Excel® 2013 offers new, powerful functionality for intuitive and intelligent business reporting. It offers a cleaner look and feel and is also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from walls of numbers and draw more persuasive pictures of your data; guiding you to better, more informed decisions. Learn how to take advantage of these ground-breaking features and functions in the three online courses within Excel on Steroids 2013. Save money and buy a BUNDLE.

Data and Worksheets Online Course In this online course you will learn how to view and analyze different variables of your data, and how to customize and manipulate cells, worksheets and workbooks, resulting in easier and quicker analysis of your data.  You will be introduced to the Quick Analysis tool and Flash Fill.  The Quick Analysis tool lets you convert your data into a chart or table in two steps or less. Preview your data with conditional formatting, sparklines, or charts, and make your choice stick in just one click.  Flash Fill is like a data assistant that finishes your work for you.  As soon as it detects what you want to do, Flash Fill enters the rest of your data in one fell swoop, following the pattern it recognizes in your data. By the end of this online course you will be able to:

  • Split and combine cells
  • Use the Quick Analysis Tool to apply conditional formatting
  • Create hyperlinks
  • Group, view or hide multiple worksheets and workbooks
  • Protect worksheets and workbooks
  • Create Tables

Formulas and Data Analysis Online Course In this online course you will learn how to calculate values in cells using a variety of basic and complex functions, like Mathematical Functions, Lookup Functions and Logical Functions to name a few.  If you use Office Professional Plus, you will learn how to take advantage of Power View to discover insights about your data with interactive data visualization and presentation features that are easy to use.  Another powerful feature that will be explored in this workshop is Scenario Analysis which is very useful when analysing data with different variables. By the end of this online course you will be able to:

  • Calculate values using Excel Functions like functions, text functions, logical functions, financial functions, statistical functions and mathematical functions
  • Use different methods to sum totals
  • Use cell references and named ranges in formulas
  • Analyze data with multiple variables using Scenarios
  • Use Goal Seek to get desired results within your analysis
  • Use Power View to create a visual worksheet

PivotTables and PivotCharts Online Course In this online course you will learn how to summarize, analyze, explore, and present data quickly and easily using PivotTables.  You will also learn how to represent your PivotTable data graphically using Pivot Charts, which allows you to easily see comparisons, patterns, and trends. By the end of this online course you will be able to:

  • Define a PivotTable and describe its layout
  • Manually create PivotTables and Pivot Charts
  • Create PivotTables and Pivot Charts using Recommended Types
  • Modify and format PivotTables to improve their look and feel
  • Consolidate multiple worksheets into one PivotTable Report

No Comments Yet.

Leave a comment