Advanced Microsoft Excel 2013 Tutorial Video DVD

Alberto Torresi Goro Brown Boots Buy Alberto Torresi Goro Brown Boots online at best price in India from ShopClues.com. Get excited offers, read Alberto Torresi Goro Brown Boots reviews & compare prices online. Avail Fast delivery & CoD options across India. Product ID : 4013642
Rs.350 Rs.950 63% off

Item is available at 122003Change

  • Free Shipping
  • Eligible for Cash on Delivery
  • Delivery Between 7 - 9 days
  • 100% Guarantee
  • Easy Returns and Replacement

    You can place a return request within 10 days of order delivery.

    In case of damaged/missing product or empty parcel, the return request should be filed within 2 days of delivery.

    Know More
Product Details:

Advanced Microsoft Excel 2013 Tutorial Video DVD

Key Feature

Brand :   Easy learning DVDs

Educational CD Specificaton

Ideal Course :   BANK

Media Specifications

Subject :   Chartered Accountancy

Duration: 10 hours - 128 tutorial videos | 

In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.

You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow.

By the completion of this computer based training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.

00. Free Videos From This Course

01. Getting Started

02. Using Mathematical Functions

03. IF Functionality

04. Performing Data Lookups

05. Sparklines

06. Further Mathematical Functions

07. Outlining

08. Scenarios

09. Custom Views

10. Functions For Manipulating Text

11. Arrays

12. Useful Data Functions

13. Some Other Useful Functions

14. Auditing And Troubleshooting Formulas

15. PivotTables

16. PivotCharts

17. Goal Seek And Solver

18. Macros

19. Summary And Credits

 

Product added to cart