Certiqo | Courses

Activity 2 of 5

Previous Prev Activity 2 of 5

Appending Multiple Excel Tables/Sheets from One File

Duration: 5m 33s

Lesson Locked

Please enroll in the course before accessing this one.

1. What is Power BI and Why It Matters
3m 37s

2. Downloading and Installing Power BI Desktop
5m 22s

1. Creating Column Charts
7m 31s

2. Building Stacked Column Charts
2m 25s

3. Designing Pie Charts
3m 6s

4. Designing Donut Charts
1m 23s

5. Creating Funnel Charts
1m 21s

6. Using Ribbon Charts
4m 12s

1. Creating Basic Maps
3m 44s

2. Building Filled Maps
2m 45s

3. Creating Maps with Pie Charts
2m 11s

4. Formatting Map Visuals
2m 34s

5. Customizing Map Backgrounds
2m 12s

1. Creating a Basic Table
3m 25s

2. Formatting Tables
4m 51s

3. Applying Conditional Formatting to Tables
6m 47s

4. Changing Data Aggregations in Tables
6m 47s

5. Creating Matrices in Power BI
3m 24s

6. Applying Conditional Formatting to Matrices
4m 13s

7. Using Automatic Hierarchies in Matrices
5m 46s

8. Managing Subtotals and Grand Totals
3m 28s

9. Applying Number Formatting in Tables & Matrices
4m 23s

1. Creating Number Cards
7m 38s

2. Creating Text Cards
8m 19s

3. Creating Date Cards
6m 23s

4. Building Multi-Row Cards
5m 1s

5. Applying Visual-Level Filters
4m 27s

6. Applying Page-Level Filters
3m 57s

7. Applying Report-Level Filters
4m 26s

1. Creating Text Slicers
3m 28s

2. Formatting Text Slicers
4m 38s

3. Creating Date Slicers
5m 51s

4. Formatting Date Slicers
3m 45s

5. Creating Number Slicers
3m 11s

1. Introduction to charts
7m 53s

2. Creating Drill-Down Donut Charts
4m 28s

3. Designing Word Cloud Visuals
3m 3s

4. Building Sankey Charts
4m 17s

5. Creating Infographic Visuals
5m 10s

6. Using Play Axis for Animation
2m 19s

7. Adding Scrolling Visuals
2m 9s

8. Designing Sunburst Charts
2m 57s

9. Creating Histograms
3m 38s

1. Inserting Objects
3m 59s

2. Inserting Text
2m 23s

3. Inserting Shapes
2m 10s

4. Adding Buttons to Reports
2m 9s

5. Creating Hyperlinks and Web URL Actions
2m 3s

6. Setting Up Page Navigation
2m 5s

7. Using Bookmarks for Interactivity
2m 11s

1. Creating a Superstore Report
24m 34s

2. Publishing Reports to the Power BI Service
4m 45s

3. Exporting Reports (PPT, PDF, PBIX)
4m

4. Building Dashboards in Power BI Service
8m 3s

5. Troubleshooting Dashboard Issues
6m 5s

1. Merging and Splitting Columns
13m 36s

2. Trimming and Cleaning Text
5m 55s

3. Changing Text Case (Upper, Lower, Proper)
4m 44s

4. Adding Prefixes and Suffixes
3m 19s

5. Extracting Substrings with LEFT, RIGHT & MID
5m 58s

6. Extracting Text with Delimiters
3m 42s

1. Extracting Year, Quarter, Month, and Day
3m 1s

2. Calculating Date Differences, Earliest & Latest Dates
2m 9s

3. Extracting Day Names and Month Names
2m 9s

4. Using Day of Week/Month/Year & Week of Month/Year
2m 7s

5. Extracting Dates from Date & Time Fields
2m 11s

6. Calculating Age in Two Clicks
3m 19s

7. Finding Day of Year, Quarter, and Month of Birthdate
5m 1s

1. Performing Basic Math (Add, Subtract, Multiply, Divide)
8m 38s

2. Calculating Percentages and Ratios
6m 1s

3. Rounding Numbers
3m 13s

4. Using IsEven, IsOdd, and Sign Functions
3m 8s

1. Appending Multiple CSV Files from a Folder
9m 13s

2. Appending Multiple Excel Tables/Sheets from One File
5m 33s

3. Appending Excel Tables with Different Column Counts
7m 51s

4. Appending Multiple Excel Files from a Folder
11m 4s

5. Appending Different Data Source Files in Power Query
4m 46s

1. HR Analytics Project – Part 1
26m 56s

2. Knowledge Check - Final Assessment
20m

3. HR Analytics Project – Part 2
7m 7s