Advanced Diploma In Microsoft Excel

Our comprehensive program is meticulously crafted to equip you with the essential skills and knowledge required to thrive in your chosen field. Developed by seasoned professionals with years of industry experience, this course is ideal for those seeking to kickstart their careers or enhance their existing skill set.

Featuring an engaging audio-visual presentation and easily digestible modules, our program facilitates a self-paced learning experience. Our dedicated online support team is available on weekdays to provide assistance throughout your journey.

Key Learning Outcomes

• Grasp the fundamentals and their practical applications.
• Cultivate the necessary skills for success in your field.
• Apply newfound knowledge to real-world scenarios.
• Develop effective solutions for relevant topics.
• Elevate your employability and career prospects.

Course Curriculum

• Module 01: Excel from A-Z Course Intro
• Module 02: Excel Job Opportunities
• Module 03: Excel Job Types
• Module 04: Microsoft Excel Marketplace
• Module 05: What is Microsoft Excel?
• Module 06: Who is This Course For?
• Module 07: Finding &#; Opening Excel
• Module 08: Explaining the Excel Interface
• Module 09: Excel Interface Continued
• Module 10: Excel Workbook vs. Excel Worksheet
• Module 11: Saving an Excel Document
• Module 12: Customizing the Quick Access Toolbar
• Module 13: Customizing the Excel Ribbon
• Module 14: Excel Shortcut Keys
• Module 15: Creating Excel Labels
• Module 16: Entering Numeric Values in Excel
• Module 17: Formatting Date Values in Excel
• Module 18: Building Basic Formulas in Excel
• Module 19: Order of Operations
• Module 20: Relative vs. Absolute Cell References
• Module 21: Excel Functions Explained
• Module 22: The SUM() Function
• Module 23: The MIN() &#; MAX() Function
• Module 24: The AVERAGE() Function
• Module 25: COUNT() Functions
• Module 26: Moving &#; Copying Data
• Module 27: Insert &#; Delete Rows and Columns
• Module 28: Adjusting the Width and Height of Cells
• Module 29: Hiding and Unhiding Excel Rows and Columns
• Module 30: Renaming, Moving &#; Deleting Excel Worksheets
• Module 31: Adding Protection to Specific Cells
• Module 32: Protecting the Structure of a Workbook
• Module 33: Adding a Workbook Password to Open File
• Module 34: Formatting Fonts and Cell Background Color
• Module 35: Adding Cell Borders
• Module 36: Formatting Data Appropriately
• Module 37: The Magic behind Excel&#;s Format Painter
• Module 38: Creating Styles for Formatting Efficiency
• Module 39: Merging Cells for a Cleaner Look
• Module 40: The Power of Conditional Formatting
• Module 41: Customizing Icons
• Module 42: Create Compelling Graphics with SmartArt
• Module 43: The Commonly Used Column Chart
• Module 44: Changing the Chart Design.mp4
• Module 45: Formatting Elements of a Chart
• Module 46: Modifying the Data, Type &#; Location of a Chart
• Module 47: Print Preview Options
• Module 48: Excel&#;s Page Layout View
• Module 49: Printing a Specific Range of Cells
• Module 50: Converting Spreadsheets to PDF Files
• Module 51: Why Create an Excel Template
• Module 52: How to Create an Excel Template
• Module 53: How to Prepare Data for Analysis
• Module 54: How to Sort Data in Excel
• Module 55: Multi-Level Sorting
• Module 56: Custom Sorting Datasets in Excel
• Module 57: Applying Filters to Datasets
• Module 58: Creating Subtotals within a Dataset
• Module 59: Converting Datasets into Tables
• Module 60: Little Slice of Pie Charts
• Module 61: Finding &#; Removing Duplicate Values
• Module 62: The SUMIF() Function
• Module 63: The DSUM() Function
• Module 64: The DSUM() Function Cont.
• Module 65: The SUBTOTAL() Function
• Module 66: What is Excel Data Validation?
• Module 67: Creating a Drop Down List with Data Validation
• Module 68: Different Types of Excel Data Validation
• Module 69: Adding Custom Alerts to Data Validation
• Module 70: Creating a Dynamic Drop Down List
• Module 71: Complex Validation: Dependent Drop Down List!
• Module 72: Creating an Excel Pivot Table
• Module 73: Modifying Excel PivotTables
• Module 74: Grouping &#; Filtering PivotTable Data
• Module 75: Drilling Down into PivotTable Data
• Module 76: Creating Pivot Charts &#; Utilizing Slicers
• Module 77: What is PowerPivot?
• Module 78: Activating the Excel PowerPivot Add-In
• Module 79: Creating Relationships between Data Tables.mp4
• Module 80: Using Data Models to Create PivotTables
• Module 81: Excels IF Function
• Module 82: IF() Function with AND() Criteria
• Module 83: IF() Function with OR() Criteria
• Module 84: Nesting Multiple IF() Functions
• Module 85: The COUNTIF() Function
• Module 86: Key Benefits of Named Ranges
• Module 87: VLOOKUP() Function
• Module 88: HLOOKUP() Function
• Module 89: The INDEX Function
• Module 90: MATCH() Function
• Module 91: INDEX() and MATCH() Combined
• Module 92: Two-Way Lookup with INDEX() and MATCH()
• Module 93: LEFT(), RIGHT() and MID() Function
• Module 94: Extracting Specific Text using LEN() &#; SEARCH()
• Module 95: Combining Text with CONCATENATE()
• Module 96: Quick Tips &#; Other Text Based Functions
• Module 97: Tracing Precedents &#; Dependents in Formulas
• Module 98: Showing Formulas
• Module 99: Grouping Data
• Module 100: D Referencing in Formulas
• Module 101: Utilizing the Watch Window in Excel
• Module 102: How to Freeze Panes in Excel
• Module 103: Goal Seek in Excel
• Module 104: Compare Results with Excel Data Tables
• Module 105: Solver Tool
• Module 106: The Power Behind Excel VBA
• Module 107: A Look Inside the Visual Basic Editor (VBE)
• Module 108: Recording a Macro
• Module 109: Saving &#; Opening a Macro-Enabled Workbook
• Module 110: Modules and Procedures
• Module 111: Objects, Methods and Properties
• Module 112: Excel VBA Variables
• Module 113: Referencing a Range
• Module 114: InputBox &#; MsgBox
• Module 115: Using Variables in VBA Code
• Module 116: If Then Else Statement
• Module 117: Worksheet Functions inside VBA
• Module 118: Creating User Defined Functions
• Module 119: User Defined Functions within VBA Scripts
• Module 120: Find Last Row of Data
• Module 121: Find Last Column of Data
• Module 122: With Statement
• Module 123: Debugging &#; Error Handling
• Module 124: Debugging &#; Error Handling Cont.
• Module 125: For Next Loop
• Module 126: Do Until Loop
• Module 127: Assigning Macros to Shapes
• Module 128: Form Controls vs ActiveX Controls
• Module 129: Worksheet Events
• Module 130: Workbook Events
• Module 131: Fun with VBA Events!
• Module 132: Creating an Excel UserForm
• Module 133: Adding Controls to UserForms
• Module 134: How to Show an UserForm
• Module 135: Passing TextBox Values to Desired Cells
• Module 136: Passing Option Buttons to Desired Cells
• Module 137: UserForm ComboBoxes
• Module 138: Clearing Values from UserForm Controls
• Module 139: How to Close an UserForm
• Module 140: UserForms and Protected Sheets
• Module 141: Creating an Excel Resume
• Module 142: Getting Started with Freelancing
• Module 143: How to Become an Excel Freelancer
• Module 144: Top Freelance Websites
• Module 145: How to Get Your First Client
• Module 146: Personal Branding
• Module 147: Importance of Having a Website
• Module 148: Resources &#; Advanced Diploma in Microsoft Excel
• Module 149: Assignment &#; Advanced Diploma in Microsoft Excel

