CATEGORY TYPE: Information Technology

COURSE NAME:Excel 2010


UPCOMING EVENTS


START DATE END DATE CITY/COUNTRY PRICE Request
This course can be scheduled at your convenience, to request this course please click here
INTRODUCTION:

 

Excel 2010 is a spreadsheet application in the Microsoft 2010 Office suite that lets you store, manipulate, and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of sparklines and slicers.

OBJECTIVES:

 

 What you will learn

  • In particular you will be able to:
  • Create, save, close, open and print spreadsheets
  • Insert and delete rows or columns in your spreadsheet
  • Get Excel to automatically add up numbers
  • Copy formulae in your spreadsheet whilst keeping one of the cell references constant
  • Alter the look of the numbers and text, to make parts of the spreadsheet stand out
    • Visually represent numbers and text (as a chart) in your spreadsheet, to make them stand out and easy to understand
OUTLINE:

Chapter 1: Office Workspace Basics

Basic Window Elements 
Exploring Microsoft Office Backstage 
Working with the Ribbon 
Customizing the Quick Access Toolbar 
Working with KeyTips 
Using the Status Bar 
Getting Help 

Chapter 2: Introduction to Excel
What is Excel? 
Getting to Know the Excel Window 
Moving the Cell Selector 
Opening a Workbook 
Navigating a Workbook 
Selecting Cells 
Creating Workbooks 
Saving a Workbook 
Closing a Workbook 

Chapter 3: Entering and Editing Data 
Entering Text, Numbers, and Data 
Editing Data 
Using AutoComplete and AutoFill 
Copying Data 
Moving and Clearing Data 
Using Undo and Redo 
Finding and Replacing Data 

Chapter 4: Introduction to Formulas and Functions 
What are Formulas and Functions? 
Entering Formulas 
Entering Functions 
Using the Insert Function Tool 
Using AutoSum 
Copying and Moving Formulas 

Chapter 5: Working with Functions 
Using Statistical Functions 
Using Financial Functions 
Testing Conditions with IF 
Using Date and Time Functions 
Using Linked Values in Formulas 
Copying Formula Values 
Controlling Automatic Calculations 

Chapter 6: Formatting Data 
Introduction to Formatting 
Applying Number Formats 
Applying Font Formats 
Changing Cell Alignment 
Applying Cell Styles 
Copying Formats 
Clearing Formats 
Finding and Replacing Formats 

Chapter 7: Formatting Worksheets 
Inserting and Deleting Rows and Columns 
Inserting and Deleting Cells 
Adjusting Column and Row Sizes 
Hiding Worksheet Components 
Inserting and Deleting Worksheets 
Copying and Moving Worksheets 
Customizing Sheet Tabs 
Adding a Worksheet Background 

Chapter 8: Adding Charts and Graphics 
Creating a Chart 
Enhancing a Chart 
Modifying Chart Data 
Changing Chart Types 
Drawing Shapes 
Inserting Pictures 
Creating SmartArt 

Chapter 9: Viewing and Printing Workbooks 
Changing View Options 
Splitting and Freezing a Worksheet 
Sorting and Filtering Data Info about Slicers 
Customizing the Page Layout 
Adding Headers and Footers 
Modifying Page Breaks 
Previewing and Printing the Worksheet 
Printing Selected Data 

Chapter 10: Managing Workbooks 
Arranging Multiple Workbooks 
Adding Hyperlinks 
Working with Comments 
Saving Workbooks in Different Formats 
Saving a Workbook as a Web Pages
Creating Folders 
E-Mailing a Workbook 

WHO SHOULD ATTEND:
  • Anyone who has never used Microsoft Excel before (or any other spreadsheet package) or has some experience but is unfamiliar with using the software to perform calculations and create charts.
DURATION:
    • 3 Day(s)
  •  


    The presentation is generally appealing to me. The dedication & devotion of the instructor are both laudable & admirable.
    Mohammed F. Alotaibi
    Sabic

    Really this course is important for any inspector, so I will recommended it for our employees. And thanks a lot!
    Ahmed Al-Yami
    Sabic

    You are doing excellent bringing such very talented instructor. Please keep it up.
    Ahmed Afifi
    Al-Zamil CoolCare

    I would like to appreciate you as well as the instructor for a good training due to the fact that the helping to gain new information about the types of valve with advantages and disadvantage as well. Many thinking.
    Zaki Ali Aldawood
    Sabic

    This course was very beneficial and helpful to understand one of the Major NDT method. I encourage ITC to continue with this performance.
    Talal Saad AlHasawi
    Sabic

    ITC service was in overall excellent. Thanks.
    Wael M. Morsy
    Mobily

    This course was good and a nice guide to the PMP exam. Thanks.
    Yazeed Mohamed Mreki
    General Authority of Civil Aviation (GACA)

    It was good course & good preparation with excellent instructor. Thanks a lot.
    Faisal Mahdi Al-Qahtani
    Sabic

    It was a nice course to have. I suggest taking this course with the same instructor to other people. Thanks for the instructor for his kindness & helfull during the course.
    Abdul-Moniem Al-Humoud
    Sabic

    It is very important course, which enable us to improve our knowledge to work approaching our big account and can be recall us the key account. This is will support us to active result for the best of the Co.
    Mohammed Amjad
    Al-Suwadi Services

    The instructor is highly and technical knowledgeable in explaining all the subject in the course taken.
    Noel V. Garan
    Coldstorec Group Of Saudi Arabia

    Instructor was well prepared and knowledgeable I gain lot of useful information.
    Gulam Khan
    Saudi Aramco

    It was a good learning experience. Got to know the concept involved in key account.
    Muthuraman Nachiappan
    Al-Suwadi Services

    The instructor Mr. Ahmed Sabry has a very nice spirit.
    Salam Fakhoury
    Al Khodari Company

    It is very useful to us and increase our knowledge.
    Mohammed Rashed Afifi
    Al Khodari Company

    The course is excellent and helpful. It help me in organizing the work in more safe manner.
    Muzammil Hayat
    Al Khodari Company

    The instructor is very knowledge and hard working, his way of teaching is very good.
    Ibrahim Darwish
    Al Khodari Company