Microsoft Excel MODULES

Price: CHF 130 per module (2 hours session)

Module 1: Excel Essentials Introduction to the Excel interface Navigating and selecting cells Keyboard Shortcuts Entering and editing data Deleting and canceling data Performing simple calculations Saving your workbook

Module 2: Introduction to Formulas/Functions Spreadsheet structure and design Creating basic formulas Creating basic functions Copying a formula with AutoFill Recognizing the differences b/w Relative and Absolute references

Module 3: Moving/Copying Data, Autofill, & Formatting Inserting rows and columns Move and copy data Using the AutoFill feature to complete a series of values Formatting spreadsheet data Apply autoformat

Module 4: Spreadsheet Design, Page Setup & Printing Using and creating templates Worksheets - insert, delete, rename, move, copy, & group Freezing and splitting panes Spell checking your data Setting print options through Page Setup Printing your worksheets

Module 5: Database/List Tools Overview of list design Single and Multi-level sorting Setting custom sort options Filtering data in a list using custom and multiple condition criteria Using the advanced filter for unlimited condition criteria Inserting automatic subtotals in a list

Module 6: Charting Data with Graphs Creating charts in Excel Modifying and formatting chart types and chart elements Adding or deleting data from a chart Creating custom chart templates Printing a chart

Module 7: Import Data & Pivot Tables Importing data Creating a database query Create and modify pivot tables Creating pivot charts

Module 8: Protecting Data, Customizing Excel and Linking Linking data Applying Data Validation Protecting cells, worksheets, and workbooks Using conditional formatting Inserting comments Creating custom views & customizing Excel

Apply for MS Excel Module course>>