Book a Free Video Consultation!
If you have any questions or would like to speak to one of our team before enrolling feel free to book a free video call with us by clicking the button below, we will be delighted to meet you on Google Meet!
CPD Course
Creating Reports in Excel
Develop practical knowledge and confidence in Creating Reports in Excel.
Creating Reports in Excel Objectives: This course provides basic and advanced training on how to easily organize & manage data using MS Excel.
See course content
Course Description
Buying for a team?
Choose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.
Develop practical knowledge and confidence in Creating Reports in Excel.
Creating Reports in Excel Objectives: This course provides basic and advanced training on how to easily organize & manage data using MS Excel.
Why this course matters
This course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.
What you will gain
- Use the key features and workflows covered in Creating Reports in Excel with greater confidence.
- Apply the tools and techniques to practical business tasks.
- Recognise common mistakes and work more efficiently in day-to-day use.
Who is this course for?
This course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.
Course at a glance
- Format: self-paced online learning.
- Professional development: CPD course.
Creating Reports in Excel
Objectives: This course provides basic and advanced training on how to easily organize & manage data using MS Excel.
Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.
Unit Contents:
1. Basic Excel Reports
In this topic you will cover:
1. Basic Excel Reports
1.1 Overview
1.2 Interface
1.3 File Menu 1
1.4 File Menu 2
1.5 Home Menu
1.6 Insert Menu
1.7 Page Layout Menu
1.8 Formulas Menu
1.9 Data Menu 1
1.10 Data Menu 2
1.11 Review Menu
1.12 View Menu
1.13 Templates
1.14 Dates
1.15 Numbers
1.16 Text
1.17 B Calculations-Manual
1.18 Calculations
1.19 Page Set Up
1.20 Print Settings
1.21 Conclusion
2. Advanced Excel Reports
In this topic you will cover:
2. Advanced Excel Reports
2.1 Overview
2.2 Calculations Absolute References
2.3 Calculations Relative References
2.4 Using Logical Formulas
2.5 Using Text Formulas
2.6 Using Lookup Formulas
2.7 Using Financial Formulas
2.8 Using Date and Time Formulas
2.9 Sorting Data
2.10 Formatting Data into Tables
2.11 Using Pivot Tables 1
2.12 Using Pivot Tables 2 Design
2.13 Formatting Data as Charts
2.14 Formatting as Data as Maps
2.15 Formatting Data as Formal Reports
2.16 Formatting Data for Other Office Documents
2.17 Cell Protection and Collaboration
2.18 Cell Protection and Collaboration 2
2.19 Interface with Google Sheets
2.20 Conclusion
Continue your learning
Part of this learning pathway: Microsoft Office & Windows
Course pathway: eBSI SME Academy > Microsoft Office & Windows > Creating Reports in Excel
Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.
Your questions, answered
Does the course include a certificate?
The course assessment leads to a downloadable digital PDF CPD Certificate of Completion. See the course description for the CPD credits awarded.
What is CPD?
CPD stands for Continuing Professional Development. It is the ongoing learning that helps you maintain and develop the knowledge and skills you use in your work. Courses, workshops and other learning activities can contribute to your CPD record.
Can I ask a question before enrolling?
Book a free video consultation to discuss your goals and course choice.