USD 295.00
Details
Whether you need to crunch numbers for sales, inventory, IT, human resources, or another business unit, the ability to get the right information to the right people at the right time can create a powerful competitive advantage in a complex market environment.
This course builds upon the foundational Microsoft Office Excel 2010/2013 knowledge and skills you've already acquired and set you on the road to creating advanced workbooks and worksheets that will deepen your firm's business intelligence. You’ll learn a
lot of things about Excel 2010/2013, including how to create advanced formulas and organize your data into tables. You'll discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons. At its heart,
this course is about one simple idea: asking your data questions and using Excel 2010/2013 to find the answers.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2013 Exam and the Excel 2013 Expert Exam.
To ensure successful completion of this course we recommend taking Microsoft Office Excel 2013: Level 1 or have the equivalent knowledge.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2013 Exam and the Excel 2013 Expert Exam.
To ensure successful completion of this course we recommend taking Microsoft Office Excel 2013: Level 1 or have the equivalent knowledge.
Outline
Lesson 1: Customizing the Excel Environment
· Topic A: Configure Excel Options
· Topic B: Customize the Ribbon and the Quick Access Toolbar
· Topic C: Enable Excel Add-Ins
Lesson 2: Creating Advanced Formulas
· Topic A: Use Range Names in Formulas
· Topic B: Use Specialized Functions
· Topic C: Use Array Formulas
Lesson 3: Analyzing Data with Functions and Conditional Formatting
· Topic A: Analyze Data by Using Text and Logical Functions
· Topic B: Apply Advanced Conditional Formatting
Lesson 4: Organizing and Analyzing Datasets and Tables
· Topic A: Create and Modify Tables
· Topic B: Sort Data
· Topic C: Filter Data
· Topic D: Use SUBTOTAL and Database Functions
Lesson 5: Visualizing Data with Basic Charts
· Topic A: Create Charts
· Topic B: Modify and Format Charts
Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
· Topic A: Create a PivotTable
· Topic B: Analyze PivotTable Data
· Topic C: Present Data with PivotCharts
· Topic D: Filter Data by Using Slicers
Appendix A: Microsoft Office Excel 2013 Exam 77-420
Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428
Appendix C: Financial Functions
Appendix D: Date and Time Functions
Appendix E: Working with Graphical Objects
· Topic A: Configure Excel Options
· Topic B: Customize the Ribbon and the Quick Access Toolbar
· Topic C: Enable Excel Add-Ins
Lesson 2: Creating Advanced Formulas
· Topic A: Use Range Names in Formulas
· Topic B: Use Specialized Functions
· Topic C: Use Array Formulas
Lesson 3: Analyzing Data with Functions and Conditional Formatting
· Topic A: Analyze Data by Using Text and Logical Functions
· Topic B: Apply Advanced Conditional Formatting
Lesson 4: Organizing and Analyzing Datasets and Tables
· Topic A: Create and Modify Tables
· Topic B: Sort Data
· Topic C: Filter Data
· Topic D: Use SUBTOTAL and Database Functions
Lesson 5: Visualizing Data with Basic Charts
· Topic A: Create Charts
· Topic B: Modify and Format Charts
Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
· Topic A: Create a PivotTable
· Topic B: Analyze PivotTable Data
· Topic C: Present Data with PivotCharts
· Topic D: Filter Data by Using Slicers
Appendix A: Microsoft Office Excel 2013 Exam 77-420
Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428
Appendix C: Financial Functions
Appendix D: Date and Time Functions
Appendix E: Working with Graphical Objects
Reviews
Be the first to write a review about this course.
Write a Review
Productivity Point Global is led by a team of individuals with world-class experience in professional development skills and leading edge technologies. These established professionals collaborate to drive PPG's business forward through entrepreneurial innovation, strategic partnerships, brand management and sales growth.
PPG's combination of technology and professional skills training, IT outsourcing, and event hosting enables us to place a focused emphasis on the diversified business needs of our clients.
Productivity Point Global, previously ExecuTrain of Florida, began in 2003 and evolved out of a desire to increase our outreach both nationally and internationally. Utilizing the highest standard in customer service combined with our subject matter experts and high-end training venues, PPG has carved a niche by consistently expanding our corporate and government client base, originally hosted in the southeastern region of the US.
PPG's combination of technology and professional skills training, IT outsourcing, and event hosting enables us to place a focused emphasis on the diversified business needs of our clients.
Productivity Point Global, previously ExecuTrain of Florida, began in 2003 and evolved out of a desire to increase our outreach both nationally and internationally. Utilizing the highest standard in customer service combined with our subject matter experts and high-end training venues, PPG has carved a niche by consistently expanding our corporate and government client base, originally hosted in the southeastern region of the US.