Microsoft excel : From beginning to pro level

Begin with the basics of Excel and progress to advanced tools to manage finance, organize data and lists, and become a certified Excel pro.

Master Excel basics by using inbuilt templates or a blank workbook, manage sheets, and import data from text with Get & Transform, while finding and replacing values.

Learn how to format data in an Excel worksheet by applying colors, copying data across columns, inserting rows and columns, and using data validation for accurate entries.

Customize your Excel worksheet by adding features to the quick access toolbar and creating a new ribbon; use freeze top row and macros to automate tasks.

Open the file menu, choose print, set copies and select the printer, specify pages, decide one‑sided or two‑sided printing, and adjust orientation, A4 paper size, and margins for worksheets.

Explore advanced Excel features like find and replace, auto fill series, and merge center, plus adding text and watermark to format sheets and speed up workflows.

Apply conditional formatting in excel to highlight cells using rules for less than 33 and greater than 90, choose colors, and remove formatting with clear rules.

Learn basic Excel formulas, including sum, min, max, count, and average, using two methods: typing = with a function and range, or using the formulas tab.

Explore how to use Excel's built-in functions—SUMIF, COUNTIF, and AVERAGEIF—to analyze sales data, setting criteria such as greater than 5000 or 4000 and filtering by year 2020.

Learn how to create charts in Excel to visually present data by selecting data, inserting a chart, applying styles, changing colors, and moving the chart to a new sheet.

Insert pictures from device, stock, or online, remove backgrounds, and apply color and artistry effects to enhance your Excel sheets with smartart for clearer data.