fbpx
QUESTIONS
0 Quizzes
ENROLLED
0 Student
REVIEWS

Duration 03 Hrs

  • Introduction
  • Normal format
  • Number format
  • Conditional formatting
  • Search, replace and paste Option
  • Charts
  • hyper-link
  • Mathematical calculations
  • Excel functions
  • If function and count functions
  • Date functions
  • Small function and change of case
  • Merge names
  • Rounding functions
  • Database Functions 1
  • Database Functions 2
  • Sum Function with condition
  • Average Function with condition & Remove Duplicate
  • data validation
  • Data validation options 1
  • Data validation options 2
  • Calculate the salary budget
  • Conditions on cells
  • Data analysis
  • Vlookup search function
  • Hlookup search function
  • Advanced data filtering
  • Predict future values
  • Calculate project days
Read more

For any questions

Click or drag a file to this area to upload.

In this course, you will learn how to do advanced data analysis And extract results to make the right and appropriate decision by using advanced mathematical formulas and using the necessary options to analyze data and obtain answers to the most complex questions.

  • University students
  • Managers and employers
  • Accountants
  • Bank employees
  • Public and private sector employees

Instructor

A professional Excel trainer with training in Office programs, especially Excel.
I do courses in halls and online courses, customized programs or via distance learning platforms.

$160.00 $45.99

Explore Recent Courses

  • $59.99
Etabs And Safe (Live)
0 Lessons
0 Student
  • $59.99
Quantity Surveying (Live)
0 Lessons
4 Student