Udemyallar

Microsoft Excel 2019 - كورس اكسيل من البدايه حتي الاحتراف

Learn Excel 2019: Master features from beginner to advanced. Includes video tutorials and notes for easy learning.

Related:Pivot Tables
4.6(94)
5,188students
4h 49m
Certificate
Mohamed Ezzat
Mohamed EzzatEngineer

Course Content

Microsoft Excel 2019 - كورس اكسيل من البدايه حتي الاحتراف is an all-levels Udemy course taught by Mohamed Ezzat. It runs 4h 49m, is taught in Arabic, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 94 reviews, with 5,188 students enrolled. It is a paid course, first published January 2021.

Master Excel: From Beginner to Advanced with Practical Skills

This comprehensive Excel course will take you from the very basics to advanced techniques, empowering you to efficiently manage and analyze data. No prior Excel experience is required – we start with the fundamentals!

What You'll Learn:

  • Excel Fundamentals: This course is based on the 2019 version of Excel, but the core concepts are applicable to earlier versions. We begin with a complete introduction to the Excel interface and how to navigate the program.
  • Essential Formulas & Functions: Become proficient with core Excel functions including:
    • AutoFill: Quickly and easily populate data series.
    • Sum, Count, Average, Max, Min: Master basic statistical calculations.
    • IF Functions (Simple & Nested): Make decisions within your spreadsheets.
    • Statistical Functions: Explore a wide range of statistical functions for data analysis.
    • Conditional Summing (SUMIF & SUMIFS): Calculate sums based on specific criteria.
    • Logical Functions (AND & OR): Combine conditions for complex calculations.
    • Lookup Functions: Efficiently retrieve data from other cells or sheets.
    • Rounding Functions (CEILING, FLOOR, INT): Control number precision.
    • Small & Large Functions: Find the smallest and largest values.
    • Rank Functions: Determine the rank of values within a dataset.
  • Data Manipulation & Organization: Learn to effectively manage and organize your data:
    • Filter & Sort: Quickly find and arrange data.
    • Flash Fill & Text to Columns: Effortlessly clean and transform text data.
    • Remove Duplicates: Eliminate redundant entries.
    • Data Validation: Ensure data accuracy and consistency.
    • Data Consolidation: Combine data from multiple workbooks.
    • Strikethrough Formatting: Apply visual emphasis to text.
    • Table Creation: Organize data into structured tables.
  • Advanced Excel Techniques: Take your skills to the next level:
    • Conditional Formatting: Highlight data based on specific rules.
    • Subtotal vs. Sum: Understand the difference and when to use each.
    • Charts & Sparklines: Visualize your data effectively.
    • Pivot Tables: Summarize and analyze large datasets.
    • What-If Analysis: Explore different scenarios and their outcomes.
    • Solver: Find optimal solutions to complex problems.
    • Macros: Automate repetitive tasks.
  • Data Integration & Sharing:
    • Linking to External Data: Pull data from multiple worksheets and files.
    • Exporting to Word & AutoCAD: Seamlessly integrate Excel data into other applications.
    • Online Collaboration: Share and edit Excel files with others online.
  • Excel Productivity:
    • Keyboard Shortcuts: Boost your efficiency with essential shortcuts.
    • Text Manipulation & Translation: Clean and translate text within Excel.
    • Border & Table Formatting: Enhance the visual appeal of your spreadsheets.
    • Printing Options: Customize your Excel printouts.
    • Workbook Protection: Secure your data.

Course Features:

  • Detailed PDF Guides: Each video lesson is accompanied by a comprehensive PDF guide for easy reference.
  • Flexible Learning: Learn at your own pace and revisit materials as needed.
  • Ongoing Support: Ask questions and get help anytime! I'm here to assist you with understanding concepts and completing specific tasks.
  • Continuous Updates: New video content will be added regularly to keep your skills current.
$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.