0
0 reviews
KLiC Advanced Excel
Excel skills are as important as the subject knowledge. Those who know Excel can find a better paying job. An ...
Excel Expert collects, edits, analyses data, creates data bases and reports. The conclusions made by the data expert are helpful for organizations to forecast the business speculations.
Show more
Instructor
Mahesh Nichit
Category
- Description
- Curriculum
- Reviews
Excel skills are as important as the subject knowledge. Those who know Excel can find a better paying job. An Excel Expert collects, edits, analyses data, creates data bases and reports. The conclusions made by the data expert are helpful for organizations to forecast the business speculations.
1. Basics of Data Management
2. Introduction to Computer Typing and Data Entry
3. Introduction to various Typing Methods
4. Introduction to Data Anaylsis
5. Apply Custom Formats and Layouts
-
14Apply Custom Data FormatsVideo lesson
-
15Use Advanced Fill OptionsVideo lesson
-
16Apply Advanced Conditional Formatting and FilteringVideo lesson
-
17Apply Custom Styles and TemplatesVideo lesson
-
18Use Form ControlsVideo lesson
-
19Prepare Workbooks for InternationalizationVideo lesson
-
20Use OutlinesVideo lesson
-
21Use Custom ViewsVideo lesson
6. Create Advanced Charts
7. Pivot tables and charts
8. Data Visualisation and Data Analysis
9. Use Scenarios
10. Manage and Share Workbooks
11. Typical Data Entry Projects
12. Create advanced formulas
-
48FunctionsVideo lesson
-
49Apply functions in formulasVideo lesson
-
50Mathematical FunctionsVideo lesson
-
51Financial functionsVideo lesson
-
52Useful Data FunctionsVideo lesson
-
53Some Other Useful FunctionsVideo lesson
-
54Look up data by using functionsVideo lesson
-
55Apply advanced date and time functionsVideo lesson
-
56Functions for Manipulating TextVideo lesson
-
57ArraysVideo lesson
13. Free and Open-Source Tools for Data management
14. Different Data Entry Methods and Data Cleaning
Please, login to leave a review
Related courses
Share
Course details
Duration
120 hrs
Lectures
71
Video
76 hrs
Level
Beginner
Basic info
Excel skills are as important as the subject knowledge. Those who know Excel can find a better paying job. An Excel Expert collects, edits, analyses data, creates data bases and reports. The conclusions made by the data expert are helpful for organizations to forecast the business speculations.
Popular courses
Archive
Working hours
| Monday | 7:00 am - 6.00 pm |
| Tuesday | 7:00 am - 6.00 pm |
| Wednesday | 7:00 am - 6.00 pm |
| Thursday | 7:00 am - 6.00 pm |
| Friday | 7:00 am - 6.00 pm |
| Saturday | 7:00 am - 6.00 pm |
| Sunday | 7:00 am - 1.00 pm |