MS Excel - Data Visualization with Excel Graphs and Charts
What you'll learn
- Learn Pictures,Icons,Screen shots,Venn diagrams
- Learn List,Process,Cycle,Hierarchy,Relationship,Matrix,Pyramid,Pivots & filter,Table,Graph,Slicers & timelines
- Learn business intelligence and understand the importance of data trending and create valuable data visualizations.
Requirements
- Basic knowledge of excel tools and functions
- Passion to learn and apply
- You will need MS Excel 2013 in your PC
Description
These online tutorials are indeed self-paced and one can easily make way and learn business intelligence and understand the importance of data trending and create valuable data visualizations.
The training will include Database introduction,Types of process flow,Types of charts in its introduction followed by Pictures,Icons,Screen shots,Venn diagrams illustrations. Then we will cover the smart art topics like List, Process, Cycle, Hierarchy, Relationship, Matrix, Pyramid, Pivots & filter, Table, Graph, Slicers & timelines. We will cover a lots of charts in this course such as Column & bar chart, Line & area graph, Pie & doughnut, Hierarchy chart, Statistical graph, Scatter plot, Water fall & stock charts, Combo charts, Radar chart, Speedometer, Maps, Thermometer, Mosaic & mekko charts, Sparklines, Line, Column,Win/loss.
The course is ideal for anyone interested in deeper knowledge in Excel. This course can be taken by experts too. Excel offers users 9+ varieties of Graphs and Charts. Of these, the most popular ones include:
Bar Graphs: The Bar Graph is best used when you have 2 or more disparate data series to compare. Each data series is projected as a horizontal bar on the XY axis. A good example of its usage would be to illustrate the count of employees within various departments of a company, where each count is projected as a bar on the graph. Excel allows you to project each bar in 2D, 3D, as a (default) rectangle shape, or as a cone, cylinder or pyramid.
Column Charts: As you may have guessed, a Column Chart is much like a Bar Graph, except it’s flipped by 900. Here, the data series are projected as vertical columns on the XY axis.
Line Charts: Line Charts trace the evolution of a data series over a period of time, so they show up as a staggered line on the X-Y axis. A good example of its usage would be to capture sales figures across the financial year, where the sales figures for each month forms a data value. In Excel, you can project this on a 2D or 3D axis.
Area Charts: These are much like the Line Charts, but highlight the entire boundary area surrounding the lines.
Pie Charts: These capture the data within a circular area, and are an excellent choice when projecting market shares, percentage-related reports, etc.
Pivot Charts: This combines the versatility of a pivot table with any other chart type listed above.
Who this course is for:
- Commerce students
- Students from the business administration
- Working professionals who go through the hectic working schedule of same repetitive work every day
- Anyone who wants to learn excel charts and smartart
Instructor
- 3.7 Instructor Rating
- 3,377 Reviews
- 99,285 Students
- 32 Courses
Banking and Finance School (BFS) offers a comprehensive range of professional Online Courses and Classroom Programs in Finance and Investment Banking. BFS is the Premier Finance Training Provider around the world. BFS has built a strong online platform and caters to self-paced learning, online learning and classroom mode of learning. Our courses are taught by industry experts. Our courses are driven by a constant need to be job relevant and stimulating, taking into consideration the dynamic nature of the Financial Services and Analytics market. We empower you with practical knowledge through our courses. With us, you get the intensive experience that will expose you to new challenges, and innovative ideas to perform better in your career. We've been offering our courses for more than a decade and our alumni are already doing a remarkable job across the globe. Our academic excellence goes beyond theoretical knowledge or setting you up to memorize things, our courses are built around applied Finance. We're proud of people who give us their time and commitment. We're looking for people who are ready to level up, who care to up-skill and re-skill with changing time and work demand. One thing we preach is that any learning needs focus, commitment, and consistency. Come and Join our courses and take a leap.