The Complete Excel Practical Course: Learn, Build & Visualiz

Learn how to cut, copy, and paste selected cells in Excel using shortcuts such as Ctrl+X to move them to a new location.

Explore how to format dynamic data dashboards by aligning content in cells, wrapping text to fit column widths, and merging cells to center titles and data.

Master setting and formatting specific tables in Excel by selecting the table area with quick shortcuts and adding data while preserving the same formatting.

Apply the sum formula to total vehicle costs, compute margins, and derive selling price and profit in dollars, using a complete column total.

Apply the sumif formula to calculate total profit per brand by defining the criteria range and the sum range for Toyota.

Use max and min formulas in Excel to identify the highest and lowest vehicle sales, then format the results showing 187,000 as the maximum and 11,000 as the minimum.

Learn how to use the average formula to compute the average selling price and showroom metrics, including total profit per brand, max, min, and average, then compare count and counta.

Use the count formula to determine the total number of records, counting cars sold without brand specification by entering = and selecting cells to show 98 vehicles.

Learn how to use the countif formula to count records with a condition, such as vehicles sold per brand, by selecting the column and applying criteria.

Use the TODAY() function to display the current date in reports and dashboards; it updates daily when you open the file, ensuring printed or shared documents show the correct date.

Use Name Manager to name columns in Excel, then apply those names in formulas like sum; create names with underscores, assign categories such as employee, marketing, and buying clothes.

Discover the magic formula, the match function, to determine the position of a reference within a fixed lookup array, using an exact match to rank salespeople from 2015–2020.

Explore how the INDEX function retrieves exact row and column values from a table, using an array, absolute references with F4, and practical examples like Sarah's 2015 total sales.

Learn how to use vlookup to fetch exact sales values from large data sets, using absolute references and the correct column index to pull each salesperson’s 2019 figures.

Master pivot tables and avoid the five common mistakes to build dynamic data dashboards, saving time with labeling columns, avoiding blanks, and data validation.

Test slicers in dynamic dashboards to see how selections from June to July reshape sales data across categories like accessories and watches, revealing Peter's performance and guiding shop decisions.

Add and update data in pivot tables by copying August and September into the main data and refreshing the pivot to display the updated period.

Learn to build a personal budget dashboard that tracks your finances, reveals spending patterns, alerts overspending, and supports savings, investments, and multiple income sources.

Identify inputs such as month, transaction type, amount, owner, and reason to feed the dashboard, then calculate monthly budget, income, expenses, savings, and investments using pivot tables and formulas.

Format the raw data sheet by adjusting font, alignment, and title underlines. Apply data validation for months, transactions, and owners; and format amounts as US dollars with fewer decimals.

Master pivot tables, slicers, and charts to build interactive Excel dashboards by summing amounts, filtering by month and transaction type, and visualizing data with pie and bar charts.

Identify common preparation issues when building a dynamic Excel dashboard, refresh pivot tables, and format monthly transactions with slicers, borders, and clear labels.

Test and refine the dashboard by configuring slicers, formatting, and a horizontal layout for 12 months, then validate interactivity with multiple selections using the control key to reveal transaction detail.

Explore how small and medium enterprises use Excel to create a human resources dashboard for decisions, reporting, and monitoring training, overtime, leave, department sizes, and nationalities with gender distribution.

Identify inputs and outputs for the dashboard, including employee name, code, birth date, nationality, gender, education, department, job, salary details, and benefits; show gender and department distributions and salary by player.

Format the raw data sheet by applying data validation, consistent currency and date formats, center alignment, bold titles, and column width adjustments to prepare the dashboard and pivot table.

Apply simple calculations to a dashboard by counting total headcount and local employees. Compute localization percentage, format values, link data, and use the today function for up-to-date insights.

Create pivot tables and slicers to summarize employee data by nationality, department, and salary, and visualize results with charts to build a dynamic, organized dashboard.

Copy, arrange, and format charts on the dashboard to create a neat, professional layout. Add slicers and data labels to build a dynamic, tested data dashboard.

