Maliyyə üzrə Excel təlimi - Online
|
Excel for Finance ,Budget,Purchase Department |
|
|
|
1 Level |
|
1)Setting up profile |
|
a)Building your own quick access toolbar |
|
b)Calculation options |
|
2)Keyboard shortcuts. |
|
a)Navigation |
|
b)Highlight and moving data |
|
c)Spreadsheet manipulation |
|
d)Print set up for perfect printing |
|
3)Working with multiple views,worksheets,freeze panes |
|
a)Customize view for worksheet |
|
b)Formatting worksheet |
|
c)Using names to increase formula efficiency(creating cell and range names) |
|
d)Protect workbook and sheet |
|
4)Formating cells and ranges |
|
a)Using special paste options |
|
b)Using Go to Special options |
|
c)Merge and wrap texts |
|
D)Using Auto fill |
|
E) Using Data Validation |
|
F)Find/Replace |
|
G)Table format (Ctrl+T) |
|
H)filtering, sorting,group/ungrouping |
|
I)Subtotal menyu |
|
2 Level |
|
1)Relative and absolute referencing |
|
2)Logical statement |
|
a)IF,AND,OR,NOT,EXACT,IFERROR functions |
|
b)MAX,MIN,AVERAGE |
|
c)SUMIF(S),COUNTIF(S) |
|
3)Data mining in Excel |
|
a)VLOOKUP,HLOOKUP |
|
b)CHOOSE |
|
c)INDEX,MATCH |
|
d)OFFSET |
|
4)Working with text and dates in Excel |
|
a)Text functions(UPPER,LOWER,PROPER,CONC.,LEFT,RIGHT,MID,LEN,NUMBERVALUE,TRIM) |
|
b)Date Functions(EDATE,EOMONTH,NETWORKDAYS,YEARFRAC) |
|
5)Finacial functions |
|
6)Conditional Formatting |
|
3 Level |
|
1)Building flexible charts in excel |
|
a)Set up charts |
|
b)Formatting Chart |
|
c)Add and modify chart elements |
|
2)Creating Pivot tables and charts |
|
3)Analyzing |
|
a)Creating Scenarios |
|
b)Goal seeks |
|
c)Sensitivity analysis in Excel |
|
d)Consalidate in excel |
|
4 Level |
|
1) Create income statement ,cash flow in Excel |
|
2)Monthly Budgeting&Forecasting Model |
|
3) Finance and Budget dashboards |