Microsoft Excel
Basic Tasks in Excel 2013 - Part 1
|
Basic Tasks in Excel 2013 - Part 2
|
Copy, Cut, Paste (paste without formatting)
|
Basic Formatting Part 1
|
Basic Formatting Part 2
|
Number Formatting
|
Auto Fill
(linear and growth) |
Personalizing the Environment Using the Backstage
|
Force Printing on One Page and Navigating the Worksheet
|
How to Hide and Unhide Columns
|
Named Ranges
|
Format as Table
|
Sparklines
|
Freeze Panes
(freeze one or more columns) |
Conditional Formatting
(data bars,color scales,icon sets) |
Basic Graph
|
Copy, Cut, Paste (paste without formatting)
|
Comments and Hyperlinks
|
Mail Merge (Ticket Numbers)
|
Basic Excel Word Mail Merge
|
Text to Columns
|
Format as Table
|
Protecting Cells and Worksheets
|
How to add Password Protection
|
ScreenShots and Sreen Clipping
|
Image Editor
|
Clip Art, SmartArt, and Shapes
|
Cell Styles
|
Quick Analysis (New Feature)
multiple graphs on one chart
|
Excel Go To Feature
|
Formulas in Excel
Order of Evaluation (Precedence)
|
Introduction to Formulas
(and Inserting and Deleting Rows and Columns) |
Practice with Basic Formulas
(and format currency) |
Referencing Worksheets in Formulas
(and change Tab Color) |
COUNTIF Formula
|
Pivot Tables
|
Absolute vs Relative Cell Referencing
|
VLOOKUP formula (with AutoFill)
|
COUNTA Formula
|
SUMIF function
|
AVERAGEIF Function
|
Excel Concatenate Tutorial
|
LEFT RIGHT MID FIND Tutorial
|
SUMIF SUMIFS COUNTIF COUNTIFS
|
Excel HLOOKUP Tutorial
|
ContactTelephone:
+974 4450 2172 School Mobile +974 5536 9675 |
|