Microsoft Excel Course - Basic to Advanced Level

Learn to use what-if analysis and goal seek in Excel to reach a target profit by adjusting sales or cost, with setting goals and changing cells.

Activate the solver add-in in Excel, use the analysis group to set an objective, add constraints, and adjust multiple cells to reach a target loan condition with emi calculations.

Explore how to use the what-if analysis scenario manager in Excel to compare high cost, low cost, and average cost across scenarios, view summaries, and manage changing cells.

Learn to build a loan table in Excel using data tables and what-if analysis, calculate EMI, total interest, and customize inputs and headings for dynamic loan scenarios.

Learn how the updated pduration function determines the years needed to reach a goal from investment, rate, and goal amount, with compounding interest examples.

Learn how to use the mid function in Excel to extract text by specifying a starting position and length, with practical examples like phone numbers and city names.

Master the Excel text function by using the mid function with find and left to extract a city name from text, identifying the starting position and the character length.

Explore the text function and concatenate function in Excel to join text, such as adding initial digits before a phone number.

Explore the text functions in Excel, focusing on concatenate, left, and related techniques to assemble and format data such as phone numbers and fixed-length segments.

Explore the text function in Excel, focusing on the replace function, including find and replace, replace all, and how to replace text within a cell or selected text.

Learn how the substitute function in Excel replaces specific text occurrences in a string, using instance numbers to target the first, second, or nth occurrence.

Explore the updated numbervalue function that converts text numbers into numeric values, handles numbers stored as text with apostrophes, and enables calculations such as sum and average in Excel.

Learn how to split a single Excel column into multiple columns using text to columns, with delimited and fixed width options, delimiters, and date format considerations.

Define names for ranges or cells in Excel and set scope to workbook or a sheet. Use these names in formulas and navigation, and manage them with the name manager.

Learn to group and ungroup data in Excel, build multi-level subgroups, and apply subtotals by city or region. Collapse, expand, and remove groups with sorting to keep data organized.

Learn how to protect an Excel workbook by protecting its structure with a password, preventing changes such as adding, deleting, renaming, or hiding sheets.

Protect an Excel worksheet with a password and set user permissions for selecting, formatting, and editing specific ranges.

Protect an Excel sheet with a password, hide formulas and the formula bar, and unlock specific cells to allow selection while the sheet remains protected.

Learn how to share an Excel workbook and enable multi-user editing by using privacy options to remove personal information and enabling the share workbook feature.

Learn advanced Excel concepts with max and min functions, lock cell ranges with absolute references to prevent dragging shifts, and apply function key steps to ensure stable results.

Learn how to build Excel formulas using and, or, and nested if statements, combining text with concatenate, handling true/false outcomes, and creating compact, condition-based results.

Explore the exclusive or (xor) function in Excel and how it differs from the or function, using score thresholds to decide retests.

Master pivot tables in Excel by organizing data with the field area, dragging fields to rows and columns, applying filters, and summarizing transactions and totals.

Explore pivot tables by configuring value fields, generating region-based reports, viewing transaction counts and total amounts, and refreshing to reflect new data changes.

Learn to use pivot tables to group date and value in Excel, enabling month, quarter, and year views and quick sums across the data.

Explore how to insert a calculated field in a pivot table to compute the percentage difference between numbers, including naming the field and displaying results.