تفاصيل الدورة
This is a practical, hands-on course 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 and CONCATENATE; conditional functions like IF, IFERROR, SUMIF AND COUNTIF; lookup functions like VLOOKUP, INDEX and MATCH; and date functions like NETWORKDAYS. The course also covers charts, sparklines, conditional formating, and graphics. It then moves on to look at all of Excel's key facilities for working with tabular data: customized sorting and filtering, subtotalling and the use of Excel tables and pivot tables. All of the worksheets used by the trainer are available to students, enabling them to follow along and practice all of the techniques being demonstrated.
Last course update: December 2016
In the most recent update to this course, you will construct a basic invoicing system and at the same time get a chance to practice using advanced formulas, data validation and worksheet protection.
تحديث بتاريخ 22 March, 2018- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Mobility and Device Fundamentals Practice Exam Testprep Training16 USDمدة الدورة التدريبية: 1 To 2 Months
- Wicca for the Modern Age International Open Academy21 USD
66 USDمدة الدورة التدريبية: 30 Hours