Ultimate Microsoft Excel Course - Beginner to Expert in 5h

Explore excel file formats and extensions, comparing the old xls with the new xlsx introduced in 2007, and note cross-version compatibility.

Explore Excel navigation tabs from file handling and OneDrive access to home, insert, page layout, formula, data, review, and view tools, enabling efficient formatting, analysis, and collaboration.

Customize the quick access toolbar in excel to access commands with one click, add or rearrange items such as undo, redo, and color fill, and save your configuration.

Learn to navigate a workbook in Excel 2013 using arrow keys, scroll bars, and the mouse; move between cells by double-clicking, pressing enter, or tab.

Navigate Excel 2013 workbooks with mouse, activate cells with a left click, double-click to edit, input data, move with the scroll wheel, and right-click for cut, copy, insert, and delete.

copy worksheets within a workbook to duplicate sheets for experiments without altering the original data, by dragging the tab to a new location or using move or copy.

Hide and unhide worksheets to reduce workbook clutter while keeping data accessible for references, showing how monthly data can be hidden while the quarterly overview aggregates the monthly data.

Learn how to adjust column widths and row heights in Excel to improve readability, using drag, exact values, auto fit, and format options to prevent truncation.

Adjusting the font in a workbook enhances readability by selecting the desired font from the font dropdown on the Home tab, previewing options, and applying changes to rows or columns.

Set the default font type and size for new workbooks in Excel by opening File > Options > General, choosing the font from the dropdown, and restarting Excel.

Select the target cells, open the font size menu from the home tab, and choose or enter a new size with live preview and optional increase or decrease adjustments.

Enter data by activating a cell, confirm with enter or the check mark, delete if needed, and edit by double-clicking, while noting text versus number alignment.

Learn to perform basic calculations in Excel using formulas to add cells together, using equal signs and cell references like A1 and B2, with real-time recalculation.

Master basic subtraction in Excel by building formulas with the equal sign, referencing cells such as A1 and A2, and validating results in the subtraction workbook.

Learn to multiply with Excel formulas using the equal sign and cell references like A1 and A2, with automatic recalculation when data changes and order doesn't matter.

Create a two-series line chart in Excel showing distances from Paris and Mumbai to major cities using a simple data selection and the insert line chart option.

Learn how to create and use a custom AutoFill list in Excel by entering names, importing the list, and using the fill handle to auto populate a column.

Learn how to use the sum function in Excel to total weekly values across a range, including nonconsecutive cells and combining multiple ranges or individual cells.

Learn how to use Excel's AutoSum feature to quickly sum ranges with automatic pre-selection, validate results, and extend sums across weekdays with auto fill.

Explain how the sumif function adds values in a range that meet a criteria. Specify the range, the criteria, and the optional sum range, using a sales example.

Use the average function to compute the arithmetic mean across a range, ignoring text, logical values, and empty cells, while easily copying the formula across weekdays with the drag method.

Master the min function, the opposite of max, to find the smallest value in a data range and compute weekly division sales using the same dataset.

learn how the date function returns a serial number for a date formed from year, month, and day, while Excel's 1900/1904 date systems handle overflow and cross-month adjustments.

Learn how the datedif function calculates time intervals between start and end dates using unit types such as years, months, and days, with three required arguments and practical Excel examples.

Learn to use the now function to return the current date and time, format it as date/time, and add days or hours with simple arithmetic, noting recalculation with F9.