
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 |