Course Description
The Microsoft Excel from Basic to Masterclass teaches the most effective technique to understand the subject thoroughly. This course is taught by top industry experts and academic professionals. Enrol our top online courses now for a super discounted price.
Microsoft Excel from Basic to Masterclass is meticulously researched and prepared with the utmost care. All of the topics and subtopics are scientifically organised, taking into account the learner’s psychology and overall experience. All of the modules are bite-sized, audiovisual, simple to comprehend and interactive.
With a rich learning experience and pleasant customer service, Academy of Skills ensures quality and care. When you buy an online course from Academy of Skills, you get full access for 365 days and full tutor support and 24×7 customer service.
Most of our skilled instructors guarantee that they will answer all of your questions and make your learning experience pleasant. Furthermore, you will receive an electronic certificate immediately after finishing the Microsoft Excel from Basic to Masterclass, which will assist you in obtaining work in the appropriate sector by enhancing your expertise and CV.
You should select this Microsoft Excel from Basic to Masterclass from Academy of Skills if you want to learn about this topic while focusing on high-quality learning from professionals and experts. There are no hidden costs or examination fees. We are entirely transparent and honest about all of the course costs.
Why Study This Online Course?
This course will broaden your knowledge and add valuable skills to your resume. There are no set deadlines or instructional schedules so you can go at your own pace. You are free to study at your own speed, but to obtain the certificate; you must pass the assessment test or project. (Note: Some of our online courses do not have any MCQ examinations or assessments. We can add an assessment on request.) Our online learning platform can be accessed from any internet-connected device, such as a smartphone, tablet, or computer, which will be used to deliver the course. The best part is that because this course is video-based, you may pause it whenever you want to take your notes.
Why Study with the Academy of Skills?
- Audio Visual Lesson
Easy to follow Audio Visual lesson with lesson control at your fingertip - Learn anything
Whether you want to develop your skills or learn a new activity, you have an online course. - Learn Anywhere
You can learn a new skill from anywhere, including the convenience of your couch. - Access to Top Instructors
Learn from alumni from prestigious universities and cultural institutions who will share their insights and knowledge. - Instant Certificate
Upon successful completion of each course, you will receive an instant digital certificate. - Affordable Courses
Best Prices With Regular Savings - Learn Anytime
Learn new skills your own pace and on your own time; study anywhere and whenever you choose.
Will I Receive A Certificate of Completion for Microsoft Excel from Basic to Masterclass?
Yes, after completion of this course, you will be able to request a certificate of completion from the Academy of Skills. You can order the certificate with our secure payment system. Use the link at the bottom of this page to order the Certificate. An exclusive discount is offered for pre-orders.
You can request for PDF Certificate, PDF Transcript, Hardcopy Certificate and Hardcopy Transcript after successfully completing the course. We offer Free UK Shipping for all Hardcopy orders. Visit the Certificate order page (https://academyofskills.org/certificate-transcript/) to purchase/claim your certificate.
Requirement
- There is no formal entry requirement.
- A desire to learn
- A PC or mobile device
Course Curriculum
| Excel from A-Z Course Introduction | |||
| Excel from A-Z Course Section Overview | 00:04:00 | ||
| What is Microsoft Excel? | 00:05:00 | ||
| Who is This Course For | 00:04:00 | ||
| Microsoft Excel Marketplace | 00:05:00 | ||
| Excel Job Opportunities | 00:03:00 | ||
| Excel Job Types | 00:04:00 | ||
| Getting Started with Excel | |||
| Finding and Opening Microsoft Excel | 00:02:00 | ||
| Excel’s Start Screen | 00:04:00 | ||
| Explaining the Excel Interface | 00:03:00 | ||
| Excel Interface Continued | 00:02:00 | ||
| Excel Workbook vs Excel Worksheet | 00:03:00 | ||
| Saving and Opening Excel Documents | 00:04:00 | ||
| Customizing the Quick Access Toolbar | 00:03:00 | ||
| Customizing the Excel Ribbon | 00:04:00 | ||
| Excel Shortcut Keys | 00:02:00 | ||
| Values, Referencing and Formulas | |||
| Creating Excel Labels | 00:03:00 | ||
| Entering Numeric Data in Excel | 00:04:00 | ||
| Formatting Date Values in Excel | 00:06:00 | ||
| Building Basic Formulas in Excel | 00:05:00 | ||
| Order of Operation | 00:07:00 | ||
| Relative vs Absolute Cell References | 00:08:00 | ||
| Intro to Excel Functions | |||
| Excel Functions Explained | 00:03:00 | ||
| The DSUM() Function | 00:08:00 | ||
| The MIN() and MAX() Function | 00:04:00 | ||
| The AVERAGE() Function | 00:03:00 | ||
| COUNT() Functions | 00:05:00 | ||
| Adjusting Excel Worksheets | |||
| Moving and Copying Data | 00:07:00 | ||
| Insert and Delete Rows/Columns | 00:06:00 | ||
| Adjusting the Width and Height of Cells | 00:05:00 | ||
| Hiding and Unhiding Excel Rows and Columns | 00:05:00 | ||
| Renaming Moving and Deleting Excel Worksheets | 00:06:00 | ||
| Adding Protection to Specific Cells | 00:05:00 | ||
| Protecting the Structure of a Workbook | 00:03:00 | ||
| Adding a Workbook Password to Open File | 00:03:00 | ||
| Visually Pleasing Cell Formatting | |||
| Formatting Fonts and Cell Background Color | 00:05:00 | ||
| Adding Cell Borders | 00:05:00 | ||
| Formatting Data Appropriately | 00:06:00 | ||
| The Magic Behind Excel’s Format Painter | 00:04:00 | ||
| Creating Styles for Formatting Efficiency | 00:06:00 | ||
| Merging Cells for a Cleaner Look | 00:04:00 | ||
| The Power of Conditional Formatting | 00:07:00 | ||
| How to Insert Images and Shapes | |||
| Grab Users Attention using Illustrations | 00:09:00 | ||
| Customizing Icons | 00:05:00 | ||
| Create Compelling Graphics with SmartArt | 00:06:00 | ||
| Visualize Data with Charts | |||
| The Commonly Used Column Chart | 00:03:00 | ||
| Changing the Chart Design | 00:02:00 | ||
| Formatting Elements of a Chart | 00:07:00 | ||
| Modifying the Data Type and Location of a Chart | 00:07:00 | ||
| Little Slice of Pie Charts | 00:06:00 | ||
| Excel's Printing Options | |||
| Print Preview Options | 00:05:00 | ||
| Excels Page Layout View | 00:07:00 | ||
| Printing a Specific Range of Cells | 00:03:00 | ||
| Converting Spreadsheets to PDF Files | 00:03:00 | ||
| Benefits of Using Excel Templates | |||
| Why Create an Excel Template | 00:02:00 | ||
| How to Create an Excel Template | 00:06:00 | ||
| Working with Excel Datasets | |||
| How to Prepare Data for Analysis | 00:05:00 | ||
| How to Sort Data in Excel | 00:03:00 | ||
| Multi Level Sorting | 00:03:00 | ||
| Custom Sorting Datasets in Excel | 00:03:00 | ||
| Applying Filters to Datasets | 00:05:00 | ||
| Creating Subtotals within a Dataset | 00:06:00 | ||
| Converting Datasets into Tables | 00:06:00 | ||
| Finding and Removing Duplicate Values | 00:08:00 | ||
| Excel Database Functions | |||
| The SUMIF() Function | 00:09:00 | ||
| The DSUM() Function | 00:08:00 | ||
| DSUM() Function Cont | 00:08:00 | ||
| The SUBTOTAL() Function | 00:07:00 | ||
| Excel Data Validation | |||
| What is Excel Data Validation? | 00:02:00 | ||
| Creating a Drop Down List with Data Validation | 00:08:00 | ||
| Different Types of Data Validation | 00:06:00 | ||
| Adding Custom Alerts to Data Validation | 00:07:00 | ||
| Creating a Dynamic Drop Down List | 00:04:00 | ||
| Complex Validation – Dependent Drop Down List | 00:09:00 | ||
| Excel PivotTables | |||
| Creating an Excel Pivot Table | 00:06:00 | ||
| Modifying Excel Pivot Tables | 00:06:00 | ||
| Grouping and Filtering PivotTable Data | 00:07:00 | ||
| Drilling Down into PivotTable Data | 00:02:00 | ||
| Creating PivotCharts and Utilizing Slicers | 00:08:00 | ||
| Excel's PowerPivot Add-In | |||
| What is PowerPivot? | 00:04:00 | ||
| Activating the Excel PowerPivot Add-In | 00:02:00 | ||
| Creating Relationships between Data Tables | 00:07:00 | ||
| Using Data Models to Create PivotTables | 00:05:00 | ||
| How to Create PowerPivot KPI’s | 00:09:00 | ||
| Excel's Conditional Functions | |||
| Excel’s IF() Function | 00:06:00 | ||
| IF() Function with AND() Criteria | 00:06:00 | ||
| IF() Function with OR() Criteria | 00:06:00 | ||
| Nesting Multiple IF() Functions | 00:08:00 | ||
| The COUNTIF() Function | 00:05:00 | ||
| Key Benefits of Using Named Ranges | 00:05:00 | ||
| Excel's Lookup Functions | |||
| VLOOKUP() Function | 00:09:00 | ||
| The Beauty of Excel’s IFERROR() Function | 00:04:00 | ||
| HLOOKUP() Function | 00:07:00 | ||
| INDEX() Function | 00:05:00 | ||
| MATCH() Function | 00:05:00 | ||
| INDEX() and MATCH() Combined | 00:06:00 | ||
| Two-Way Lookup with INDEX() and MATCH() | 00:05:00 | ||
| Text Based Functions in Excel | |||
| LEFT(), RIGHT() and MID() Function | 00:08:00 | ||
| Extracting Specific Text using LEN() and SEARCH() | 00:13:00 | ||
| Combining Text with CONCATENATE() | 00:07:00 | ||
| Quick Tips and Other Text Based Functions | 00:06:00 | ||
| Auditing Formulas and Custom Views in Excel | |||
| Tracing Precedents and Dependents in Formulas | 00:05:00 | ||
| Showing Formulas | 00:02:00 | ||
| Grouping Data | 00:03:00 | ||
| 3D Referencing in Formulas | 00:06:00 | ||
| Utilizing the Watch Window in Excel | 00:03:00 | ||
| How to Freeze Panes in Excel | 00:03:00 | ||
| Excel’s “What If?” Tools | |||
| Excels Scenario Manager Tool | 00:06:00 | ||
| Goal Seek in Excel | 00:07:00 | ||
| Compare Results with Excel Data Tables | 00:05:00 | ||
| Solver Tool | 00:11:00 | ||
| Welcome to Excel VBA! | |||
| The Power Behind Excel VBA | 00:03:00 | ||
| A Look Inside the Visual Basic Editor | 00:04:00 | ||
| Recording a Macro | 00:10:00 | ||
| Saving and Opening a Macro Enabled Workbook | 00:03:00 | ||
| The VBA Language | |||
| Modules and Procedures | 00:07:00 | ||
| Object Methods and Properties | 00:06:00 | ||
| Excel VBA Variables | 00:05:00 | ||
| Writing VBA Code | |||
| Referencing a Range | 00:14:00 | ||
| InputBox and MsgBox | 00:06:00 | ||
| Using Variables in VBA Code | 00:05:00 | ||
| If Then Else Statement | 00:11:00 | ||
| Worksheet Functions inside VBA | 00:08:00 | ||
| Creating User Defined Functions | 00:10:00 | ||
| User Defined Functions within VBA Scripts | 00:07:00 | ||
| Important VBA Tools and Logic | |||
| Find Last Row of Data | 00:06:00 | ||
| Find Last Column of Data | 00:04:00 | ||
| With Statement | 00:05:00 | ||
| Debugging and Error Handling | 00:07:00 | ||
| Excel VBA Loops | |||
| Debugging and Error Handling Cont | 00:07:00 | ||
| For Next Loop | 00:10:00 | ||
| Do Until Loop | 00:07:00 | ||
| For Each Loop | 00:04:00 | ||
| Triggering Macros | |||
| Assigning Macros to Shapes | 00:04:00 | ||
| Form Controls vs ActiveX Controls | 00:08:00 | ||
| Worksheet Events | 00:04:00 | ||
| Workbook Events | 00:03:00 | ||
| Fun with VBA Events | 00:07:00 | ||
| Excel User Forms | |||
| Creating an Excel UserForm | 00:04:00 | ||
| Adding Controls to UserForms | 00:10:00 | ||
| How to Show an UserForm | 00:04:00 | ||
| Passing TextBox Values to Desired Cells | 00:07:00 | ||
| Passing Option Buttons Values to Desired Cells | 00:07:00 | ||
| UserForm ComboBoxes | 00:09:00 | ||
| Clearing Values from UserForm Controls | 00:04:00 | ||
| How to Close an UserForm | 00:02:00 | ||
| UserForms and Protected Sheets | 00:05:00 | ||
| Starting a Career in Excel | |||
| Creating an Excel Resume | 00:05:00 | ||
| Getting Started with Freelancing | 00:07:00 | ||
| How to Become an Excel Freelancer | 00:06:00 | ||
| Top Freelance Sites | 00:06:00 | ||
| How to Get Your First Client | 00:08:00 | ||
| Personal Branding | 00:07:00 | ||
| Networking Do’s and Don’ts | 00:05:00 | ||
| Importance of Website | 00:05:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
Mechanical & Cooling Data Center
68£12.00
Data Center Introduction
49£12.00
