This course enables the teacher to practice the learning process and activate learning according to differentiation
This training course aims to provide participants with all necessary practical skills to use Excel and will enable them to use Excel’s various tools including: methods to prepare and build equations, comparisons and pivotal tables ,in addition to extract the data needed to make decisions .So that, they will analyse the advanced data and extract outcomes to make the proper decision by using advanced mathematical formats and eventually will lead you to a scientific level ,which in turn, will improve your abilities from being an ordinary Excel User to an advanced Excel user.
Axes of this training course:
Part:1
_Advanced Formula and Functions.
A.Tips for Shortcuts.
B.Tools
C.IF Function.
D.Look up Functions.
E.Count Format.
F.Statical.
G.Maths.
H.Dates and Times.
I.Text.
J.Reference.
K.Information.
Part:2
Advanced Formatting Techniques.
A.Control Font Border.
B.Alignment tools.
C.Adjust numeric formats quickly.
Accentuate dynamic data with conditional formating.
E.Row,Column and sheet adjustment.
F.Display data as outline.
G.
H.Power _Formatting techniques.
Advantages:
