Microsoft Excel 101- Excel From Beginners to Advanced

Enter and format data in Excel with confidence by typing in cells, using enter or tab to move, and applying borders, bold headers, wrap text, and number or date formats.

Learn to perform basic calculations in Excel by building a simple table with quantity, price, and total, using a multiplication formula, autofill, and currency formatting to compute a grand total.

Master basic Excel calculations by using sum, subtraction, multiplication, and division with formulas starting with =, cell references, and range selections.

Master formatting basics in Excel by applying fonts, borders, and fill colors to organize and highlight data. Learn to select cells, use the home tab, and adjust font styles.

Adjust row height and column width in Excel using manual resize, auto fit, and precise sizing with double-click, drag, and right-click options for multiple selections.

Sort data and filter your Excel lists to analyze sales or to-do items, sorting by a single column or by category and price, and filtering for electronics or price conditions.

Master excel tables to turn a plain data range into a structured, filterable, sortable dataset with automatic formatting, structure referencing, and easy data analysis.

Learn to apply data validations in Excel to enforce numeric ranges, create drop-down lists, and display custom error messages for accurate inputs.

Learn to remove duplicates in Excel by selecting your data range with headers, converting to a table, and using the remove duplicates tool to choose columns, then save.

Master managing multiple worksheets in Excel by adding, renaming, rearranging, copying, and grouping sheets. Link data across sheets, color code tabs, and create organized summaries.

Explore the basics of formulas and functions in Excel, using cell references to create dynamic calculations with sum and average. Learn how built-in functions simplify tasks and update results automatically.

Master the sum, average, min, and max functions in Excel to quickly total values, compute the mean, find the smallest value, and identify the largest value in data.

Master if, and, or, and not to build logical tests in Excel, and learn to combine conditional formulas for sales targets and bonuses.

Master VLOOKUP, HLOOKUP, and XLOOKUP to search tables, return values across columns or rows, and use exact or approximate matches.

Master essential text functions in Excel, including concatenate, left, right, mid, len, and trim, to combine names, extract digits, count characters, and clean data for analysis.

Explore essential date and time functions in Excel, including today, now, networkdays, and datedif, to track daily logs, deadlines, and project timelines with automatic date updates and holiday awareness.

Learn to handle Excel errors with IFERROR and ISERROR, replacing or testing errors like division by zero or missing data to keep your worksheets clean and professional.

Learn to use pivot tables in Excel to summarize, analyze, and visualize data with drag-and-drop fields, filters, and styles. Create regional sales totals with rows, columns, and values.

Master pivot tables in Excel to summarize sales data by region and sales rep, using rows, columns, and values, with options to compute total, average, and date-based filters.

Create pivot charts in Excel by building pivot tables from organized data, dragging fields to rows, columns, and values, and customizing visuals for clear data analysis.

Master how to group sales data by region with pivot tables, apply filters, and slice results with slicers and timelines to analyze by date and region.

Learn how named ranges in Excel simplify formulas and improve readability by using define name and the name manager for sales data sums.

Automate repetitive tasks in Excel using macros by recording and running macros with the developer tab, format tables with borders and fonts, and explore the VBA code behind them.