Introduction to MS Excel 2013
  • Lesson Files (Download these first)
  • What is Microsoft Excel?
Navigation and Basic Tasks in Excel
  • Excel File Formats and Extensions
  • Excel Navigation Tabs
  • Excel Contextual Tabs
  • The Developer Tab
  • The Quick Access Toolbar - Overview and Configuration
Workbook
  • Creating a new Workbook
  • Saving a Workbook
  • Opening an existing Workbook
  • Navigating a Workbook
  • Navigating a Workbook with your Keyboard
  • Navigating a Workbook with your Mouse
  • Navigating a Workbook with the Scroll Bar
Arranging and Formatting Worksheets
  • Adding and Deleting Worksheets
  • Renaming and Formatting Worksheet Tabs
  • Rearranging Worksheets and moving between Workbooks
  • Copying Worksheets
  • Hiding- and Unhiding Worksheets
  • Viewing Multiple Worksheets on one Screen
Designing and Formatting Cells, Sheets and Workbooks
  • Change the column width and row height
  • Adjusting the Fonttype of a cell, column or row
  • Adjusting the Default Fonttype
  • Adjusting the Fontsize of a cell, column or row
  • Adjusting the Fontcolour of a cell, column or row
  • Adjusting the Cell Contents Alignment
  • Adjusting the Cell Contents Indentation
  • Adjusting the Cell Contents Orientation
  • Adjusting the Number Format
  • Creating a Custom Number Format
  • Creating Borders around cells, columns and rows
  • Line break
  • Merging Cells
Data Entry in Excel
  • Entering Texts and Numbers
Formulas and Basic Calculations
  • Basic Calculations: Addition
  • Basic Calculations: Subtraction
  • Basic Calculations: Multiplication
  • Basic Calculations: Division
  • Order of Calculation
Creating Charts in Excel
  • Introduction to Charts
  • How to create a Bar Chart with one Click
  • How to create a Pie Chart with one Click
  • How to create a Line Chart with one Click
Basic Functions
  • Entering Data with AutoFill: Month series
  • Entering Data with AutoFill: Creating your Custom AutoFill List
  • The SUM Function
  • The AutoSum Function
  • The SUMIF Function
  • The AVERAGE Function
  • The MAX Function
  • The Min Function
Date and Time Functions
  • The DATE Function - Combining Values into a Date Expression
  • The TODAY Function - Giving out the current Date
  • The DATEDIF Function - Calculating Time Intervals
  • The NOW Function - Giving out the current Date / Time Combination
  • The HOUR, DAY etc. Functions - Extracting Elements from Date and Time
  • The WEEKDAY Function - Accessing the Weekday as String
  • The NETWORKDAYS Function - Calculating Salaries
Data and Text Functions
  • The CONCATENATE Function - Building Text Strings from Cell Values
  • The DOLLAR Function - Converting Numbers to Currency Strings
  • The EXACT Function - Comparing Text Strings
  • The LEFT(); MID(); RIGHT() Function - Extracting Text Parts
  • THE LOWER UPPER Function - Converting to Uppercase and Lowercase Letters
  • THE PROPER Function - Converting First Letter to Uppercase
Conditional Formatting
  • What is Conditional Formatting?
  • Own Value Conditional Formatting
  • Between Own Value Conditional Formating
  • Equal to Own Value Conditional Formatting
  • Text that contains Own Value Conditional Formatting
  • Date occuring Own Value Conditional Formatting
  • Duplicate Own Value Conditional Formatting
  • TopBottom 10 - Relative Conditional Formatting
  • TopBottom 10percent - Relative Conditional Formatting
  • Average - Relative Conditional Formatting
  • Trend - Relative Conditional Formatting
  • Custom Conditional Formatting Rules
  • Formula Conditional Formatting Rules
  • Conditional Formatting Rules Manager