Introduction to Microsoft Excel
|
Formatting Data in Excel – Basics
|
|
|
In this tutorial,
- What is Excel ?
- Why is it used ?
- Creating your first excel file
- Using Ribbon, Understanding what each tab does
Watch now |
|
In this tutorial,
- Using fonts
- Using colors
- Applying Cell Borders
- Aligning Text, wrapping text
- more…
Watch now |
How to Make a Chart in Excel?
|
Writing Simple Formulas in Excel
|
|
|
In this tutorial,
- What is a Chart?
- Creating a simple chart
- Formatting a chart
- Changing chart types
Watch now |
|
In this tutorial,
- What is a formula
- Writing simple SUM formulas
- IF and Else formula
- Count of values
- Sum of values meeting a criteria
Watch now |
Introduction Conditional Formatting in Excel
|
Introduction to Excel Tables
|
|
|
In this tutorial,
- What is Conditional Formatting?
- Applying simple conditional formatting rules
- Using predefined CF rules
- Using Formulas in CF
Watch now |
|
In this tutorial,
- What is a table
- Why use tables
- Applying table styles
- Sorting, filtering data in tables
- Charts and tables
- Formulas and tables
Watch now |
Introduction to Excel Pivot Tables
|
Using Excel Productively – Keyboard Shortcuts
|
|
|
In this tutorial,
- What is a pivot table?
- How to create a pivot table?
- Working with pivots – changing orientation, adding filters
- Formatting pivots
Watch now |
|
In this tutorial,
- Navigation Shortcuts
- Selection Shortcuts
- Using Function keys
- Using ALT keys for menus
- Using CTRL keys
Watch now |
Printing Your Workbooks
|
10 Things you can do in Excel under 10 Minutes
|
|
|
In this tutorial,
- Using Page Setup
- Setting Margins
- Print on one sheet
- Repeating Rows on Top
- Adding Headers / Footers
Watch now |
|
In this tutorial,
- Auto sum a bunch of values
- Save excel file as PDF
- Insert an organization chart
- Insert Euro Symbol or other symbols
- more…
Watch now |
