Cari cari info

TRAINING MICROSOFT EXCEL ADVANCED By Admin   August 27, 2020    No comments MICROSOFT EXCEL ADVANCED TRAINING Purnama Academy Bandung , Jakarta Training Provider Method : Online Training , Offline Public Training, Inhouse training Duration : Call/WA 0838-0838-0001 What is : Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. What You will learn : Able to use and apply Database function Able to use and apply Logical function (IF, AND) Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS) Able to use and apply Mathematical function (SUMIF, SUMIFS) Able to use and apply Lookup function (VLOOKUP) Able to use Auto and Advanced Filter command Able to validate data Able to apply Conditional Formatting Able to Protect worksheet and workbook Upon completion of this progr...