Ultimate Microsoft Excel : Ms Excel Course - Learn & Earn

You are Expecting to Learn:

1. Excel Environment (Toolbar-Formulabar-Sheetbar)

2. Excel Terms (Workbook-Worksheet-Rows-Columns-Cell-Range)

3. Change Excel Worksheet Direction (RTL or LTR)

4. Main Features (Type Formula-Chart-Table)

5. Subtotal for Grouping

6. Power Pivot & Power Query

You are Expecting to Learn:

1. Form designing Techniques

2. Page Layout

3. Form Journey Starts in Excel

4. Paste Options

You are Expecting to Learn:

1. Cell Formats

2. Cell Size

3. cell Rotation

4. Paste Options

5. Finishing

You are Expecting to Learn:

1. Worksheet Copy

2. Decorating options in excel (Change font-Bold-Alignment)

3. Merge

4. Insert Picture (Cut and Resize picture in Excel)

You are Expecting to Learn:

1. Margins

2. Indents

3. Coloring Cells

4. Cell Rotation

5. Finishing

6. Important Notes

You are Expecting to Learn:

1. Proper Function

2. Trim Function

3. Copy-Paste the Formula

4. Concatenate

5. Quotation Mark

6. Left Function

7. Find

You are Expecting to Learn:

1. Search Functions

2. Worksheet Coloring

3. Vlookup

4. Hlookup

5. Index

6. Index Reference

7. Match

8. Conclusion

You are Expecting to Learn:

1. Index Match

2. Vlookup Match

3. Create List

4. Vlookup with 2 Forms

5. Worksheet Coloring

Open The file and solve the Puzzle!

You are Expecting to Learn:

1. Count

2. CountA

3. Count Blank

4. Count If

5. Count Ifs

You are Expecting to Learn:

1. Sum

2. SumIF

3. SumIFS

4. Sum Product

5. Sum If Between 2 Dates

6. Sum If Between 2 Dates with Conditions

You are Expecting to Learn:

1. IF

2. IF Error

3. IF NA

4. IFS - MAC

5. IFS - Windows

You are Expecting to Learn:

1. Text Function

2. Vlookup Match

3. IF Function

You are Expecting to Learn:

1. Name

2. Offset Function

3. Create Dynamic Range

You are Expecting to Learn:

1. Default Chart

2. Chart Adjustment-Designing

You are Expecting to Learn:

1. Chart Format

2. Vertícal Axis Adjustment

You are Expecting to Learn:

1. More than 1 Data in a Chart

You are Expecting to Learn:

1. Ring & Doughnut Charts

2. Measuring Data with Doughnut Chart

3. Round Edges

4. Gear Chart

5. Another Format of Doughnut Chart

You are Expecting to Learn:

1. Line Charts

You are Expecting to Learn:

1. Combo Chart

You are Expecting to Learn:

1. Waterfall Chart

You are Expecting to Learn:

1. Speedometer Chart

You are Expecting to Learn:

1. Search

2. Search by Format

3. Search in a Range

4. Search on a Column

5. Replace

6. Go to Special

You are Expecting to Learn:

1. Sort

2. Custom Sorting - Sort by Color

3. more than 1 Column Sorting

4. Continue with the Current Selection

You are Expecting to Learn:

1. Grouping

2. Worksheet Unhiding & Hiding

3. Group According to Certain Data

4. Change Collapse Direction

5. Subtotals

You are Expecting to Learn:

1. Filtering

2. Dive into Filtering

You are Expecting to Learn:

1. Basic Conditional Formatting

2. Highlight Cells Rules

3. Difference of Equal to & Text That Contains

4. Duplicate Values

5. Top/Bottom rules

6. Clear Rules

7. Visualize Highlights

You are Expecting to Learn:

1. Cell Splitting

2. Pane Splitting

3. Freezing

4. Freezing Multiple Columns & Rows

You are Expecting to Learn:

1. Dynamic Forms - Names

2. Define Names

3. Calling Names

4. Filling Blanks in the List Sheet

You are Expecting to Learn:

1. What are Dynamic Forms?

2. Names in List Sheet

You are Expecting to Learn:

1. Insert Data

2. Insert Formula in Form Sheet

3. Conditional Formatting for Errors

You are Expecting to Learn:

1. Charts

2. Formatting the Chart

3. Direct Chart with Names

You are Expecting to Learn:

1. Trimming

2. Print Preview

3. Print Size - Print Page Size - Number of Prints - Settings of Print Preview

4. Pages-Collated

5. Portrait & Landscape

6. Margins

You are Expecting to Learn:

1. Page Setup

2. Header - Footer

You are Expecting to Learn:

1. Margins

