Advanced Excel 2013

Master Spreadsheet Wizardry with Advanced Excel 2013

Advanced Excel 2013

Master Spreadsheet Wizardry with Advanced Excel 2013

Embark on a transformative journey with our Advanced Excel 2013 course, where mastery of dynamic data management awaits. Discover tools that propel your career, turning complex data into clear, actionable insights effortlessly. Imagine crafting intricate formulas, automating repetitive tasks, and creating stunning visualizations that captivate and inform. This isn't merely a learning experience; it's your gateway to becoming an Excel virtuoso, feared by inefficiency and revered by peers. Every lesson propels you towards innovation and excellence, ensuring that you're not just keeping pace but setting the standard in modern data analysis. Join us, and revolutionize your capabilities with skills that will resonate throughout your professional life, transforming challenges into triumphs with the power of Excel at your fingertips.

Self Paced • Online Class • Accredited CEUs

$120

4.2 ★ ★ ★ ★ ★

"Extraordinarily Helpful"

1,732 Students have taken this course

Add to Cart

OVERVIEW

CURRICULUM

Advanced Excel 2013

Name: Advanced Excel 2013
Price: 95.00 USD

CRN: 8900326

Lesson 1. Streamlining Data with Excel Outlining

Efficient data organization in Excel involves outlining, which can be created either automatically or manually, depending on the presence of subtotals. Custom views enhance this by allowing users to save and quickly apply various display settings, optimizing workflow.

Lesson 2. Sparklines: A Visual Data Story within Cells

Sparklines in Excel transform cell data into visual summaries, offering insights into patterns like employee sales. Master creating, modifying styles, addressing data omissions, grouping, comparing, and easily removing sparklines in your worksheets.

Lesson 3. Creating, Managing, and Leveraging Scenarios in Excel

Through Excel's Scenario Manager, create and assess multiple hypothetical scenarios--such as enlarging sales territories--without modifying original data, ensuring clarity in decision-making. This lesson teaches scenario creation, adjustments, and comparative summaries for enhanced analytical insights.

Lesson 4. Mastering Goal Seek and Solver Tools

Through Goal Seek, one can easily alter a singular cell in an Excel spreadsheet to meet a predefined target, albeit with simplicity. Conversely, Solver empowers users to handle multiple variables, employing diverse solving methods and constraints to reach more sophisticated, optimal solutions.

Lesson 5. PivotTable Tactics for Efficient Data Analysis

Pivot tables unlock the potential of large data sets in Excel by providing functions like totals, averages, and sorting. This lesson equips users with skills to manage data through hands-on creation, filtering, and organization techniques, including suggestions for efficient table setup and maintenance.

Lesson 6. Mastering the Art of PivotTables: Going Beyond Basics in Excel

PivotTables empower Excel users by offering detailed data analysis and customization options to manage large data sets efficiently. The lesson highlights techniques like cell adjustment, grouping, timeline usage, and SQL server integration to enhance data insights.

Lesson 7. Creating and Managing PivotCharts in Excel

The lesson demonstrates transforming worksheet data into PivotCharts, offering a visual edge over traditional PivotTables. Key skills covered include creating, customizing, filtering, and managing PivotCharts for effective data presentation.

Lesson 8. Navigating Excel's Mathematical Landscape

Excel 2013 offers essential mathematical functions that help users create formulas and analyze data, demonstrating the use of SUM and COUNT functions for tallying sales data over a period. The lesson also covers finding averages and extrema in datasets using AVERAGE, MIN, and MAX functions, along with practical steps for automating these calculations in spreadsheets.

Lesson 9. Effortless Time and Loan Calculations

This lesson teaches how to manage time data in Excel using decimals, along with optimal formatting techniques for time calculations. Further, financial computations such as loan payments, interest rates, and investments are meticulously explained using functions like PMT, RATE, and PV.

Lesson 10. The Art of Fetching Data in Excel

Using a dialogue box when entering formulas in Excel provides guided steps to help users--especially beginners--reduce trial and error in creating functions.

