VALENTINES DAY SPECIAL - 50% off All Courses at Checkout - click here to apply or use code VALENTINE2024 at Checkout!

Creating Reports in Excel - eBSI Export Academy
Creating Reports in Excel - eBSI Export Academy
Creating Reports in Excel - eBSI Export Academy
Creating Reports in Excel - eBSI Export Academy

 

Book a Consultation

Creating Reports in Excel

Vendor
eBSI Export Academy
Regular price
€40.00
Sale price
€40.00
Tax included. Shipping calculated at checkout.

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