Description: Description: Description: Description: C:\Users\Joint Director\images\maintopFinal.jpg

 

4

7

 

Advance MS Excel 2013

Financial & No Financial Tools and Techniques

 

 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

 

Starting From

Timings

Last Date of Registration

Fee

22-10-16

1000-1600

(Sat - Sun)

20-10-16

Rs:10,000/-

Per Participant

* 10% Discount for  group of two or more

Duration = 18 Hours

Description: Description: Description: Description: C:\Users\Joint Director\images\leftPortion.gif

Home | Site Map | Contact Us | About Us

SKILL DEVELOPMENT COUNCIL
Plot No: 205, Korang Road, I-10/3, Islamabad| 051-4440719 / +0331-7888990 - 4
Copyright 2008 Skill Development Council