Lesson 11. Using IF Functions to Manage Data Errors

Learning to harness the power of the IF function in Excel equips users to tailor data displays by setting specific conditions, with options to nest functions for added complexity. This lesson touches on related functions like IFNA and IFERROR, and logical constructs enabling complex, criteria-based calculations.

Lesson 12. Error Management and Lookup Functions in Excel

Excel's data functions, such as MATCH and INDEX, simplify data search by allowing precise location of information in extensive lists, eliminating tedious scrolling through rows. This lesson covers MATCH, INDEX, CHOOSE functions, and handling #REF errors, showing how wildcard and combined functions enhance data retrieval.

Lesson 13. Mastering IS Functions: Error Checking in Excel

Learning IS, IFERROR, and OFFSET functions allows for error-handling and crafting adaptable spreadsheets that grow with your data. OFFSET's utility shines in dynamic ranges, while INDIRECT resolves complex cell referencing issues smoothly.

Lesson 14. Mastering Data Validation in Excel: A Comprehensive Guide

Excel's data validation feature guards against erroneous data entry by defining allowable data types and facilitating error messages. Practical guidance in this lesson includes rule creation, invalid data identification, and managing validation dropdowns and message customization in worksheets.

Lesson 15. Text Functions in Excel: A Comprehensive Study

Master Excel's capabilities beyond numbers by leveraging text functions such as LEFT, RIGHT, and TRIM to efficiently manipulate and clean your data. Harness the power of CONCATENATE and TEXT functions to seamlessly integrate and format text and numbers.

Lesson 16. Bringing Data to Life: Mastering Conditional Formatting in Excel

Through conditional formatting, Excel allows for dynamic data visualization using colors and icons to better identify key insights and data patterns. This lesson provides hands-on guidance on applying top/bottom rules, leveraging formatting presets, and creating custom rules to optimize data presentation.

Lesson 17. Mastering Macros: Automation in Excel 2013

Excel macros enable users to efficiently execute multiple commands using keyboard shortcuts, saving significant time. The lesson details the steps to create, manage, and secure these macros, ensuring seamless data operations.

Lesson 18. Macro Integration

Demystify macro editing with basic Visual Basic instructions to safely modify existing macros, adding functionality like confirmation boxes to avoid accidental data loss. Empower your worksheet automation with a curated selection of personalized macros readily available across all workbooks.

Lesson 19. Quick Tips for Excel 2013 Error Checking

Excel 2013 facilitates efficient troubleshooting through features like tracer arrows to trace relationships between cells, Error Checking for inconsistency resolutions, and the Watch Window functionality for real-time monitoring of data changes across multiple sheets. These tools aim to streamline error detection and correction, optimizing workflow productivity.

In This Course

14 Hours average completion time
1.4 CEUs
19 Lessons
39 Exams & Assignments
6 Discussions
19 Videos
22 Reference Files
29 Articles
Mobile Friendly
Last Updated March 2023

Description

This advanced Excel course goes beyond the basics of Excel and explores the advanced features that make this the most popular spreadsheet program available today. Picking up where our Excel 2013 online course leaves off, this course delves into Excel's world of functions and formulas, teaching you how to use Excel to enter, manage, calculate and display any type of data.

You will learn how to:

· Use outlining in Excel

· Create templates

· Work with sparklines

· Create and manage scenarios

· Use Goal Seek and Solver

· Create, manage, and format pivot tables and pivot charts

· Use the Excel mathematical functions

· Perform data lookups

· Create and use IF statements

· Use Excel's data functions

· Create and use data validation rules

· Apply custom and prebuilt conditional formatting

· Work with functions to manipulate strings of text and data

· Create and use macros

· Troubleshoot and audit formulas

· And more

If you're not a regular Excel user, it's important that you take the time to brush up on your basic Excel skills before signing up. This course makes the assumption that all students have at least a basic working knowledge of Excel before beginning the first lesson. You do not need access to Excel 2013 to successfully complete this course; however, it is highly recommended.

Skills You'll Develop