• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

4 Courses in Leicester

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Microsoft Excel Intermediate - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Microsoft Excel Training

By FourSquare Innovations Ltd

FourSquare Training specialise in private, corporate Microsoft Excel courses delivered at your premises and tailored to your needs.

Microsoft Excel Training
Delivered In-Person in Birmingham + 37 moreFlexible Dates
£450 to £800

Excel - intermediate (In-House)

By The In House Training Company

Excel - intermediate (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Microsoft Excel Advanced - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Online Options

Show all 37

Microsoft Excel 2019 - Intermediate Level Training

By Compete High

🌟 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. 🔓 Course Curriculum 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

Microsoft Excel 2019 - Intermediate Level Training
Delivered Online On Demand2 hours 34 minutes
£25

Microsoft Excel Intermediate Level

By iStudy UK

Microsoft Excel Intermediate Level
Delivered Online On Demand8 hours 10 minutes
£25

Microsoft Excel - Intermediate Level

4.3(43)

By John Academy

Microsoft Excel - Intermediate Level
Delivered Online On Demand8 hours 10 minutes
£19

Microsoft Excel Intermediate Certificate

By OnlineCoursesLearning.com

Microsoft Excel Intermediate Certificate
Delivered Online On Demand
£50

Microsoft Office 2013 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Microsoft Office 2013 Excel Intermediate - Complete Video Course
Delivered Online On Demand5 hours 4 minutes
£22

Microsoft Office 2016 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Microsoft Office 2016 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 16 minutes
£22

Microsoft Office 2010 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Microsoft Office 2010 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 49 minutes
£22

Microsoft Office 2007 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Microsoft Office 2007 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 56 minutes
£22

Microsoft Office 2007 Excel Intermediate

5.0(1)

By Course Gate

Microsoft Office 2007 Excel Intermediate
Delivered Online On Demand4 hours 11 minutes
£11.99