Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.

By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls.

Course Curriculum

MS Excel Basics
Excel 2010 Getting Started 00:00:00
Explore Window in Excel 2010 00:00:00
Back-End View in Excel 2010 00:00:00
Entering Values in Excel 2010 00:00:00
Move Around in Excel 2010 00:00:00
Hiding/Unhiding A Worksheet in Excel 2010 00:00:00
Save Workbook in Excel 2010 00:00:00
Create Worksheet in Excel 2010 00:00:00
Copy Worksheet in Excel 2010 00:00:00
Delete Worksheet in Excel 2010 FREE 00:00:00
Close Workbook in Excel 2010 FREE 00:00:00
Open Workbook in Excel 2010 FREE 00:00:00
Context Help in Excel 2010 FREE 00:00:00
Formatting Cells
Sheet Options in Excel 2010 00:00:00
Setting Fonts in Excel 2010 00:00:00
Text Decoration in Excel 2010 00:00:00
Rotate Cells in Excel 2010 00:00:00
Setting Colors in Excel 2010 00:00:00
Text Alignments in Excel 2010 00:00:00
Merge & Wrap in Excel 2010 00:00:00
Borders and Shades in Excel 2010 00:00:00
Apply Formatting in Excel 2010 00:00:00
Editing Worksheet
Insert Data in Excel 2010 00:00:00
Select Data in Excel 2010 00:00:00
Delete Data in Excel 2010 00:00:00
Move Data in Excel 2010 00:00:00
Rows & Columns in Excel 2010 FREE 00:00:00
Copy & Paste in Excel 2010 00:00:00
Find & Replace in Excel 2010 00:00:00
Spell Check in Excel 2010 00:00:00
Zoom In/Out in Excel 2010 00:00:00
Special Symbols in Excel 2010 00:00:00
Insert Comments in Excel 2010 00:00:00
Add Text Box in Excel 2010 00:00:00
Undo Changes in Excel 2010 00:00:00
Formatting Worksheets
Setting Cell Type in Excel 2010 00:00:00
Adjust Margins in Excel 2010 00:00:00
Page Orientation in Excel 2010 00:00:00
Header and Footer in Excel 2010 00:00:00
Insert Page Break in Excel 2010 00:00:00
Set Background in Excel 2010 00:00:00
Freeze Panes in Excel 2010 00:00:00
Conditional Format in Excel 2010 00:00:00
Working with Formula
Creating Formulas in Excel 2010 00:00:00
Copying Formulas in Excel 2010 00:00:00
Formula Reference in Excel 2010 00:00:00
Using Functions in Excel 2010 00:00:00
Built-in Functions in Excel 2010 00:00:00
Advanced Operations
Data Filtering in Excel 2010 00:00:00
Data Sorting in Excel 2010 00:00:00
Using Ranges in Excel 2010 00:00:00
Data Validation in Excel 2010 00:00:00
Using Styles in Excel 2010 00:00:00
Using Themes in Excel 2010 00:00:00
Using Templates in Excel 2010 00:00:00
Using Macros in Excel 2010 00:00:00
Adding Graphics in Excel 00:00:00
Cross Referencing in Excel 2010 00:00:00
Printing Worksheets in Excel 2010 00:00:00
Email Workbooks MS Excel 2010 00:00:00
Translate Worksheet in Excel 2010 00:00:00
Workbook Security in Excel 2010 00:00:00
Data Tables in Excel 2010 00:00:00
Pivot Tables in Excel 2010 00:00:00
Simple Charts in Excel 2010 00:00:00
Pivot Charts Excel 2010 00:00:00
Keyboard Shortcuts in Excel 2010 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • FREE
  • UNLIMITED ACCESS
6 STAFF ENROLLED
  • Profile photo of FAYOMAGBEMI
  • Profile photo of Admin
  • Profile photo of SFOJO
  • Profile photo of SADEKWU
  • Profile photo of TIFEGBESAN
  • Profile photo of ECAREW
top
Nigerian Ports Authority © 2017. All rights reserved. credit: ARTA
X