Excel Level 2
Availability: Unavailable |
Money-Back Guarantee if not satisfied
If you don’t benefit from our program, your investment is safe. We offer a full refund to ensure your confidence in our service.
Certified By the TVTC
Our program is recognized and accredited by the technical and Vocational Training Corporation, ensuring high-quality learning and professional standards.
Flexible Payment Options, Including Installments
Choose the payment plan that suits you best. We provide a variety of payment methods, including installment options, to make it easier for you.
Live Online Learning Experience
Enjoy the convenience of learning from anywhere with our interactive, live virtual zoom sessions led by expert instructors.
Targeted Groups
Those interested in
creating dashboards and advanced visualizations
Employees whose work involves data analysis and report creation
Individuals with basic Excel knowledge who wish to advance their skills
Individuals aiming to
improve productivity using advanced Excel tools
At the end of this program, the participants will be able to:
1. Work
with various types of functions (logical, text, date, and specialized).
2.
Analyze data using
sorting, filtering, and conditional formatting.
3. Create pivot tables
and analyze their data.
4.
Present data using
pivot charts and timelines.
5. Design professional dashboards using pivot tables and charts.
6. Improve work efficiency by managing files and prints professionally.
Modules:
Explore Each Module and Uncover New Knowledge.
Course Prerequisites:
- Basic computer skills.
- Familiarity with navigating computer operating systems.
- Basic internet usage skills.
- Knowledge of Excel basics in Excel Level 1, such as data entry and using simple formulas.
- Working with ranges.
- Using specialized functions.
- Working with logical functions.
- Working with date and time functions.
- Working with text functions.
- Sorting, filtering, and summarizing data.
- Creating and editing tables.
- Applying conditional formatting.
- Creating a pivot table.
- Analyzing pivot table data.
- Presenting data using pivot charts.
- Filtering data using timelines and slicers.
- Using pivot tables and pivot charts.
- Designing dashboards using pivot tables and charts.
- Previewing and printing files.
- Setting up page layouts.
- Configuring headers and footers.
- Managing worksheets.
- Managing workbook and worksheet views.
- Managing workbook properties.