2. Worksheet

3. Page Order

4. Configure the Print Page

You are Expecting to Learn:

1. Create a Table

2. Table Tips

3. Table Benefits

4. Total Rows

You are Expecting to Learn:

1. Design the Table

2. Slicer

3. External Table Data

4. Table Style Options

5. Remove Table

You are Expecting to Learn:

1. Create PIvot Table

2. Pivot Table

3. Get Reports From Pivot Tables

4. 2nd Example of Pivot Table

5. Important Note

6. 3rd Example of Pivot Table

7. Filter

You are Expecting to Learn:

1. 4th Example of Pivot Table

2. Timeline

3. Pivot Table Tricks

4. Grouping

5. Move Manually

6. Move Table

7. Pivot Chart

You are Expecting to Learn:

1. Human Resource Forms

2. Project Management

3. Form

4. Pivot Table (Ex.1)

5. Example 2 (Pivot Table)

6. Example 3 (Pivot Table)

You are Expecting to Learn:

1. Time Format Cells

2. Pivot Table

3. Pivot Chars

You are Expecting to Learn:

1. Sales Record

2. Table

3. Stone Type Name

4. Total Sales

5. Pivot Table

6. Link Filters in Pivot Table

7. Dashboard

You are Expecting to Learn:

1. Order the Worksheets

2. Clickable Shape on a Worksheet

3. Add Link

4. The Power of

5. Wrap Text

6. Cell Format

You are Expecting to Learn:

1. Custom Table Design

2. Remove Gridlines in a Worksheet

3. Pivot Charts Design

You are Expecting to Learn:

1. Pivot Charts Design (Second Chart)

2. Customize Slider

You are Expecting to Learn:

1. Customize Data

2. Sort According to Icon

3. Classifying the Data

You are Expecting to Learn:

1. Excel is Advanced Filtered

2. Advance Filtering With 2 Conditions (And)

3. Advance Filtering With 2 Conditions (Or)

4. Look for a Criteria in a Range

5. Mixture of Criteria

6. Advance Filtering the Rates

7. Advanced Filter Box Options

You are Expecting to Learn:

1. What is Power Query?

2. Easy Power Query Example in Excel

3. Create Power Query

4. How to See Active Queries

5. Combine Queries

You are Expecting to Learn:

1. Query Window

2. Merge Columns in Power Query

3. Remove Duplicates

4. Remove Column in Power Query

5. Change Column Format

You are Expecting to Learn:

1. Power Query Advantage

2. Update

3. Power Query Refresh Macro

4. Power Query Edit

You are Expecting to Learn:

1. Human Resource Forme

2. Power Query

3. Power Query From External source

4. Pivot Table

5. Update

You are Expecting to Learn:

1. Power Query Data & Time Based

2. Power Query from a Folder

3. Edit Power Query

4. Pivot Table

5. Pivot Chart

You are Expecting to Learn:

1. What is Power Pivot

2. Activate Power Pivot

3. My Tables

4. Key in Power Pivot

5. Power Pivot

6. Linking Tables in Power Pivot

You are Expecting to Learn:

1. Get Report From Power Query

2. DAX

3. Update

4. SUMX

5. The benefit of Power Pivot

You are Expecting to Learn:

1. Power Pivot For Project Management

2. Power Query

3. Key Columns

4. Power Pivot

5. Linking in Power Pivot

6. Define Date Base in Power PIvot

7. Power Pivot Table

You are Expecting to Learn:

1. Power Pivot for Project Management

2. Physical % Complete

3. Actual Cost

4. Planned Cost

You are Expecting to Learn:

1. Earned Cost

2. CPI

3. Change Power Pivot Table Headers

4. Very Important Note

You are Expecting to Learn:

1. Manhour

2. Planned Manhour

3. Actual Manhour

4. Earned MAnhour

5. CPI (Manhour)

6. Manhour % Complete

7. Cumulative Planned Manhour

You are Expecting to Learn:

1. Power Pivot Chart

2. Cumulative Chart Without Cumulative DAX

3. Cumulative Chart With DAX

4. Cumulative Actual Manhour

5. Design the Chart

You are Expecting to Learn:

1. Overview of the Course

2. Present the Reports

3. What do I need in a Dashboard?

4. Dashboard in Excel

5. %Planned & Actual Cost

You are Expecting to Learn:

1. Bar Chart

2. Design the Bar Chart

3. Slicer

You are Expecting to Learn:

1. Manhour % Complete Speedometer Chart

2. Doughnut Chart

3. Pointer of Speedometer Chart

4. Trimming Time!

You are Expecting to Learn:

1. Final Result of the course!

2. Printing the Dashboard Worksheet