Topics 

Changes in User Interface

·         The File Menu Becomes the Backstage View

·         The Ribbon Interface and Quick Access Toolbar

·         Using Other Excel Interface Improvements  

·         Customizing the Ribbon  

·         Keyboard Shortcuts  

·         The Excel Options Dialog  

·         The Big Grid and File Formats  

Calculating with Excel

·         Understanding Formulas

·         Controlling Formulas

·         Understanding Functions

·         Using Everyday Functions: Math, Date and Time, and Text Functions

·         Using Powerful Functions: Logical, Lookup, and Database Functions  

·         Using Financial Functions

·         Using Statistical Functions

·         Using Trig, Matrix, and Engineering Functions

·         Using Logical formulas

·         Connecting Worksheets, Workbooks, and External Data

·         Using Super Formulas in Excel  

·         Using Names in Excel  

·         Fabulous Table Intelligence

Business Intelligence  

·         Sorting Data

·         Removing Duplicates and Filtering  

·         Using Automatic Subtotals

·         Using Pivot Tables to Analyze Data

·         Using Slicers and Filtering a Pivot Table

·         Mashing Up Data with Power Pivot

·         Creation Pivot data charts to Analyze Data

·         Using What-If, Scenario Manager, Goal Seek, and Solver

·         Automating Repetitive Functions Using VBA Macros

·         More Tips and Tricks for Excel 2010 

·         Tour of the Best Add-Ins for Excel

·         Protection and Security  

Visual Presentation of Data

·         Formatting Worksheets  

·         Using Data Visualizations and Conditional Formatting

·         Using Excel Charts

·         Using Spark lines

·         Using Smart Art, Shapes, WordArt, and Text Boxes

·         Using Pictures and Clip Art  

Business Solution

·         Printing  

·         Building Dashboard and KPI Reports

·         Importing & Exporting Data into Excel and to other application like AutoCAD

·         Button creation techniques to facilitate data input

·         Extracting data values from text

* 10% Discount for  group of two or more

Duration        =          02 weeks