Unlock the full potential of Excel with our Advanced Excel Course. Designed for those who have mastered the basics, this course delves into complex formulas, data analysis, and automation techniques. You will learn to create sophisticated dashboards, perform advanced data manipulation, and utilize powerful functions such as VLOOKUP, INDEX-MATCH, and pivot tables. Practical exercises and real-world scenarios will enhance your problem-solving skills and enable you to streamline tasks and generate insightful reports. By the end of the course, you’ll be equipped with the expertise to leverage Excel for advanced data analysis and decision-making in any professional setting. Perfect for analysts, managers, and anyone looking to elevate their Excel proficiency.
Who is this course for?
By taking this Advanced Excel Course, you’re able to open yourself to new opportunities within the data analysis and business administration career path. Such careers may include:
- Data Analyst (£28,000 to £50,000)
- Financial Analyst (£30,000 to £55,000)
- Business Analyst (£30,000 to £55,000)
Course Curriculum
| Microsoft Excel 2019 New Features | |||
| Introduction to Microsoft Excel 2019 New Features | 00:07:00 | ||
| CONCAT | 00:02:00 | ||
| IFS | 00:01:00 | ||
| MAXIFS | 00:01:00 | ||
| MINIFS | 00:01:00 | ||
| SWITCH | 00:02:00 | ||
| TEXTJOIN | 00:01:00 | ||
| Map Chart | 00:02:00 | ||
| Funnel Chart | 00:01:00 | ||
| Better Visuals | 00:06:00 | ||
| Pivot Table Enhancements | 00:02:00 | ||
| Power Pivot Updates | 00:01:00 | ||
| Getting Started with Microsoft Office Excel | |||
| Navigate the Excel User Interface | 00:28:00 | ||
| Use Excel Commands | 00:10:00 | ||
| Create and Save a Basic Workbook | 00:19:00 | ||
| Enter Cell Data | 00:12:00 | ||
| Use Excel Help | 00:05:00 | ||
| Performing Calculations | |||
| Create Worksheet Formulas | 00:15:00 | ||
| Insert Functions | 00:17:00 | ||
| Reuse Formulas and Functions | 00:17:00 | ||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Formatting a Worksheet | |||
| Apply Text Formats | 00:16:00 | ||
| Apply Number Format | 00:08:00 | ||
| Align Cell Contents | 00:09:00 | ||
| Apply Styles and Themes | 00:12:00 | ||
| Apply Basic Conditional Formatting | 00:11:00 | ||
| Printing Workbooks | |||
| Create and Use Templates | 00:08:00 | ||
| Preview and Print a Workbook | 00:10:00 | ||
| Set Up the Page Layout | 00:09:00 | ||
| Configure Headers and Footers | 00:07:00 | ||
| Managing Workbooks | |||
| Manage Worksheets | 00:05:00 | ||
| Manage Workbook and Worksheet Views | 00:07:00 | ||
| Manage Workbook Properties | 00:06:00 | ||
| Working with Functions | |||
| Work with Ranges | 00:18:00 | ||
| Use Specialized Functions | 00:11:00 | ||
| Work with Logical Functions | 00:23:00 | ||
| Work with Date & Time Functions | 00:08:00 | ||
| Work with Text Functions | 00:11:00 | ||
| Working with Lists | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| Query Data with Database Functions | 00:09:00 | ||
| Outline and Subtotal Data | 00:09:00 | ||
| Analyzing Data | |||
| Apply Intermediate Conditional Formatting | 00:07:00 | ||
| Apply Advanced Conditional Formatting | 00:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| Modify and Format Charts | 00:12:00 | ||
| Use Advanced Chart Features | 00:12:00 | ||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | 00:13:00 | ||
| Analyze PivotTable Data | 00:12:00 | ||
| Present Data with PivotCharts | 00:07:00 | ||
| Filter Data by Using Timelines and Slicers | 00:11:00 | ||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Use the Goal Seek Feature | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Excel VBA Data Management | |||
| Edit a Macro | 01:00:00 | ||
| Debug a Macro | 00:30:00 | ||
| Customize the Quick Access Toolbar and Hotkeys | 00:30:00 | ||
| Set Macro Security | 01:00:00 | ||
| Insert Text | 00:30:00 | ||
| Format Text | 00:30:00 | ||
| Sort Data | 00:30:00 | ||
| Duplicate Data | 01:00:00 | ||
| Generate a Report | 01:00:00 | ||
| Determine the Dialog Box Type | 00:15:00 | ||
| Capture User Input | 01:00:00 | ||
| Insert, Copy, and Delete Worksheets | 00:30:00 | ||
| Rename Worksheets | 00:30:00 | ||
| Modify the Order of Worksheets | 00:15:00 | ||
| Print Worksheets | 00:30:00 | ||
| Create User-Defined Functions | 00:30:00 | ||
| Automate SUM Functions | 00:30:00 | ||
- Original price was: $275.$85Current price is: $85.
- 365 Days
- Course Badge
- Course Certificate