Booking options
£25
£25
On-Demand course
2 hours 34 minutes
All levels
ð Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! ð
Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before.
ð Course Curriculum ð
ð¹ Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques.
ð¹ Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation.
ð¹ Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision.
ð¹ Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets.
ð¹ Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly.
ð¹ Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively.
ð¹ Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly.
ð¹ Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information.
ð¹ Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly.
ð¹ Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks.
ð¹ Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements.
ð Why Choose Our Course? ð
ð Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities.
ð¨âð« Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights.
ð¤ Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice.
ð Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains.
ð Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. ð
Section 1 - Excel - Intermediate
Excel Intermediate Introduction
00:00
Intermediate Shortcut Keys
00:00
Section 2 - Lists
What are Lists
00:00
Sorting a List
00:00
Sorting - Multiple Criteria
00:00
Custom Sort
00:00
What are Filters
00:00
Format a List as a Table
00:00
Section 3 - DataBase Functions
Introduction to DataBase Functions
00:00
DSum Function
00:00
DSum Function - Single Criteria
00:00
DSum Function - Multiple Criteria
00:00
DAverage
00:00
DCount Function
00:00
Subtotal
00:00
Section 4 - Data Validation
Data Validation - List
00:00
Data Validation - Decimal
00:00
Input and Error Messages
00:00
Section 5 - Importing and Exporting
Importing Data from Text Files
00:00
Importing Data from MS Access
00:00
Exporting Data to a Text File
00:00
Section 6 - Creating Basic Charts
Creating Basic Charts
00:00
The Chart Ribbon
00:00
Adding and Modifying Data on a Chart
00:00
Formatting Charts
00:00
Section 7 - Pivot Tables
Understanding Pivot Tables
00:00
Creating Pivot Tables
00:00
Pivot Table Calculations
00:00
Grouping Pivot Table Data
00:00
Formatting Pivot Table Data
00:00
Drilling Down into Pivot Table Data
00:00
Creating Pivot Charts
00:00
Filtering Pivot Table Data
00:00
Filtering using the Slicer
00:00
Section 8 - Working with Large Data
Grouping Data
00:00
Consolidating Data
00:00
Section 9 - LookUp Functions
VLookUp
00:00
HLookUp
00:00
Index and Match
00:00
Section 10 - Advanced Functions
FV Function
00:00
PMT Function
00:00
Hyperlinks
00:00
Text to Columns
00:00
Section 11 - Excel Intermediate - Conclusion
Excel Intermediate - Conclusion
00:00
Compete High: Your