Explore a dynamic dashboard that tests interactively, showing employee data, salary trends, hiring years, and department, job layer, and country distributions with filterable visuals.

Harness dynamic dashboards to monitor annual and monthly performance, update visuals with a single button, and track employees, branches, and countries to drive decisions on products and locations.

Identify and define inputs and outputs to guide dynamic data dashboards, capturing monthly and annual performance, sales metrics, customer satisfaction, and branch, country, and product insights.

Format the raw data sheet for a dynamic Excel dashboard by applying currency and percentage formatting, borders, alignment, and data validation across U.S., U.K., and Oman.

Prepare pivot-table ready data by applying basic calculations in four columns, including profit margins, five percent tax, and three percent marketing expenses, to compute the cost of sale.

Create pivot tables and slicers to analyze annual performance, models, selling price, and profit. Build charts to compare branches, countries, brands, and customer satisfaction for dynamic dashboards.

Arrange charts on the dashboard by formatting, labeling, and coloring to create a neat, dynamic data dashboard, applying data labels, formatting to euros, and visual tweaks.

Wrap up the project by selecting maps and logos, aligning country labels, and assembling an interactive dashboard. Test 2020 performance, UK trends, and brand health with slicers integrated for analysis.

Explore how interactive dashboards empower airline and holiday agencies to monitor destinations, passenger behavior, and key performance indicators with dynamic reporting on a single dashboard sheet for informed management decisions.

Identify inputs such as travel months, type, aircraft, airline name, destination, passengers per booking, number of days, customer satisfaction, and map them to outputs: monthly performance and passenger statistics.

Format and organize a raw holiday data sheet into a professional dashboard by applying fonts, column widths, data validation, percent formatting, pivot tables, and a 3d map.

Create dynamic data dashboards by building pivot tables, adding slicers for month, aircraft type, and airline name, and visualizing data with charts and 3D maps.

Learn to use Excel 3D maps to visualize correlations between destinations and vacation types with heat maps and scatter plots. Build dashboards by capturing screenshots and refreshing monthly data.

Arrange dashboard charts by adjusting sizes and removing fills and outlines for a professional look, then add data labels, organization-specific colors, and slicers for final formatting.

Format and finalize the dashboard, plug in slicers, test it, and close the project while styling the logo and color theme for clear insights into destinations, flights, and monthly trends.

Explore the profit and loss statement, detailing revenues, expenses, depreciation, and net profit under accounting principles. Learn five reasons owners need this insight to gauge performance and decisions.

Identify inputs such as revenue streams, cost of sale, op ex, capex, depreciation and amortization, interest, and taxes to drive a pnl dashboard and compare this year to last year.

Format the revenue and cost of sale sections with green and red colors, apply dollar formatting, and build a prepayment dashboard using the etch lookup function instead of pivot tables.

Develop a dynamic Excel dashboard to analyze revenue, costs, OpEx, and net profit by linking cells to source data, applying percentage calculations, depreciation and amortization, tax, and year-over-year insights.

Use the HLOOKUP formula to energize an interactive dashboard by linking revenue data and ensuring exact matches. Format currencies and troubleshoot issues to keep charts accurate and visually engaging.

Apply conditional formatting to show growth or decline between 2019 and 2022 in the dashboard, using the simple growth formula value divided by the initial value minus one.

Create professional charts from the spree dashboard by selecting the desired area and applying the recommended chart type, and use pivot tables to finish polishing your dynamic Excel dashboard.

Format and color a data dashboard to a professional standard by cleaning data, applying green and red color codings for revenues and claims, and testing the final dashboard.

Test the dashboard by linking live figures from the workbook to PowerPoint, remove borders for clarity, and visualize revenue and OpEx trends from 2019 to 2022, including PNL differences.

Turn this skill into passive income by implementing dynamic dashboards for small to medium enterprises, and embrace practice, practice, practice to master freelancing.

Celebrate your achievement by applying five Excel dashboard projects to create dashboards for diverse users and industries, with ongoing course updates and future PowerPoint integration via formulas.