Working effectively with MS Excel - Base Level

Goals
Building basic skills for effective work with important functionalities of Microsoft Excel.

Curriculum
Chapter 1. Workspace management. Data input in cells.
Worksheet navigation. Printing worksheet or workbook. Personalization of workspace. Data input in cells. Applying autofill.

Chapter 2. Formatting cells and worksheets
Formatting cells. Merging and splitting cells. Applying cell styles. Hiding and un-hiding rows and columns. Adding and management of worksheets. Creating header rows and columns. Changing page layout. Working with different worksheet views and windows.

Chapter 3. Applying formulas and functions
Constructing formulas. Priorities in calculations. Applying cell references in formulas. Applying conditional logic in formulas. Applying name ranges and cell ranges in formulas.

Chapter 4. Visual data representation
Creating diagrams based on data from a worksheet. Inserting and working with illustrations. Creating and changing images with the image editor. Managing comments. Adding hyperlinks.

Chapter 5. Analysis and organization of data
Filtering data. Sorting data. Applying conditional formatting. Using logical functions for conditional formatting, icon range and clearing rules.