Belajar Microsoft Excel Dari 0 Menjadi Mahir

Master Excel: From Beginner to Expert

This comprehensive course is designed for beginners looking to master Microsoft Excel and unlock its full potential. Whether you're new to spreadsheets or want to elevate your skills, this course provides a structured learning path to proficiency.

What You'll Learn:

• Excel Fundamentals:

  • Navigating the Interface: Understand the Excel menu, including sheets, cells, ranges, rows, and columns.
  • Efficient Typing: Learn best practices for typing within Microsoft Excel.
  • Cell Formatting: Master various formatting options to display data effectively (e.g., General, Number, Currency, Accounting, Date, Time, Percentage, Text, Custom).
  • Basic Arithmetic Formulas: Learn fundamental mathematical operations: addition, multiplication, division, subtraction, and exponentiation.
  • Comparison Operators: Utilize operators like =, >, >=, and < for data comparison.
  • Essential Menu Functions: Explore and utilize key Excel menu options.
  • Absolute Cell References: Understand and use absolute cell references (using F4).
  • Data Validation & Drop-Down Lists: Implement data validation and create dynamic drop-down lists for data entry control.
  • Define Names: Learn how to define names for cells and ranges.
  • Setting Regional Formats: Configure Excel to adhere to regional settings.

• Powerful Formulas & Functions:

  • Popular Formulas: Become proficient with essential formulas like SUM, COUNT, AVERAGE, MAX, and MIN, including using criteria within these formulas.
  • Wildcards: Utilize wildcard characters (*, ?, ~) for flexible searching.
  • Text Functions: Master functions for concatenating cells and changing case (using &, CONCATENATE, TEXTJOIN, LOWER, UPPER, PROPER).
  • Text Formulas: Learn various functions to manipulate text data.
  • Lookup Functions: Effectively use VLOOKUP, HLOOKUP, and XLOOKUP for data retrieval.
  • Text Manipulation: Utilize LEFT, MID, and RIGHT functions to extract text substrings.
  • Conditional Formulas: Employ IF and IFS functions for decision-making within formulas.
  • Replace & Substitute: Learn to use REPLACE, SUBSTITUTE, and TRIM functions for text cleaning and modification.
  • Date & Time Functions: Work with dates and times using DATEDIF and WORKDAY.
  • SUMPRODUCT & Subtotal/Aggregate: Utilize powerful functions for complex calculations and data summarization.

• Advanced Excel Techniques:

  • Combining Formulas: Learn to combine formulas using MATCH, INDEX, and FIND/SEARCH.
  • Data Retrieval: Master techniques for data retrieval using LARGE, SMALL, and RANK.
  • Dynamic Dropdowns: Create hierarchical and dynamic dropdown lists.
  • Preventing Automatic Input: Implement strategies to prevent unwanted automatic data changes.
  • Array Formulas & CSE (Control + Shift + Enter): Understand and utilize array formulas and the CSE method for advanced calculations.
  • Advanced VLOOKUP: Explore VLOOKUP with left criteria and VLOOKUP with multiple criteria.
  • Searchable Dropdowns: Create searchable dropdown lists for improved data entry.

Course Features:

• Structured Curriculum: A well-organized curriculum progressing from basic to advanced concepts.
• Real-World Examples: Learn through practical examples commonly encountered in the workplace.
• Practice Exercises: Reinforce your understanding with regular practice exercises.
• Downloadable Resources: Access supplementary learning materials.