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.
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.
Lectures | |||
Quizzes | |||
Duration | 15 | ||
Skill level | |||
Language | English And Arabic | ||
Students | |||
Assessments |
Advantages:
©2024 BACT Education | All Rights Reserved.
Attested by KHDA (Knowledge and Human Development Authority) in Dubai, UAE