課程介紹

What are the chart types I will learn in this course?

Excel offers the following major chart types. All of these are covered in this course

    Column Chart

    Line Chart

    Pie Chart

    Doughnut Chart

    Bar Chart

    Area Chart

    XY (

…[更多細節]

哪些人適合這堂課？

• Anyone curious to master charts in excel from beginner to advanced in short span of time

學習目標

• Learn the techniques to communicate clear and concise message through your charts
• Learn how to create 25+ chart types in Excel
• Learn by Doing. Course comes with numerous exerises sheets to practice learnt concepts
• Master the art of creating impactful Excel charts
• Get familiar with all the elements of charts in Excel
• Become proficient in using powerful tools such as pivot tables and pivot charts
• Master newly introduced chart types such as sunburst, treemap and waterfall chart
• Learn how to create cool infographics to represent data

課程介紹

Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! 

Significantly Improve your Reports by using Advanced Excel Graph Techniques. 

This Course Includes:

Downloadable Wor

…[更多細節]

哪些人適合這堂課？

• Controller or financial analyst responsible for creating monthly, quarterly or yearly reports
• Finance or department manager looking for new effective visualization methods
• A student planning to work as a business or financial analyst or in any function that will require data visualization
• All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course

學習目標

• Significantly improve your Excel reports to create more powerful graphs that communicate your information in the best manner
• Learn creative & simple techniques that allow you to create your own Excel charts from scratch
• Create dynamic Excel charts. Why? To save time! I have seen many cases where people are unnecessarily manually updating graphs. This costs considerable time and nerves.
• Impress your management by including new Excel graphs in your reports (such as my Pin chart for variances)
• Apply Best Practice methods to considerably improve the design of your Excel charts and tables
• Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most
• Use effective Chart Combinations that are pivotal to management reports
• Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year
• Learn by doing. Download the Demo Excel Workbook and follow each section with me. Once you complete a section, you will do an exercise to test your understanding. Learning by doing works best!
• Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas.
• Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports

課程介紹

Welcome to the course,

Start your excel Journey by Harnessing the Full Potential of EXCEL today!!

The World is moving at an unprecedented speed in the field of Data Analytics & Excel being one of the major tools. It becomes very important to learn

…[更多細節]

哪些人適合這堂課？

• Working Professionals [DATA ANALYST, RESEARCH SPECIALIST & BUSINESS MANAGERS] beginning their Data journey, High school students ,Professors , Graduates & Post Graduates and people from all phase of life who have the curiosity of learning EXCEL

學習目標

• A Solid understanding of Excel
• Basics of Excel from Scratch.
• All Important 33+ Formulas in Excel which are very useful in day to day life.
• Making your data look good & re presentable by using Formatting & Advance Formatting.
• Explore all the things that can be done using Excel .e.g: Speaking Cells in Excel [ 21 Things that you can do in Excel are included in this section ]
• Visualization of the data using Excel Charts and deriving Important Insights from them.
• Harness the power of Pivot Charts by introducing Slicers and deriving Insights from them.
• Advance Excel : Linear Regression, Goal Seeker & Solver by working on Real Life Consulting Projects.
• Introduction to BUSINESS INTELLIGENCE DASHBOARDS & building them from Scratch.
• Solve 2 Real life Case Studies one building DASH BOARD from scratch for a school and putting hands on a Real Life consulting project for a Fertilizer Company and recommending them with Insights.m
• Macros: Learn to Automate things by recording a Macro and assigning a button to it.
• 30+ Excel shortcuts useful in daily Life.

課程介紹

Want to Include impressive Waterfall / Bridge Charts in your Corporate Reports?

Waterfall graphs or bridge charts provide great visualizations for Management Reports.

In this course you learn how to include different variations of the Waterfall Ch

…[更多細節]

哪些人適合這堂課？

• You want to learn how to create different variations of the Waterfall chart in Excel
• Financial Analysts & Controllers
• Persons responsible for preparing Management Reports
• Persons interested to learn new Excel techniques to create impressive charts

學習目標

• Include impressive & dynamic variations of the Waterfall chart in your Management Reports
• Create the standard Waterfall Chart from scratch (that works with negative values as well)
• Download the Excel Template and use it now for your reports
• Optimize the Waterfall chart for presentations
• Create Vertical Waterfall charts from scratch (that works with negative values as well)
• Create Stacked Waterfall Charts
• Learn advanced Excel Chart techniques that you can apply to your other charts to improve your reports

課程介紹

Do you want to improve your charting and visualization skills in Excel?  Do you want to master the common and lesser well-known charts available in your spreadsheets? Would you like to be able to create non-standard visually effective Excel charts an

…[更多細節]

哪些人適合這堂課？

• Those new to creating charts in Excel
• Those that want to explore the use of Visualizations in Excel
• Those that want to learn to create stunning charts
• Those that want to learn how to create basic interactive Dashboards
• Those that want to learn to create advanced Excel Dashboards
• Students looking for an engaging, hands-on, and interactive course
• Those looking to skill up in Excel in an area where the skills are in high demand

學習目標

• Learn the When, Why and how to use Excel Standard Charts
• Learn to create eye catching dynamic non standard Excel Charts
• Learn to create interactive dashboards with no coding or VBA
• Learn to create dashboard that track KPI’s
• Learn to create dashboards that aid business decision and help revile insights
• Learn tips and tricks for approaching an Excel Dashboard project
• Get ideas on good and bad charting and dashboard designs

課程介紹

Do you work with charts but struggle to identify which chart to use?

Are you new to data analysis?

Do you want to learn about the charting options Excel 2013/2010 offers?

Are you looking for a structured way to learn about the Excel charting tools

…[更多細節]

哪些人適合這堂課？

• Everybody interested in data visualization
• Everybody willing to try out the material at home and solve the exercises
• Everybody starting out to work with Excel
• Everybody needing charts for work or study purposes

學習目標

• create the most common type of charts in Excel
• know which chart to use for a given dataset
• perform standard format changes in charts
• use Excel 2013 confidently for charts and graphs

課程介紹

Project management is a wonderful art of managing different tasks and various task dependencies , material , people , funds and information. Gantt charts immensely helps to plan,organize , monitor and deliver projects on time. Not just for Project ma

…[更多細節]

哪些人適合這堂課？

• Any individual handling Personal or Professional assignments.
• One who is managing Projects and various aspects of the project
• Handling Simple Projects in construction,consultancy,Marketing,HR , Software develpment and Event Industry.

學習目標

• Create dynamic Gantt charts and Timelines in Minutes using Excel Charts.
• See the Project unfolding in most logical manner against Project Timeline.
• Plan,Monitor and control Project efficiently.
• Manage your resources and efforts in a far better manner.
• Execute Personal and Professional assignments with confidence.
• Create stunning reports using Editable Excel Templates.

課程介紹

Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Dynamic Charts? What if you could learn how to make designer-quality Excel Charts and Graphs in a few hours?

Think about what your Exce

…[更多細節]

哪些人適合這堂課？

• Excel users who wants to learn how to create Excel Charts
• Students with a willingness for learning
• Business Professionals + Entrepreneurs

學習目標

• Create designer-quality Charts in Microsoft Excel with real-world examples. BONUS: Excel Workbook files + Sample files included
• Improve general Excel knowledge
• Learn from an instructor with over 16 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
• Learn the most current version of Microsoft Excel 2013
• Learn through quizzes and exercises

課程介紹

Requirements

Basic Python knowledge – Don’t worry, we will cover each code snippet

You will need a computer with Python 3 installed, then we will cover how to install OpenPyXL

Some form of spreadsheet program. I use Excel, but you can also use Ope

…[更多細節]

哪些人適合這堂課？

• Beginner and Intermediate Python users who want to automate Excel
• Users who want to become an Excel Power User

學習目標

• Controlling Excel with Python
• Automate Excel with Python
• How to use OpenPyXL

課程介紹

This course will help you to create dynamic, interactive charts in excel using excel form controls. In each exercise you will learn how to create customize charts in excel and create awesome reports in excel.

You will get one course workbook and sam

…[更多細節]

哪些人適合這堂課？

• MIS Analyst, Financial Analyst, Business Analyst.
• Intermediate Excel Users.
• Any person who want to learn Excel Charting.

學習目標

• How to create Dynamic and Interactive Charts in Excel from basics
• How to create Form Controls
• Create Interactive Charts in Excel with Form Controls
• Learn Excel techniques by creating dashboards
• Create your own Sales Dashboard
• Understand how to use Vlookup, Hlookup, Index, Match and Offset functions
• Understand how to use SUMIFS function
• Streamline your own reports and reports of others.
• This course will help you create dynamic, interactive charts in microsoft excel using excel form controls. On each exercise you will learn how to create customize charts in excel and create awesome reports in excel.