Dear All STEP AHEAD FINANCIAL CONSULTANT inawaletea training ya Advanced Excel inayofanyika dodoma kesho 01.06.2019 na pia tunaweza wafanyia training kwa maofisi yatakayo hitaji minimum in group of five people Kama mtapenda mnaweza nichek 0717385177 for arrangements
WHAT WILL YOU LEARN?
Some of the useful features and techniques which you will learn in our training will include but not limited to the following:-
1. How to use advanced Pivot tables and its functionalities
2. Data consolidation
3. How to create Good looking Excel Dashboards
4. How to automate aging analysis in Excel
5. How to use lookups functions
6. How to use advanced IF functions, such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, etc.
7. How to combine IF and AND/OR/NOT functions
8. Data analysis in Microsoft excel
9. How to use reference cell formulas using Relative and absolute cells
10. How to prepare projected financial statements in excel
11. How to automate the General ledger and final accounts in excel
12. AND SO MANY OTHER USEFUL EXCEL FEATURES AND TECHNIQUES
PLEASE COME WITH YOUR LAPTOP.
TARGET POPULATION:
Anyone who uses Microsoft Excel in his or her daily tasks..
N.B: TRAINING CERTIFICATES WILL BE ISSUED AFTER TRAINING.
TRAINERS:-
1: YUSTINO NYENDEZA (ACCA, ACPA)
2: MASHAKA SHABANI (MBA TLM
WHAT WILL YOU LEARN?
Some of the useful features and techniques which you will learn in our training will include but not limited to the following:-
1. How to use advanced Pivot tables and its functionalities
2. Data consolidation
3. How to create Good looking Excel Dashboards
4. How to automate aging analysis in Excel
5. How to use lookups functions
6. How to use advanced IF functions, such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, etc.
7. How to combine IF and AND/OR/NOT functions
8. Data analysis in Microsoft excel
9. How to use reference cell formulas using Relative and absolute cells
10. How to prepare projected financial statements in excel
11. How to automate the General ledger and final accounts in excel
12. AND SO MANY OTHER USEFUL EXCEL FEATURES AND TECHNIQUES
PLEASE COME WITH YOUR LAPTOP.
TARGET POPULATION:
Anyone who uses Microsoft Excel in his or her daily tasks..
N.B: TRAINING CERTIFICATES WILL BE ISSUED AFTER TRAINING.
TRAINERS:-
1: YUSTINO NYENDEZA (ACCA, ACPA)
2: MASHAKA SHABANI (MBA TLM
