Coming Soon!
Course Objectives
Master advanced formatting skills, protect your workbook, use functions to analyse data and build reports and graphically present your data. Every video will have its own supporting files for practice.
Learning Outcomes
- Select and highlight cells and sheets in excel.
- Protect cells , rows, columns, worksheets and multiple worksheets in excel.
- Validate cells in excel.
- Use Advanced cut, copy paste in excel.
- Format cells in excel (date, time, text, numeric, currency, percentage, fractions).
- Format cell emphasis including: color, shading, merge, borders, comments.
- Apply Conditional formatting.
- Use absolute and relative cell referencing, named cells and ranges in excel formulas and functions+ types of errors and formula auditing.
- Use mathematical functions (INT, ROUNDUP, ROUNDDOWN, SUMIF, SUMIFS, RANDBETWEEN).
- Use statistical functions (COUNT, COUNTA, COUNTBALANK,COUNTIF,COUNTIFS, SUMIF,SUMIFS, RANK).
- Use Logical functions 1,2 (IF, NEST IF, AND,OR, IFERROR, ISERROR).
- Use text functions (LEFT, RIGHT, MID, SEARCH, TYPE, REPLACE, SUBSTITUTE, TEXT, LEN, &).
- Use date and time functions (DAY, MONTH , YEAR , HOUR, MINUTE, SECOND, TIME, YEARFRAC, manipulate date and time formulas).
- Use lookup functions (VLOOKUP, HLOOKUP).
- Use Index-match function (INDEX, MATCH).
- Prepare summaries using functions.
- Create pivot table to summaries data.
- Use subtotal function.
- Use what-if analysis and scenario manager.
- Present data using charts including pivot chart & format charts.
- Create dashboards.
Target Audience
Finance professionals, Sales professionals, Marketing professional, HR professionals.
Course Curriculum
Available in
days
days
after you enroll
- M1-1 Selection and highlighting cells and sheets in excel
- M1-2 Protecting cells , rows, columns, worksheets and multiple worksheets in excel
- M1-3 Validate cells in excel
- M1-4 Advanced cut, copy paste in excel
- M1-5 Format cells in excel ( date, time, text, numeric, currency, percentage, fractions)
- M1-6 Format cell emphasis (including: colour, shading, merge, borders, comments)
- M1-7 Conditional formatting
Available in
days
days
after you enroll
- M2-1 Use absolute and relative cell referencing, named cells and ranges in excel formulas and functions
- M2-2 Use mathematical functions
- M2-3 Use statistical functions 1
- M2-4 Use statistical functions 2
- M2-5 Logical functions 1
- M2-6 Logical functions 2
- M2-7 Use date & time functions 1
- M2-8 Use date & time functions 2
- M2-9 Use lookup functions
- M2-10 Index-match functions
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Your Trainer Mrs. Shatha Idresi
Mrs. Shatha has more than 15 years' experience in teaching ICT, IT skills in international schools, she has a certificate in teaching and learning from Cambridge, and certified ICDL trainer.