Designed to give you a competitive edge in the job market, this course offers lifetime access to materials and the flexibility to learn at your own pace, from the comfort of your home.

Why Choose Us?

• Learn at your own pace with 24/7 online access to course materials.
• Benefit from full tutor support available Monday through Friday.
• Acquire essential skills in the convenience of your home through informative video modules.
• Enjoy 24/7 assistance and advice via email and live chat.
• Study on your preferred device – computer, tablet, or mobile.
• Gain a thorough understanding of the course content.
• Improve professional skills and earning potential upon completion.
• Access lifetime course materials and expert guidance.
• Enjoy the convenience of online learning with flexible schedules.

Why Enroll in This Course?

Our program provides a comprehensive introduction to the subject matter, laying a solid foundation for further study. It empowers students to acquire knowledge and skills applicable to both their professional and personal lives.

Assessment

The course incorporates quizzes to evaluate your understanding and retention of the material. These quizzes pinpoint areas for further practice, allowing you to review course materials as needed. Successfully passing the final quiz qualifies you for a certificate of achievement.

Requirements

There are no formal requirements for this course, it is open to anyone who is interested in learning the material.

Career Path

Our course is meticulously designed to equip you for success in your chosen field. Upon completion, you’ll have the qualifications to pursue diverse career opportunities across various industries.