t-valley Preloader

Advanced Excel

Tutors Valley provides Advanced Excel Training. If interested, please contact us at 01932796497 or fill the student registration form in our website.

SYLLABUS

IT Courses

PRICE

£100

Duration: 24 Hours 

Module: ADV MS EXCEL

 

Sl no Topic to be Covered Theory Practice sessions
1 Introduction to excel, Describe Text Formatting options Theory Practice sessions
2 Using formulas,Cell Styles,About Rows & Columns Theory Practice sessions
3 Conditional formating,  If statements,Date Function Theory Practice sessions
4 Creating Chart, Types of Chart,Text Fuctions Theory Practice sessions
5 Advance Filter, sub-totals,Concatenate,Header and Footer Theory Practice sessions
6 Consolidate,Text to columns,Count Function,Scenario manager Theory Practice sessions
7 Count functions,sumifs, Data Validation Theory Practice sessions
8  Goal seek, Pivot tables, Transferring of data b/w sheets,Data Table,Solver Theory Practice sessions
9 Importing data from External Sources,Templates and styles,Vlookup,Hlookup Theory Practice sessions
10 Macros and Custom Controls,Comment,Security and Proofing Theory Practice sessions
11 Sheet links, freezing panes, split windows, arrange windows, arrange windows, Advanced features in excel. Theory Practice sessions
12 Assignment on M.S Excel. Theory Practice sessions

1403
Members
327
Courses
120
Subjects