Data Analysis in Excel Online Course!

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.

 

‘Like’ on Janets Facebook!

 

Data Analysis in Excel Online Course
Pay QR49 instead of QR1395

 

• 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! From the basics of creating tables and charts to advanced analysis techniques like pivot tables and macros, & more!
• You'll learn how to use Excel to extract insights from datasets, make informed decisions, and present your findings in compelling visualizations
• 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 full course outline below!

• Valid from 22 Feb - 22 Apr 2023
• 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:

1. Go to https://www.janets.org.uk/redeem/ 
2. Fill in the form
3. Click SUBMIT 
4. Start the course

Please see the terms for all deals here