MS Excel Pivot tables & Charts for Beginners

Free Courses : MS Excel Pivot tables & Charts for Beginners

WHO'S THIS FOR?

This course is designed specifically for Beginners.

MS Excel

Excel is flexible and versatile tool for data analysis, data cleaning and data visualization. It is up to person imagination and creativity to capture utilization potential of Excel can offer. Flexibility means you can represent or format data as per your need and can do same task in more than one way.

Advantages of Excel

1. Excel helps to analyze data. Today companies have large data. It becomes easy to analyze and interpret large with the help of excel.

2. It helps to know the trend in the data with the help of charts, graphs, 3-D images, etc.

3. Excel helps in bringing data together. It is possible to import files and documents in excel.

4. We can work with others simultaneously with the help of an excel web app.

5. It helps to store data, do calculations, organize, and format the cells.

6. Excel file is secured with a password, therefore, security is assured.

Disadvantages of Excel

1. Can't handle large amounts of data.

2. File hanging, Corrupting issue if size is large.

3. Excel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.

My Opinion on Excel

Excel will always be a heart of organization. we have Tableau, Power BI tools which are becoming the backbone of Industry but Excel will always be a Part of the the industry. we can't ignore it.

COURSE STRUCTURE

Excel Charts

Pivots Tables

Reports

Pivot Charts

1. Membuat Login dan mengakses API twitter
2. CSRF Middleware untuk Slim
3. Memasang Text editor pada website dengan tinymce
4. Menambahkan Javascript pada website portofolio
5. Wordpress.com Website Development