Microsoft Excel Fundamentals

• open Microsoft Excel and navigate its environment;
• work with a workbook, its worksheets, and data;
• save the workbook and open the workbook you created earlier;
• work with data areas of a worksheet;
• design worksheet data and cells;
• perform actions on columns and rows on a worksheet;
• perform actions on worksheets;
• perform calculations using functions and formulas;
• display data using charts and sparklines;
• change worksheet settings;
• prepare the worksheet for printing and print it.

Microsoft Excel environment:

• Excel user interface;
• Using the backstage view;
• Using ribbon and tabs;
• Using the formula bar;
• Worksheet elements;
• Move in a worksheet;
• Using the status bar;
• Using the quick access toolbar;
• Program suggestions and help (tell me what you want to do).

Work with a workbook:

• Open and create workbook;
• Save workbook;
• Work with view windows of one and more workbooks;
• Move between workbooks (switch windows);
• End of work in Excel.

Actions on workbook worksheets:

• Add a new worksheet;
• Move from one worksheet to another;
• Change the worksheet name;
• Move, copy, and delete a worksheet;
• Hide and unhide sheet a worksheet;
• Highlight multiple worksheets;
• Color the tab color of worksheet tabs;
• Using the right-click mouse menu.

Work with worksheet data and data areas:

• Entering information into cells;
• Editing and deleting information;
• Auto cell fill;
• Select Cell Area;
• Enter data in a highlighted data area;
• Using the Quick Analysis tool;
• Copying, cutting and pasting of the cell area and objects;
• Move data area;
• Work with sort lists;
• Creating data series.

Design worksheet data:

• Cell data design – style, size, color, size;
• Copy and assign cell formatting to another cell;
• Align cell data;
• Merge cells;
• Resizing columns, rows, and cells on a worksheet;
• Change the visual design of the cell;
• Format as a table in a cell area;
• Design data by using number format.

Working with cells, rows and columns:

• Insert and delete cells, rows, columns;
• Move rows, columns;
• Freeze and unfreeze rows and columns;
• Hide rows and columns and unhide.

Making calculations:

• Performing calculations using formulas;
• Copy formulas to other cells;
• Using cell addressing to create functions;
• Inserting and creating functions, specifying function arguments;
• Using the Function Round function to round numbers;
• Using the Count function to determine the number of cells;
• Create a logical function IF and specify arguments.

8. Graphical data display:

• Charting and formatting;
• Sparklines.

9. Change worksheet settings and print a worksheet:

• Change the margins, orientation, size, and scaling of a worksheet;
• Set print area;
• Insert page break;
• Header and footer (header and footer);
• Print a worksheet.

Additional options:

• Using a quick analysis tool;
• Find and replace;
• Use the Excel Help window (help);
• Change the basic program options and default save location;
• Compatibility mode.