- Full Price
- 1484 QR
- You Save
- 1435 QR
Fine Print
- Valid from 12 Feb – 12 Apr 2024
- Redemption period: 2 months from the deal’s start date
- Refunds/cancellations are NOT permitted once the voucher has been redeemed
- One voucher per person
- May buy multiple vouchers as gifts
- Upon successful completion of the course, you will be able to obtain your course completion e-certificate FREE of cost; a printed copy by post is also available at an additional cost of £9.99, and PDF Certificate at £4.99
- To successfully complete the course, students will have to take an automated multiple-choice exam; you will need to score 60% or above to pass the course; after successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement
- For information/inquiries, visit: Data Analysis in Excel Online Course or contact via https://www.janets.org.uk/contact/
- Internet access and audio required
- Not valid with other offers
- No cash value/No cash back/No refunds
How to Redeem:
- Go to https://www.janets.org.uk/redeem/
- Fill in the form
- Click SUBMIT
- Start the course
Please see the terms for all deals here
Highlights
Data Analysis in Excel Online Course
Pay QR49 instead of QR1484
- Looking to level up your data analysis game? Look no further than this amazing course for Data Analysis in Excel!
- Excel is a powerful tool that can be used to efficiently manage and analyze data; this course will teach you the fundamentals so you cant start your journey to become an Exel expert!
- This course will help you pick up the skills to visualize data with charts in Excel; you will also learn about Pivot Tables, Charts & working with multiple Workbooks
- In addition, you will learn about Lookup factions & how to use them
- By the end of this course, you will know the essentials of automating Workbook functionality
- Buying the course and planning to move? No problem! You can access the course from anywhere in the world
- You’ll be assessed as you progress throughout the course and you can easily track your progress in your user area
See the full course outline below!
Excel in MS Excel!
Modifying A Worksheet
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
Working With Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Analyzing Data
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
Visualizing Data With Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
Using PivotTables And PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Working With Multiple Worksheets And Workbooks
- Use Links and External References
- Use 3-D References
- Consolidate Data
Using Lookup Functions And Formula Auditing
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
Automating Workbook Functionality
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Creating Sparklines And Mapping Data
- Create Sparklines
- MapData
Forecasting Data
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
Assignment
Order Your Certificate
Company Profile
Janets is an online platform where learners come to learn and evolve. From the very beginning, the aim of this platform was to create an ever-growing community of avid learners instead of just delivering formulaic education. Focusing on making learners equipped for the future world, Janets provides quality education designed by expert instructors. This way, learners develop new skills at ease with the carefully structured bite-sized modules.
Janets aims to make education accessible to anyone and everyone by providing lessons worth learning and skills worth gaining. The ease of access to learning regardless of time, place, or medium is what learners love the most about Janets. The expert advice they receive from instructors and 24/7 customer assistance is remarkable, as mentioned by the valued learners who benefitted from this platform.