About the course: The broad benefits of learning Excel for students as well as for professionals include faster and more accurate decision making, quick calculations, seamless data visualization, and a lot more. Many candidates across the globe are waking up to these benefits and starting to master the art of Microsoft Excel.
Learning Objective:
- Indicate the names and functions of the Excel interface components.
- Enter and edit data.
- Format data and cells.
- Construct formulas, including the use of built-in functions, and relative and absolute references.
- Create and modify charts.
- Preview and print worksheets.
Duration: 25+ Hours
Prerequisites: While it may seem intimidating at first, once you have mastered the basics of Microsoft Excel, it can make your life a lot easier. It can boost your employability and career prospects, whilst also being a useful tool to analyze data in everyday life, such as when managing personal finances.
Topics to be covered:
Introduction to excel
- Working with Multiple
- worksheets
- String Function & Their application
- Data Function & Their applications
- Fun with Charis
Introduction to reporting
- Counting functions and their applications
- working with ranges
- working with Tables
- Pivot your table
- conditional formatting and many more