Microsoft Excel from Basic to Advanced

this lesson introduces the course and its objectives.

learn about the conventions and information relevant to using excel.

explore how to open, save, and manage excel files.

understand the ribbon menu and quick access toolbar in excel.

discover the options for changing the user interface theme background.

learn the basics of inputting data into excel.

understand different data types used in excel.

get familiar with using contextual menus in excel.

learn about the structure of data in excel.

navigate through excel using various techniques.

discover how to edit data and use the AutoFill feature.

create custom AutoFill options in excel.

understand how to undo, redo, save, and save as in excel.

learn the basics of creating formulas in excel.

introduce the SUM and AVERAGE functions in excel.

explore how to use the XLOOKUP function in excel.

understand the cut, copy, and paste functions in excel.

learn about cell reference ranges in excel.

understand the difference between relative and absolute references.

explore mixed references and the ROUND function in excel.

learn how to reference external worksheets in excel.

discover how to reference external workbooks in excel.

understand how to use named references in excel.

learn the basics of formatting in excel.

explore number formatting and the use of the Format Painter.

learn how to apply custom formatting to your data in excel.

discover the basics of formatting dates in excel.

explore advanced techniques for formatting dates in excel.

understand how to format text effectively in excel.

learn how to change text color in your excel worksheets.

apply fill colors to enhance the appearance of your data.

configure border line settings for a polished look in excel.

explore different border styles and colors in excel.

manage column and row sizes to improve data presentation.

learn how to adjust text position and orientation in cells.

organize your table structure for better data management.

learn how to hide columns and rows in your tables.

understand the process of merging and splitting cells.

learn how to insert images into your excel worksheets.

understand the difference between inserting and linking images.

explore transformation and snapping techniques for images in excel.

manage visual objects effectively within your excel files.

learn how to crop and adjust transparency of images.

understand the basics of working with shape objects in excel.

learn how to lock drawing modifiers and align shapes.

edit shapes to customize your graphics in excel.

create and format text boxes for better visual presentation.

explore effects and styles to enhance your charts and graphics.

learn how to group objects for easier management in excel.

learn how to use SmartArt graphics in Excel to visually represent information.

understand different paste types in Excel for efficient data handling.

learn how to add and manage notes and comments within Excel.

use the find feature in Excel to locate specific data quickly.

utilize the replace function in Excel to substitute data easily.

sort data in Excel to organize it according to your preferences.

apply filters in Excel to focus on specific data sets.

learn how to freeze panes in Excel for better data viewing.