Advanced Excel

Tutors Valley are offering professional Excel Training. This includes Using formulas, Cell Styles, About Rows & Columns Goal seek, Pivot tables, Transferring of data b/w sheets, Data Table, Solver

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

327
Courses

1403
Members

120
Subjects

E
N
Q
U
I
R
Y