![]() ![]() Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts. This course uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. In this course, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. The best way to learn Excel is to use Excel. Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. Within six weeks, you will be able to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs. ![]() You will get to understand these various charts and get to build them on your own.In this first course of the specialization Excel Skills for Business, you will learn the essentials of Microsoft Excel. ![]() Starting with various line, bar and pie charts we introduce pivot charts, scatter plots and histograms. This module explores various advanced graphing and charting techniques available in Excel. Introduction to the charting capability of Excel.Use of Pivot tables with categorical as well as numerical data.A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel. You’ll learn how to set filters in data to selectively access data. This module introduces various data filtering capabilities of Excel. Module 3: Introduction to Filtering, Pivot Tables, and Charts Learners are introduced to the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel. This module introduces various Excel functions to organize and query data. Module 2: Spreadsheet Functions to Organize Data ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |