Introduction to MS Excel 2013 (Basic Level)
This course material is a compilation of internal knowledge base and content from various sources, websites, booklets, documents, etc. Same goes with the various screen shots used in it, and the accompanying exercise files. Most of the content and exercises have been taken from websites like Microsoft.com, excelexperts.com, excel-formulas.com, gcflearnfree.org, and homeandlearn.co.uk. Yashwantrao Chavan Academy of Development Administration (YASHADA) duly and thankfully acknowledges the respective sources.
The aim of this course material is to provide a preliminary understanding on the subjects and areas covered as part of YASHADA’s training programs. While working on Microsoft Excel, this document should be treated only as a quick reference on the topics, and should not be treated as a guideline and / or instructions.
The document by no means has any commercial intention and is solely compiled for the purpose of knowledge sharing. It is meant for free of cost distribution amongst participants of YASHADA’s training programs.
Any part of course material, if commercial will be removed when brought to our notice.
This Basic level guide deals with explain why the new Single Document Interface makes it easier to use Excel 2013 with dual monitors. Identify three types of automated analyses in Excel 2013. Use Flash Fill to split, combine, and rearrange data quickly and easily without using commands or complicated formulas. Describe the new Excel Data Model and explain its impact on Pivot Table analysis. Use combination line and column charts to present financial data more effectively. Explain why Quick Explore is more effective in exploring the underlying data in a Pivot Table report than simple drill-down functionality. Distinguish between an ordinary Pivot Table and one built using Power Pivot. Describe data visualization and how Power View reports help users better understand business data. Identify three new Excel functions for retrieving business data from the web.
- Lectures 51
- Quizzes 32
- Duration 50 hours
- Skill level All levels
- Language English
- Students 45
- Certificate Yes
- Assessments Self