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.
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 September 2025
