Microsoft Excel for Beginners: From Basics to Advanced Skill

Edit and overwrite a cell in Excel using three methods: direct overwrite by typing, in-cell editing with double-click or F2, and editing in the formula bar.

Learn to copy and paste in Excel with standard Ctrl+C and Ctrl+V, and explore advanced paste options, transpose data, and cross-worksheet references using equals and sheet links.

Master Excel sorting to organize data by name, salary, or age using sort options from A to Z and Z to A on data range including headers, with expand selection.

Apply Excel filters to sift large data sets, using department and text filters (begins with, ends with, contains, equals), then clear filters to view complete data.

Learn to keep headers visible while scrolling large data sets by using freeze panes in Excel. Practice freezing the top row, first column, or both.

Master the find and replace feature in Excel to locate and modify data efficiently. Use the home tab, editing tools, and Ctrl F to perform find, replace, and replace all.

Master the building blocks of Excel formulas by using the assignment operator, arithmetic and comparison operators, booleans (true/false), and the formula bar for dynamic, auto-updating results.

Understand Excel ranges, including contiguous and non-contiguous selections and named ranges, and learn colon notation for referencing A1:A10 and A1:F1 in formulas.

Create a player profile and transfer table in excel, with headers like serial number, player name, country, previous club, current club, year, and transfer fee; autofill, add ten players, format.

Practice formatting in Excel by applying header styles, borders, and currency formatting, then sort and filter by year and country, and freeze the top row for navigation.

Continue mini project 1 by renaming sheets, copying player names, and using paste options, then use find and replace to update Chelsea to Chelsea FC and apply basic formatting.

Learn to automate calculations in Excel with basic arithmetic functions: sum, addition, subtraction, multiplication, and division, using equals, function syntax, and cell references, including autofill.

Master basic and conditional summing in Excel by using the sum, sumif, and sumifs functions. The lecture demonstrates ranges, criteria, and multi-criteria scenarios with practical examples.

Discover how the count function tallies numeric data in a range and ignores text, logical values, and empty cells; compare it with count a and count if for non-empty data in Excel.

Master the countif function to count cells by range and criteria, including text, numbers, dates, and dynamic cell references, then extend to countifs for multiple conditions.

Master countifs for multiple criteria and enhanced filtering, using criteria ranges and wrapped quotes, to count retirees by department, gender, and age; the video also previews min and max functions.

Explore the min and max functions to identify the smallest and largest values in a numeric range, ignoring text, logical values, and empty cells, with salary and top performer examples.

Master the arithmetic mean with the average function across ranges, including numbers and dates, while ignoring text, logical values, and empty cells; use averageif for criteria-based averages.

Master Excel if statements to build conditional logic with threshold checks and true/false outputs. Explore retirement eligibility by checking if age is greater than or equal to 60.

Build a staff performance and payroll dataset for a small company, and compute total, bonus, and final pay using hours worked and pay per hour with if and ifs formulas.

Learn to compute department salaries with sumif, count males per department with countifs, and determine max, min, and average final pay by department, including age and hours analyses.

Master how to use countif and countifs to analyze staff data, including age, department, and hours worked, applying real-world thinking to bonuses and salary analysis.

Master data validation in Excel to control inputs and ensure data quality, using the data tab and data tools to enforce numbers, lists, dates, times, and drop-down options.

Learn to apply data validation in Excel with drop-down lists, visible borders, and dynamic date rules using today to enforce valid interview dates within a start and end range.

Learn how to implement data validation in Excel, lock cells with absolute references, validate dates and times, and use drop-down lists to enforce available interview hours.

Apply data validation in Excel to enforce time constraints, text length, matriculation numbers, and ten-digit phone formats; customize input messages and error alerts to guide users.

Use vlookup to vertically lookup and cross-reference data across workbooks, returning age, full name, or department from a leftmost key with exact match.

