LBS Advanced Training Institute
CERTIFICATE IN ADVANCE EXCEL
CERTIFICATE IN ADVANCE EXCEL
BASIC MICROSOFT EXCEL SPREADSHEET BASIC. CREATING, EDITING, SAVING & PRINTING SPREADSHEET. WORKING WITH FUNCTION & FORMULAS. USE THE FUNCTION WIZARD, COMMON FUNCTIONS (AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTIF, ROUND, INT), NESTED FUNCTION, NAME CELLS/RANGES/CONSTANTS. RELATIVE, ABSOLUTE, MIXED CELL REFERENCE:><, OPERATORS, LOGICAL FUNCTION USING IF, AND, OR, NOT THE LOOKUP FUNCTION, DATA AND TIME FUNCTIONS, ANNOTATING FORMULAS ADVANCE EXCEL- DATA ENTRY, VLOOKUP, HLOOKUP, PIVOT TABLE, MIS REPORT, DATA TABLE, GOAL SEEK, SCENARIO MANAGER, FLASH FILL, GOOGLE SHEET, GOOGLE, FORM, GOOGLE DRIVE INTERNET BROWSING, SURFING, EMAILING, HANDLING & DOWNLOADING
N/A
N/A
N/A
Duration: 3 Months