Microsoft Excel Fundamentals: Beginner to Advanced

By uninet Categories: IT & Workplace Software

About Course

Welcome to Excel Fundamentals, your all-in-one course designed to take you from absolute beginner to confident advanced user.

Whether you’re completely new to Microsoft Excel or looking to sharpen and professionalize your skills, this course is structured to guide you step-by-step through every essential topic — with hands-on examples, practical exercises, and real-world applications

Course Content

Beginner Level

Video : Beginner level

04:31

Intermediate Level
This level moves beyond the basics, introducing more powerful tools for data manipulation and analysis. Learners at this stage become more efficient and capable of handling larger datasets. Key areas of focus include: Working with More Complex Formulas and Functions: Logical Functions: IF, AND, OR. Text Functions: CONCATENATE, LEFT, RIGHT, MID, TRIM. Lookup Functions: VLOOKUP, HLOOKUP (essential for retrieving data from other tables). Date and Time Functions: TODAY, NOW, DAY, MONTH, YEAR. Data Management and Organization: Sorting and Filtering: Organizing data based on various criteria. Conditional Formatting: Applying formatting based on specific cell values. Tables: Converting data ranges into Excel Tables for easier management, filtering, and summarization. Introduction to Charts and Graphs: Creating various chart types (bar, line, pie) to visualize data effectively. Data Validation: Setting rules for data entry to ensure accuracy. Basic Data Analysis Tools: Subtotals and Grouping.

Advanced Level
The advanced level delves into sophisticated features, automation, and in-depth data analysis techniques, transforming users into highly efficient and productive Excel experts. This level often involves working with larger datasets and automating repetitive tasks. Key learning outcomes include: Advanced Functions and Formulas: Array Formulas: Performing calculations on multiple items in an array. SUMIFS, COUNTIFS, AVERAGEIFS: Performing conditional calculations on multiple criteria. Data Analysis Tools: PivotTables and PivotCharts: Powerful tools for summarizing, analyzing, exploring, and presenting data from large datasets. Power Query (Get & Transform Data): Connecting to, cleaning, and transforming data from various sources. Data Models and Relationships: Building relationships between tables for more complex analysis. Macros and VBA (Visual Basic for Applications): Automating repetitive tasks by recording macros or writing custom VBA code. Dashboard Creation: Designing interactive dashboards using charts, PivotTables, and other features to provide a comprehensive overview of data. Advanced Charting Techniques: Creating custom charts, sparklines, and dynamic charts.

Student Ratings & Reviews

No Review Yet

Your Instructor

uninet

UNINET is the Corporate University of NETIS Group.

The place intended for the transmission of knowledge to NETIS Group employees.

Microsoft Excel Fundamentals: Beginner to Advanced

Microsoft Excel Fundamentals: Beginner to Advanced