{"product_id":"excel-2024","title":"Excel 2024","description":"\u003ch3\u003eExcel 2024 Course Outline:\u003c\/h3\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003e\n\u003ctable class=\"no-border unborder\" width=\"100%\"\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd valign=\"top\"\u003e\n\u003cb\u003eModule One: Getting Started\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eHousekeeping Items\u003c\/li\u003e\n\u003cli\u003eThe Parking Lot\u003c\/li\u003e\n\u003cli\u003eWorkshop Objectives\u003c\/li\u003e\n\u003cli\u003eAction Plans and Evaluation Forms\u003c\/li\u003e\n\u003cli\u003eAction Plan\u003c\/li\u003e\n\u003cli\u003eEvaluation Form\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Two: Introduction to Excel 2024\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eUnderstanding Excel’s Interface and Navigation\u003c\/li\u003e\n\u003cli\u003eCreating, Saving, and Managing Workbooks\u003c\/li\u003e\n\u003cli\u003eWorking with Worksheets: Adding, Renaming, and Deleting\u003c\/li\u003e\n\u003cli\u003eUsing the Ribbon, Quick Access Toolbar, and Context Menus\u003c\/li\u003e\n\u003cli\u003eExploring New Features in Excel\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Two: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Three: Working With Data\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eEntering and Editing Data Efficiently\u003c\/li\u003e\n\u003cli\u003eTransforming Data With Power Query\u003c\/li\u003e\n\u003cli\u003eApplying Data Validation and Drop-Down Lists\u003c\/li\u003e\n\u003cli\u003eSorting and Filtering Data (Dynamic Arrays)\u003c\/li\u003e\n\u003cli\u003eUsing the New IMAGE Function to Insert Images in Cells\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Three: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Four: Formulas and Functions\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eUnderstanding Cell References (Relative, Absolute, Mixed)\u003c\/li\u003e\n\u003cli\u003eWorking with Basic Formulas (SUM, AVERAGE, COUNT)\u003c\/li\u003e\n\u003cli\u003eUsing Logical Functions (IF, AND, OR, IFERROR)\u003c\/li\u003e\n\u003cli\u003eExploring Text and Date Functions (TEXT, CONCAT, TODAY)\u003c\/li\u003e\n\u003cli\u003eLeveraging New Functions (FILTER, SORT, UNIQUE, SEQUENCE)\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Four: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Five: Practical Problem-Solving With Excel\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eCreating Budgets and Expense Trackers\u003c\/li\u003e\n\u003cli\u003eBuilding Basic Schedules and Calendars\u003c\/li\u003e\n\u003cli\u003eUsing Excel for Simple Project Management (Gantt Charts)\u003c\/li\u003e\n\u003cli\u003eTracking Inventory and Sales Data\u003c\/li\u003e\n\u003cli\u003eAnalyzing Data with Built-in Templates\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Five: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Six: Data Visualization and Charting\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eCreating Basic Charts (Column, Line, Pie)\u003c\/li\u003e\n\u003cli\u003eCustomizing Charts: Titles, Legends, and Data Labels\u003c\/li\u003e\n\u003cli\u003eUsing Dynamic Charts with Dynamic Arrays\u003c\/li\u003e\n\u003cli\u003eBuilding Pivot Charts for Advanced Reporting\u003c\/li\u003e\n\u003cli\u003eEnhancing Visuals with Sparklines and Maps\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Six: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/td\u003e\n\u003ctd valign=\"top\"\u003e\n\u003cb\u003eModule Seven: Managing and Analyzing Large Data Sets\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eWorking with Tables: Creating, Formatting, and Summarizing\u003c\/li\u003e\n\u003cli\u003eUsing PivotTables for Data Analysis\u003c\/li\u003e\n\u003cli\u003eApplying Slicers and Timelines for Interactive Reports\u003c\/li\u003e\n\u003cli\u003eLeveraging Conditional Formatting for Data Insights\u003c\/li\u003e\n\u003cli\u003eExploring Data Tools: Remove Duplicates, Text to Columns, and Flash Fill\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Seven: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Eight: Collaboration and Sharing\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eSharing Workbooks and Managing Permissions\u003c\/li\u003e\n\u003cli\u003eReal-Time Collaboration and Co-Authorizing\u003c\/li\u003e\n\u003cli\u003eTracking Changes and Using Comments\/Notes\u003c\/li\u003e\n\u003cli\u003eExploring Excel Online Integration\u003c\/li\u003e\n\u003cli\u003eManaging Versions and Using Revision History\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Eight: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Nine: Time-Saving Tips and Tricks\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eUsing Keyboard Shortcuts to Speed Up Workflows\u003c\/li\u003e\n\u003cli\u003eNavigating Large Workbooks with Freeze Panes and Split Windows\u003c\/li\u003e\n\u003cli\u003eUsing Find \u0026amp; Replace and Go To Special for Quick Edits\u003c\/li\u003e\n\u003cli\u003eCustomizing Excel Settings for Personal Efficiency\u003c\/li\u003e\n\u003cli\u003eWorking with Templates for Faster Document Creation\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Nine: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Ten: Data Security and Protection\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eProtecting Worksheets and Workbooks with Passwords\u003c\/li\u003e\n\u003cli\u003eManaging Permissions for Sensitive Data\u003c\/li\u003e\n\u003cli\u003eUsing Data Masking and Cell Locking Techniques\u003c\/li\u003e\n\u003cli\u003eImplementing Workbook-Level Security (Encryption)\u003c\/li\u003e\n\u003cli\u003eAuditing and Error Checking (Trace Dependents\/Precedents, Evaluate Formulas)\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Ten: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Eleven: Personalizing Excel for Everyday Use\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eCustomizing the Ribbon\u003c\/li\u003e\n\u003cli\u003eCreating and Managing Named Ranges\u003c\/li\u003e\n\u003cli\u003eAdjusting Themes, Styles, and Formatting Options\u003c\/li\u003e\n\u003cli\u003eSetting Up Print Options and Page Layouts\u003c\/li\u003e\n\u003cli\u003eSaving and Exporting Workbooks in Different Formats\u003c\/li\u003e\n\u003cli\u003ePractical Illustration\u003c\/li\u003e\n\u003cli\u003eModule Eleven: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cb\u003eModule Twelve: Wrapping Up\u003c\/b\u003e\n\u003cul type=\"square\"\u003e\n\u003cli\u003eWords from the Wise\u003c\/li\u003e\n\u003cli\u003eReview of Parking Lot\u003c\/li\u003e\n\u003cli\u003eLessons Learned\u003c\/li\u003e\n\u003cli\u003eCompletion of Action Plans and Evaluations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e","brand":"My Store","offers":[{"title":"Default Title","offer_id":47889704419540,"sku":"excel_2016_expert","price":25.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0751\/4882\/0692\/files\/Excel_2016_Essentials_360x_f4630b57-21a3-442a-9ae2-9e0e0fe77d43.avif?v=1777959921","url":"https:\/\/austspectraining.com.au\/products\/excel-2024","provider":"Essential Soft Skills Academy","version":"1.0","type":"link"}