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

Course Images

Microsoft Excel 2019 - Intermediate Level Training

Microsoft Excel 2019 - Intermediate Level Training

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 2 hours 34 minutes

  • All levels

Description

🌟 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

About The Provider

Tags

Reviews