Ahmed Ibrahem

15 Courses Enrolled โ€ข 6 Courses Completed

My Portfolio

Power Bi Masterclass

โœ… What I Learned from the Microsoft Power BI Course This course provided a comprehensive introduction to Microsoft Power BI…

View more

Mastering Excel Formulas and Functions

โœ… What I Learned from the Advanced Excel Formulas & Functions Course This course focused on advanced Excel functions and…

View more

Excel essential training

โœ… What I Learned from the Microsoft Excel Course This course provided me with both foundational and advanced Excel skills,…

View more

Biography

Bio data is empty
whatsapp-logo
Need help?

Power Bi Masterclass

โœ… What I Learned from the Microsoft Power BI Course
This course provided a comprehensive introduction to Microsoft Power BI โ€” a powerful tool for data visualization, reporting, and business intelligence. I learned how to import, clean, transform, and visualize data using a variety of built-in tools and techniques. Here’s a breakdown of the key concepts and skills I gained:

๐Ÿงญ Power BI Basics & Interface
Understood what Power BI is, how to download and install it.

Explored the Power BI interface, on-object interaction, and key settings.

Learned how to import data from various sources.

๐Ÿงน Data Preparation & Cleaning
Worked with the Query Editor to clean and transform data.

Performed tasks like:

Editing rows and columns

Changing data types

Using locale settings and replacing values

Extracting, splitting, and merging columns

Applied text and numeric transformations

๐Ÿ”— Data Modeling
Built relationships between tables using the Data Model.

Practiced one-to-many and many-to-many relationships.

Learned to edit, activate, and deactivate relationships, and understood cross-filter direction.

๐Ÿ“Š Data Visualization
Created various visuals including:

Stacked Column Charts

Pie Charts, Line Charts, Treemaps, Tables, Cards, and Maps

Customized visuals using the Format Pane, Data Labels, and Visual Headers.

Used Conditional Formatting and Sorting to enhance data display.

๐Ÿ“ˆ Advanced Query Techniques
Applied advanced tools like:

Append Queries

Merge Queries

Pivot and Unpivot columns

Column from Examples

Reference Queries & Duplicate Detection

๐ŸŽฏ Slicers, Filters & Interactions
Added Slicers to dashboards and learned how to:

Sync Slicers across pages

Clear, apply, and reset slicers

Use Top N filters with bookmarks

Edit page navigation, interactions, and use bookmarks for dynamic reporting.

๐Ÿง  Custom Columns, Measures & Calculations
Created Calculated Columns and Conditional Columns.

Built Measures to calculate metrics like Average, Count, and more.

Organized calculations into Measure Tables for better structure and clarity.

๐Ÿ Outcome
This Power BI course significantly enhanced my data analysis and reporting skills. I am now able to build fully interactive dashboards, clean and model data efficiently, and present insights using powerful visualizations. These skills equip me to make data-driven decisions and build reports for real-world business scenarios.

Mastering Excel Formulas and Functions

โœ… What I Learned from the Advanced Excel Formulas & Functions Course
This course focused on advanced Excel functions and formula techniques, enabling me to handle complex data tasks, perform dynamic lookups, and work with logic, text, and date/time functions. Below is a breakdown of the key topics I mastered:

๐Ÿงฎ Core Formula Skills
Created and copied formulas effectively.

Used absolute and mixed references to control cell behavior in formulas.

Applied AutoSum and understood how to convert formulas to static values.

Built 3D formulas to reference data across multiple sheets.

Named ranges for clarity and easier formula management.

๐Ÿ“Š Statistical Functions
Worked with MEDIAN, MODE, RANK, LARGE, and SMALL functions.

Used COUNT, COUNTA, and COUNTBLANK to analyze data frequency and completeness.

๐Ÿ”ข Rounding & Number Functions
Used ROUND, ROUNDUP, ROUNDDOWN, MROUND, MOD, and CONVERT.

Applied the AGGREGATE function to perform summary operations while ignoring errors or hidden data.

๐Ÿง  Conditional Logic & IF Family
Built logic using IF, Nested IF, Compound IF, and IFS functions.

