Microsoft Excel - Excel from Beginner to Advanced Level.

Launch Microsoft Excel by clicking the backstop icon or searching for it, open a blank workbook, and explore the home, new, and open options to begin editing.

Learn the Excel interface by launching Excel, opening a blank workbook, and exploring the workbook workspace, ribbons, and basic tools for formulas, data analysis, and formatting.

Learn to save an Excel workbook using ctrl+s or the save button, choose a file name and location, and create duplicates with save as.

Learn how to save Excel workbooks in different file formats, including legacy 97-2003 and CSV, using Ctrl+S or the Save As menu.

Learn to open an existing Excel document by locating your saved file and using double-click or right-click to open, reinforcing how to access previously worked files.

Discover how to add, modify, and delete data in cells, copy and move data with drag, format borders, apply font and fill colors, and adjust size for print-ready Excel worksheets.

Create and name a new worksheet in Excel, add more sheets with the plus button, and rename via clicking, double-clicking, or right-clicking.

Master common Excel shortcut keys for formatting, navigation, and column and row operations, and practice Ctrl shortcuts like Ctrl+A, Ctrl+B, Ctrl+C, and Ctrl+V to improve workflow.

Learn how to use Excel formulas to add, subtract, multiply, and divide data, apply sum and other formulas, and fill results by dragging.

Master copy, cut, and paste in Excel by using keyboard shortcuts Ctrl+C, Ctrl+X, and Ctrl+V to efficiently move data between cells.

Learn how to move and copy data between Excel files, including selecting and dragging data, using copy and cut options, and pasting into a master file to merge data.

Learn how to insert columns and rows in Excel by placing the cursor and using the insert command, expanding your data with fields like country and contact number.

Learn how to delete an Excel worksheet by right-clicking and choosing delete, then confirm the permanent deletion. The lesson also shows how to drag sheets to rearrange them.

Learn the easy method to create charts in Excel by selecting data, inserting a chart, choosing from recommended options, and customizing colors to fit your needs.

Create bar and column charts in Excel 2019 by selecting data, inserting a chart, and using months and sales records to analyze sales performance.

Learn how to format charts in Excel by editing chart data, adjusting the chart area, and formatting the axis with fill and transparency effects to customize visuals.

Select the data, insert a line chart, and choose line with markers to visualize trends. Customize the chart design to analyze data such as quantity and selling quantity.

Learn to create area charts in Excel by selecting data and inserting an area chart to visualize changes over time or categories, highlighting magnitude and total values.

Learn to create a pie and doughnut chart in Excel to visualize proportions summing to 100 percent, by selecting data and inserting the chart.

Learn to create scatter or bubble charts in Excel by selecting data, inserting the chart, and comparing two sets or pairs of data, with editable names and colors.

Use Excel's print preview to verify how your worksheet will print, then adjust margins and apply borders so the data prints neatly.

Explore page layout view in Excel, adjusting margins (normal, wide, narrow), orientation (portrait or landscape), and paper size, then use print preview to ensure accurate printing.

Learn to print a specific range in Excel by selecting data, applying borders, choosing print selection, and configuring landscape orientation, paper size, and margins for a clean print.

Learn to create pivot tables from raw data to compute total sales and grand totals by category, product, and state.

Master pivot tables in Excel to compute total sales nationwide by foreign and Indian regions and apply average calculations for regional insights.

Identify and fix common Excel mistakes such as missing column names and blank rows, learn to create and manage pivot tables, and apply data edits with thousand separator.

Convert raw data into tabular format to enable auto refresh of results when adding or updating data in Excel.

Convert all data at once to no format by right-clicking the data, selecting number format, and choosing no format, ideal for large datasets.

Learn to build a pivot table by placing product category in rows and sales in columns, then apply nation and state filters to extract Indian or foreign data.

Remove grand totals from column and row totals in a pivot table. Right-click the grand totals and uncheck grand totals in pivot table options, then click okay.

Extract reporting details into a separate table using a pivot table to view bike sales by state, such as Chattisgarh, and summarize total sales.

Learn how to display null rows in Excel by adjusting table filters and field settings. Show items with no data by configuring layout and format options to display zero values.

Learn how to extract the top 10 products by sales and sort data from smallest to largest or largest to smallest using value filters and top 10 options in Excel.

Explore pivot table subtotals and report layouts in Excel, including how to turn subtotals on or off, switch between outline and tabular forms, and repeat all item levels.

Explore how to work with dates in Excel by grouping and ungrouping data, toggle between monthly and yearly views, and design grand totals for multi-column tables.

Master pivot tables in Excel by inserting from an existing workbook and selecting a location. View results with averages and product counts, and explore recommended pivot tables and field settings.

Convert the data to a table and insert a pivot table. Create a slicer with horizontal orientation to display percentage of grand total by product type.