Explore how xlookup overcomes vlookup limits by searching any column, returning multiple values, and improving error handling, with practical examples of drop-down data validation and dynamic lookups.

Explore the trim function, a string processing tool that removes extra spaces and preserves single spaces to normalize user input before storage and improve search functionality.

Explore the left and right functions in Excel to manipulate strings by extracting characters from the start or end, enabling initials, file extensions, abbreviations, and official name formats.

Master the len function in Microsoft Excel to count characters in a text string, enabling input validation, character limits, password strength validation, and truncation.

Master the mid function to extract substrings from the middle for fixed-width data like IDs and state codes, using a starting position and length, compared to left and right trimming.

Master Excel date functions, including today, day, month, and year, to extract components from a date and work with date formats; explore the date div function in this lesson.

Learn the date diff function to calculate the difference between two dates in years, months, or days. Apply it to age from birth dates, subscription durations, and years of service.

Explore how the text function, text join, and text split format dates, extract year/month/day, and assemble or separate names with delimiters, and ignore empty cells.

Master the unique function to extract distinct values, remove duplicates, and create dropdowns for category filters, enabling clean data normalization in Excel.

Master the sort function in Microsoft Excel for data organization, applying ascending or descending order with the sort formula, sorting by row, and generating dynamic, non-destructive sorted results.

Build an Excel-based employee performance and payroll dashboard by creating a 20-member table, using text join for names, and date functions to compute age, tenure, and bonus eligibility via if.

Demonstrate vlookup to retrieve bonus amounts from the grid bonus and apply it in workbook; create text functions for month and year joined, then build a dashboard summarizing staff metrics.

Calculate total and active staff with count and countif; compute average, max, min, and sumif salaries for active staff; identify top three by years of service with xlookup dropdown.

In mini project 3 pt.4, build a dynamic staff search using a data validation drop-down and xlookup to auto display staff details across fields, with formatting.

Learn how to use Excel's median function to find the middle value in a numeric data set, alongside other statistical functions like count, average, and standard deviation, with practical examples.

Explore the mode function in Excel by identifying the most frequently occurring value in a data set, alongside reviewing mean and max/min examples with salaries and ages.

Master standard deviation in Excel by comparing population and sample calculations (stdev.p vs stdev.s) and choosing when to use each. Compare quartile inclusive and exclusive methods.

Learn how quartiles in excel reveal distribution by outlining Q1, median, Q3, min and max, and compare inclusive vs exclusive calculations with real-life examples.

Explore the ampersand operator in Excel, mastering concatenation to join text strings, numbers, and data with spaces or delimiters for full names, addresses, and labels.

Explore comparison operators in Excel, which return true or false to evaluate relations like greater than, less than, or equal, and learn locking cells with absolute references and overpaid scenarios.

Explore Excel logical operators, including and and or, and learn how they evaluate multiple conditions to return true or false. Apply criteria like age and hours worked to determine qualification.

Explore conditional functions in Excel, including IF and IFS, with exam-score examples to grade students as A, B, C, D, or F, enabling dynamic grading.

Clean and analyze the Ovitec 2025 scholarship data by calculating min, max, average, median, and mode of interview scores, counting applicants from full name column, and performing quartile analysis.

Learn to compute inclusive and exclusive quartiles, medians, and percentiles in Excel, compare distributions, and build logical columns using if, and, or to flag eligible and top choice applicants.

Explore using or and and operators to flag low performance students, validate interview dates with date diff and today function, and prepare for xlookup-based autofill of emails, scores, gender, and dates.

Build an applicant search sheet in Excel using data validation dropdowns and xlookup to retrieve email, gender, and interview dates, and create contact string by concatenating full name and phone.

Explore how to create and add Excel tables from existing data, handle headers, resize and rename tables, and apply table design, styles, and filters for structured data management.

Learn to create, rename, and copy Excel tables and specific columns with formulas that reference table names for updates, and explore table design, resizing, and filter options for payroll analysis.

