Course Information
Course Overview
In this Excel course, you learn every essential thing about Excel and you learn to do your work and projects with Excel
This course was designed for all who do not have any background but want to learn Excel very well and do professional and real-world projects. So you will learn Excel from very basic concepts professional concepts, functions and formulas. In this course, the approach is simple: learning useful and practical techniques and tools. So we avoid wasting our time on useless concepts which are not used in real projects. This course teaches you every dimension of Excel in which you learn how to use special methods, codes and tricks to have write complex codes with least codes and finally create professional programs, apps and games. Generally, some of the topics and concepts you learn in this course are as the following:
· Create Functions
· Create Formulas
· If, VLOOKUP and other Essential Functions
· Data Management
· Data Analysis
· Adjusting Worksheets
· Printing
· Formatting
· Create Pivot chart
· Create Pivot table
· Use Macros
· Secure your workbooks and Worksheets
· Financial formulas and functions
· And much more
Course Content
- 10 section(s)
- 69 lecture(s)
- Section 1 Introduction Of Excel
- Section 2 Entering Data
- Section 3 Formulas and Functions
- Section 4 Formatting
- Section 5 Adjusting Worksheets
- Section 6 Printing
- Section 7 Charts
- Section 8 Worksheets view
- Section 9 Multiple Worksheets and workbooks
- Section 10 If and VLOOKUP functions
What You’ll Learn
- Use Formulas
- Use variety of function
- Create professional charts and tables
- Create Pivot charts and Pivot Tables
- Secure you workbooks and worksheets
- Do data management
- Do data analysis
Skills covered in this course
Reviews
-
SSitun Krushna Sahu
It is Good
-
SSachin Sonawane
Good / Amazing
-
AAbhinaya G
Very useful Course !
-
PPhurpa Doma Bhutia
I love this course and i got lots knowledge about excel. Thank you.