Microsoft Advance Excel

Sinet has well experienced academic team to deliver advanced office management technologies..



COURSE DETAILS

Duration: 30 hours *

Class: Regular / Week ends / Evening / Sundays

Daily Time: 1.5 hours / 3 hours / half day / Full day

Certification: Sinet Merit Certification

JOIN NOW
* Sinet course can be customized as per student requirement.

JOB PROFILE

Office Automation Assistant

Spread sheet Manager

Front Office Executive




MICROSOFT ADVANCE EXCEL COURSE CONTENTS

( Can be customized )



1.HOME

RIBBONS, FILE MENU ,CLIP BOARD,FONT,ALITGNMENT,NUMBER,STYLES (WITH EXERCISE)

2. HOME AND INSERT IN ADVANCED EXCEL

CELLS, EDITING,TABLE

3. INSERT IN ADVANCED EXCEL

CHART, FILTER, LINK,TEXT,SYMBOLS

4. PAGE LAYOUT IN ADVANCED EXCEL

PAGE SET UP, SCALE TO FIT, SHEET OPTIONS

5.FORMULA (1) IN ADVANCED EXCEL

NORMAL FUNCTIONS

6. FORMULA (2) IN ADVANCED EXCEL

LOGICAL FUNTIONS

7. FORMULA (3) IN ADVANCED EXCEL

MATHEMATICAL FUNTIONS

8. FORMULA (4) IN ADVANCED EXCEL

LOOKUP FUNCTIONS,LOOKUP,VLOOKUP& HLOOKUP FUNCTION,DOUBLE VLOOK UP& DOUBLE HLOOKUP FUNCTION

9. FORMULA (5) IN ADVANCED EXCEL

SUM FUNCTIONS, SUM, SUMIF, SUMIFS

10. FORMULA (6) IN ADVANCED EXCEL

COUNT FUNCTIONS,COUNT,COUNTA,COUNTBLANK,COUNTIF,COUNTIFS

11. FORMULA (7) IN ADVANCED EXCEL

DATE AND TIME FUNCTIONS

12. FORMULA (8) IN ADVANCED EXCEL

MORE FUNCTIONS ,DEFINE NAME,FORMULA AUDITING,CALCULATION

13. DATA (1) IN ADVANCED EXCEL

GET EXTERNAL DATA ,CONNECTION,SORT&FILTER

14. DATA (2) IN ADVANCED EXCEL

DATA TOOLS ,OUT LINE

15. REVIEW (1) IN ADVANCED EXCEL

PROOFING,LANGUAGE,COMMENT,TRACKING

16. REVIEW (2) IN ADVANCED EXCEL

CHANGES,COMPARE,PROTECT SHEET,PROTECT WORKBOOK

17. VIEW IN ADVANCED EXCEL

WORKBOOKS VIEW,SHOW,ZOOMS,WINDOW,MACRO




SINET IS AN ISO 9001 : 2015 CERTIFIED SOFTWARE TRAINING INSTITUTE

(Division of Sinet Education)

www.sinetedu.com