MS Excel Beginner to Intermediate Level Training

Unlock Your Productivity with Microsoft Excel: A Comprehensive Course

Boost your efficiency and master data management with this in-depth Microsoft Excel course. Excel is an indispensable tool in the Microsoft Office suite, widely used for data entry, powerful data analysis, compelling data presentation, and complex calculations.

This MS Excel course caters to a broad audience, from beginners with no prior experience to those with some existing knowledge. It's specifically designed for engineers, auditors, record keepers, data analysts, data entry operators, students, teachers, and researchers – anyone seeking to leverage Excel's capabilities. If your work involves data manipulation or you're looking to enhance your skills in any field utilizing Excel, this training is for you.

This comprehensive course features 42 video lectures totaling approximately 4.5 hours of content. We start with the fundamentals, perfect for those completely new to MS Excel, but also include options to skip introductory material if you already possess basic Excel skills. The course is built around Microsoft Excel 2016, but the concepts are applicable to most versions of Excel, both older and newer.

To reinforce your learning, downloadable Excel sample files and practice worksheets are included. You'll also receive a handy MS Excel shortcut keys file to streamline your workflow.

Here's a detailed breakdown of what you'll learn:

• Introduction to Excel and its core features.
• Mathematical Functions in Excel: Master essential formulas for calculations.
• Absolute & Relative References and Excel Cell Name: Understand cell referencing for accurate formulas.
• Formatting & Data Types in Excel: Learn to format data for clarity and consistency.
• Roaming in Excel Worksheet or Workbook: Navigate efficiently through large spreadsheets.
• Operators & Equations in Excel: Build complex formulas using operators and equations.
• AutoFill, Paste Special Options & Excel Errors: Automate tasks and handle potential errors.
• Logical Functions in Excel: Utilize logical functions for decision-making.
• VLOOKUP Function in Excel: Extract data efficiently using VLOOKUP.
• Auditing in Excel: Ensure data accuracy and identify inconsistencies.
• Inserting Charts, Tables, Comments & Hyperlink: Visualize data and enhance collaboration.
• Info, Text, Date, Time & Reference Functions: Work with various data types effectively.
• Data Tools in Excel: Utilize powerful data tools for cleaning and transformation.
• Conditional Formatting, Sort & Filter Options: Highlight key data and organize information.
• Printing & Viewing: Optimize your Excel output for printing and sharing.

We're confident this Microsoft Excel course will significantly improve your skills and productivity. Enroll today and start mastering Excel!