*ഫീസ് ആനുകൂല്യങ്ങളെക്കുറിച്ചറിയുവാൻ വിളിക്കേണ്ട നമ്പർ ☎ : 8547118811 ◆ SAP കോഴ്‌സുകൾ ◆ Tally GST കോഴ്‌സുകൾ ◆ ഗവൺമെൻറ്‌ അംഗീകൃത കോഴ്‌സുകൾ ◆ Web Designing കോഴ്‌സുകൾ ◆ CAD കോഴ്‌സുകൾ ◆ Digital Marketing കോഴ്‌സുകൾ ◆ Accounting കോഴ്‌സുകൾ ◆ Graphic Designing കോഴ്‌സുകൾ ◆ Programming കോഴ്‌സുകൾ ◆ Software കോഴ്‌സുകൾ ◆ DTP കോഴ്‌സുകൾ 📞 കൂടുതല്‍ വിവരങ്ങള്‍ക്ക് ജി-ടെക്കിലേക്ക് വിളിക്കൂ ☎ : 8547118811

ADVANCED EXCEL

Duration : 1 Month / 36 hours

OBJECTIVE

ADVANCED EXCEL – GN9958F

This course is outlined in a way that it covers majority of enriched features in Microsoft Excel 2021, including Macros, Pivot tables, Audit and Analyze worksheets, Use Advance Formulas and Functions, work with multiple Worksheets and Workbooks etc., which in turn increases productivity, improves efficiency by streamlining the workflow thus becomes a major asset for professional employees.

COURSE OUTLINE

INTRODUCTION TO MS EXCEL AND UNDERSTANDING BASIC WORKING WITH IT 👈🏽

Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
Saving Excel File as PDF, CSV and Older versions
Using Excel Shortcuts with Full List of Shortcuts
Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
Using Paste Special Options
Formatting Cells, Rows, Columns and Sheets
Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
Page Layout and Printer Properties
Inserting Pictures and other objects in Worksheets
Working with Excel Properties

WORKING WITH FORMULAS/FUNCTIONS 👈🏽

Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc.
Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc.
Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc.
Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc.
Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc.
Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc.
Statistical Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, COUNTBLANK, COUNTIF, MAX, MAXA, MIN, MINA, etc.
Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE etc.
Financial Functions: PMT, PPMT, RATE etc.
Other Important Functions