Explore table slicers in Excel to visually filter data with interactive, multi-select filtering. Add, rename, resize, and style slicers for age, hours worked, department, and rating, and clear filters.

Master pivot tables in Excel to dynamically summarize large data sets, aggregate data with sum, average, and count, and explore filters and slicers to identify trends.

Explore Excel charts as data visualization tools, learn to insert and customize charts, and use axis, titles, data labels, legends, gridlines, and trend line to reveal patterns.

Explore types of charts in Excel and learn to switch chart types to reflect data, from line charts showing trends to pie and donut charts with data labels and legends.

Learn how sparklines insert mini charts in a cell to visualize trends beside data, including creating line sparklines and column charts, with dynamic updates and point markers.

Create dynamic pivot charts that update automatically with pivot tables, using slicers and timeline filters to explore data trends and country populations.

Explore conditional formatting in Excel to visually highlight trends and outliers using data bars, color scales, and icon sets, with examples on salary data and threshold rules.

Explore conditional formatting in Excel to highlight top ten and bottom ten salaries, duplicate values, senior roles, and apply data bars, color scales, and icon sets.

Explore Power Query in Excel, the ETL tool that extracts, transforms, and loads data from multiple sources, including CSV, text files, databases, and online services.

Access Power Query from the data tab, load data from Excel workbooks or CSV files, and use the Power Query Editor to transform data and manage queries.

Explore the reduce rows options in Excel's home tab, including removing top or bottom rows, blank rows, duplicates, and errors, while tracking applied steps in the query settings.

Manage columns in Excel by choosing which columns to display, such as id, full name, job title, department, salary, and country, with instant statistics like distinct departments and salary ranges.

Explore creating conditional columns in Power Query to derive first and last names, initials, and retirement status from employee data using text delimiters, length, and formatting tools.

Learn to create a conditional column and add an index column starting from zero or one, with sorting by full name and managing duplicates in Excel.

Explore the Power Query home tab fundamentals, including managing steps, renaming queries, sorting, data types, replacing nulls, and toggling first row as headers.

Explore the power query transform tab, create new columns, count characters, derive initials, trim and format data, replace values, and manage headers, before loading results back to Excel.

Explore viewing 18 columns and 806 rows in Power Query, preview top 1000 rows, and use close and load to return results to Excel.

Learn to fetch data from the web into Excel using Power Query by copying a table URL, previewing and transforming, then loading into the workbook.

Learn how to merge queries in Power Query by importing multiple data sources, matching on a common column, and performing a full outer join to consolidate data.

Master merging queries in Power Query for Excel by using left outer and full outer joins, expanding arrays, and extracting the certificate column to build merged films data.

Learn how to protect data in Excel by unlocking specific columns, locking cells, and password-protecting worksheets and workbooks, including protecting structure and hiding sheets.

Lock the workbook with a password to prevent edits, then hide and unhide worksheets to protect data, preparing for the next video on sharing your Excel projects.

Share your Excel project by backing up to OneDrive or Google Drive, generating a shareable link, and posting a portfolio on LinkedIn or GitHub to attract recruiters.

Explore how Excel add-ins extend and customize Excel, with web add-ins, COM add-ins, and Excel add-ins, unlocking tools like Solver, Power Query, Analysis Toolpak, and DAX in Power BI.

execute a complete final excel project by cleaning and formatting a student dataset, then compute key metrics such as total donations, average cgpa, employment count, and salary extremes.

Learn dynamic excel techniques to compute min and average salaries with criteria, add earned status flags, filter 2024 graduates, and build pivot tables for yearly graduations and employment status insights.

Create and customize pivot tables and charts to analyze data, including total donations per year, average CGPA by employment status, and average salary by graduation year.

Develop and refine Excel charts, including a bar chart of average salary by graduation year and a pie chart of employed versus unemployed, using pivot tables.