This is a practical, hands-on work for Excel middleweights looking to gain more confidence in using the program. It provides step-by-step practice in building formulas with useful text functions like LEFT, RIGHT, MID, PROPER & CONCATENATE; conditional functions like IF, IFERROR, SUMIF AND COUNTIF; lookup functions like VLOOKUP, INDEX & MATCH; & date functions like NETWORKDAYS. The work also covers charts, sparklines, conditional formating, & graphics. It then moves on to look at all of Excel's key facilities for working with tabular knowledge: custom-made sorting & filtering, subtotalling & the use of Excel tables & pivot tables. All of the worksheets used by the trainer are obtainable to students, enabling them to follow along & practice all of the techniques being demonstrated.
udemy coupon :https://www.udemy.com/excel-2013-intermediate/?couponCode=EDEN1