Use Excel effectively in your professional workplace and increase your productivity
About This Video
Explore the most used Excel functionalities in the business environment
Get started with using MS Excel in no time with this concise course
Discover business-related examples and case studies
In Detail
Whether you’re new to Excel or have used it earlier and want to get more comfortable with its advanced features, this course is for …
Microsoft Excel: Beginner to Advanced Training
Video description
Use Excel effectively in your professional workplace and increase your productivity
About This Video
Explore the most used Excel functionalities in the business environment
Get started with using MS Excel in no time with this concise course
Discover business-related examples and case studies
In Detail
Whether you’re new to Excel or have used it earlier and want to get more comfortable with its advanced features, this course is for you.
This complete and concise tutorial on MS Excel can be completed within 6 hours! With this fast-paced course, you’ll learn exactly what you need to get started with using Excel in your workplace without wasting time on learning irrelevant Excel operations.
This course is a carefully designed curriculum teaching you only the most used functionalities of Excel in the business environment. There are ample practice exercises because Excel requires practice, and also includes business-related examples and case studies.
In this course, we cover concepts such as mathematical functions, textual formulas, logical formulas, date-time (temporal) formulas, lookup formulas, data tools, formatting data and tables, pivot tables, charts, Excel shortcuts, analytics in Excel, and macros; we also have some bonus lectures.
By the end of this course, your confidence in using Excel will soar. You’ll have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.
Who this book is for
This course is for anyone who wants to get started with MS Excel or get comfortable with its features speedily.
Excel Charts - Categories of Messages that can be Conveyed
Elements of Charts
The Easy Way of Creating Charts
Bar and Column Charts
Formatting Charts
Line Charts
Area Charts
Pie and Doughnut Charts
Why Should We Avoid Pie charts
Scatter Plot or XY Chart
Frequency Distribution and Histograms
Waterfall Charts
Sparklines
Chapter 8 : Pivot Charts
Pivot Charts
Chapter 9 : Named Ranges
Named Ranges
Indirect Function
Chapter 10 : Excel Shortcuts
Shortcuts
Chapter 11 : Macros
Macros
Chapter 12 : Advance Excel
Advance Excel: Analytics in Excel
Start your Free Trial Self paced Go to the Course We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.
This site uses cookies. By continuing to use this website, you agree to their use.I Accept