Comprehensive Review Excel Charts
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU and others in the US and other countries. In addition, he taught courses of Management Science and Statistics for Managers (always) using Excel. Over 100,000 students have attended his workshops and courses over the past 25 years.
He received the Microsoft MVP – Most Valuable Professional – award for the years 2014-6. “A Microsoft Most Valuable Professional (MVP) is an award for individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.” (From Microsoft’s site.)
Isaac Gottlieb has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands corporate professionals from leading multinational companies as well as small private business corporations.
He mails Excel-Tip-Of-The-Month to over 35,000 recipients.
Dr. Gottlieb has earned his PhD and two Masters Degrees from Columbia University Department of Industrial Engineering and Operations Research.
His two recent books are:
Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards. Nov 2022.
Management Science using Excel: Harnessing Excel's advanced features for business optimization. Aug 2023.
The first part will familiarize you with most of the Excel charts’ gallery. The idea is to understand where, when, and how to use these Excel charts.
The second part is to understand Chart Terminology, Elements, and Styles – how to use them and modify the charts with them. At this point, you will be comfortable creating and manipulating any of the Excel charts.
The next part enables you to take any “predictable” chart and make it appear as “your” chart – the chart that you are proud to present. It shows how to modify the charts in a variety of ways. You can swap the Rows with the Columns. You can delete or add data to existing charts. It covers different filtering, layouts, and formatting techniques. You will learn how to add specific features to a chart, such as logos or pictures for presenting your company’s identity. Once you create a chart that you would like to use again – you will be able to save the chart - as a Template for future use.
The last part covers unconventional charts and advanced charting technique topics. Will start with techniques used to animate charts. It continues with creating combination charts. Will cover alternatives to Excel charts, namely, Sparklines, Text charts, and Conditional Formatting charts. At the very end, we show how to construct a curve and mathematical function which have the best fit to the series of data points on a chart, named “Trendlines”. Examples include supply and demand curve functions and other business data sets. In addition to the mathematical function, the chart will show how to calculate the “Coefficient of Determination” – which expresses the correlation between Trendline and data enabling you to use charts for forecasting.
Areas Covered
- Review the purpose of often-used Excel Charts
- Clean and prepare databases for creating charts
- Data visualization techniques – using pictorial imaginings
- Creating personal chart templates for future use
- Using charts for forecasting
Who Should Attend
Any person using Excel who wants to learn or improve their Excel charts skills. It will help users of any level improve their charting skills with countless examples – using hands-on examples on the provided Excel workbook.
Why Should You Attend
Professionals, students, and other Excel users have not had the opportunity to learn using charts.
- Many users are not using Charts to show their data. They try to make their spreadsheet " attractive " so that people will read it
- When using charts, they use the wrong ones. (Use pie charts instead of the column or Pareto charts.)
- Users do not remove unnecessary gridlines
- Another important problem is formatting and scaling
-
$200.00
-
