Product Sold Out
Inclusive of all taxes
English हिंदी
Original Price |
|
Deal Price | ||
---|---|---|---|---|
₹438 |
|
₹430 |
*All discounts can be availed in the cart page
This product is currently out of stock
If applicable customer can place a return/replacement request within 10 Days of order delivery.
In case of damaged/missing/wrong product or empty parcel, the return/replacement request should be placed within 2 days of delivery.
Know MoreDuration: 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
Key Feature | |
Brand | : Easy learning DVDs |
Educational CD Specificaton | |
Ideal Course | : BANK |
Media Specifications | |
Subject | : Chartered Accountancy |
More Details |
|
Maximum Retail Price (inclusive of all taxes) | Rs.1188 |
Common or Generic Name | - |
Net Contents / Net Quantity | - |
Manufacturer's Name and Address | - |
Packer's Name and Address | - |
Marketer's name and Address | - |
Importer's Name and Address | - |
Country of Origin / Manufacture / Assembly | India |