Mastered conditional counting and max/min functions: COUNTIF, COUNTIFS, MAXIFS, MINIFS.

๐Ÿ”ค Text Functions
Extracted and cleaned text using LEFT, RIGHT, MID, TRIM, FIND.

Combined and modified text using CONCATENATE, PROPER, REPLACE, and SUBSTITUTE.

๐Ÿ” Lookup & Reference Functions
Used VLOOKUP (exact & approximate) and HLOOKUP.

Applied modern and powerful lookups: INDEX, MATCH, and combined INDEX-MATCH.

Learned LOOKUP, and explored the powerful XLOOKUP function.

Created dependent dropdown lists using INDIRECT.

๐Ÿ“… Date & Time Functions
Worked with DATE, YEAR, MONTH, DAY, MINUTE, TODAY, NOW.

Used WEEKDAY, NETWORKDAYS, WORKDAY, and DATEDIF to manage schedules and timelines.

๐Ÿ”— Dynamic & Indirect Referencing
Implemented dynamic ranges using OFFSET.

Used INDIRECT to create flexible formulas that refer to named ranges or sheet names.

๐Ÿงช Formula-Based Tools & Dynamic Arrays
Learned about formula spill behavior in dynamic arrays.

Applied advanced functions like:

UNIQUE โ€“ to extract distinct values

SORT, SORTBY, FILTER โ€“ for custom, formula-based sorting and filtering

Combined formulas for multi-step logic and automation

๐Ÿ Outcome
After completing this advanced Excel course, I can now build powerful, flexible formulas to analyze, transform, and summarize data dynamically. Iโ€™m proficient in logical functions, dynamic arrays, advanced lookup techniques, and automation through formulasโ€”skills essential for data analysis, financial modeling, and business intelligence work.

Excel essential training

โœ… What I Learned from the Microsoft Excel Course
This course provided me with both foundational and advanced Excel skills, allowing me to confidently manage, analyze, and present data effectively. Below is a summary of the key areas I covered:

๐Ÿ–ฅ๏ธ Excel Interface & Basics
Navigated the Menu System, Quick Access Toolbar, Formula Bar, and Status Bar.

Learned how to enter data, use Autofill, and work with dates, times, and cell comments.

๐Ÿงฎ Formulas & Functions
Created basic formulas and understood the difference between relative and absolute references.

Used built-in functions such as SUM, AVERAGE, MIN, MAX, and more.

Applied Autosum for quick calculations.

๐ŸŽจ Data Formatting
Formatted fonts, adjusted alignment, and used wrap, merge, and borders.

Customized number, date, and time formats.

Applied Conditional Formatting to highlight data based on rules.

Created and worked with Excel Tables.

๐Ÿงฐ Data Management
Inserted, deleted, moved, copied, and replaced rows and columns.

Used Hide/Unhide, Freeze Panes, and Split View for better worksheet navigation.

Managed Outlining to collapse and expand data views.

๐Ÿ”’ Data Protection
Unlocked and protected specific cells in worksheets.

Secured workbooks using passwords and controlled edit permissions.

๐Ÿง  Logical Functions
Worked with IF, Nested IF, and Compound IF statements to control logic within cells.

๐Ÿ” Data Lookup & Analysis
Used VLOOKUP for both exact and approximate matches.

Worked with COUNT functions such as COUNT, COUNTA, COUNTIF, etc.

๐Ÿงน Data Cleaning & Validation
Performed Sorting, Filtering, and Subtotal calculations.

Utilized tools like:

Flash Fill

Remove Duplicates

Data Validation to ensure input accuracy.

๐Ÿ“Š Pivot Tables
Created and modified Pivot Tables.

Grouped Pivot Table data by date, time, and custom criteria.

Summarized and analyzed large data sets quickly.

๐Ÿ Outcome
By completing this course, I gained practical, job-ready Excel skills. I can now confidently use Excel to input, analyze, protect, and visualize data, making me more efficient in tasks related to data management, business reporting, and office productivity.

Kindly provide your credentials to gain access to your account.

Google reCaptcha: Invalid site key.

Forget your password? Lost password

Don’t have account? Register

Hi, Welcome back!
Forgot Password?