Excel 2013- Advanced Formulas and Functions

photo-size-Recovered
photo-size-Recovered
< >

DVD Quantity

1 DVD

Details

Subject: Business Spreadsheets IT
Duration: 5h 26m
Level: Advanced

Publisher

lynda.com

  • 100% Delivery Guarantee - All Over Bangladesh
  • Free Replacement
  • Cash on delivery

Price
100.00

Buy Now

Quantity

Add to Wishlist

Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his
popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and
functions in Excel and shows how to put them to their best use. The course starts with a review of the more
basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel
data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with
Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and
math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples
that transition effortlessly to real-world scenarios.

Topics include:
Displaying and highlighting formulas
Converting formulas to values
Creating 3D formulas to gather data from multiple sheets
Understanding the hierarchy of operations in formulas
Using absolute and relative references
Creating and expanding the use of nested IF statements
Looking up information with VLOOKUP, MATCH, and INDEX
Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
Analyzing data with the statistical functions
Performing basic math
Calculating dates and times
Editing text with functions
Checking for errors with formulas

Seven Easy Steps to Complete the Buying Process

  1. Click buy now option of the product that you want from category page.
  2. Check the desired product > Read the description > Select the quantity > Click Buy Now.
  3. Recheck the product/products that you are willing to buy, if you want to add more products on your shopping cart then continue your shopping or click Checkout to complete this step of buying process.
  4. Select delivery type, Inside Dhaka or Outside Dhaka and click Continue.
  5. Login your account or click on Register to create a account.
  6. Fill out all the information such as name, email address, cell number, address and password that you want to set for itnextdigital.com account.
  7. Select the payment method and click place order.
  •  Offer applicable for ITNextDigital.com members only.
  •  Home delivery is available.
  •  Delivery charge: Inside Dhaka-30 Taka,Outside Dhaka-50 Taka.
  •  Product delivery may be interrupted or delayed due to natural disaster or in-case of political unrest.
  •  In case of delivery outside Dhaka,Chittagong & Sylhet, customers may have to collect certain products from the nearby courier service office.

If the delivery location is outside of Dhaka city, advance payment is a requirement.