Core Essentials for Business Professionals – Excel 2007

This course will teach you how to make the most of this popular spreadsheet program, including how to use the all-new interface to make working with spreadsheets easier than ever.

How You Will Benefit:

• Get a firm understanding of the basics of working with Excel
• Understand how to work with data
• Become familiar with basic formatting and data analysis tools
• Get to know some of Excel’s more advanced tools, such as conditional formatting and cell styles
• Understand how to add graphics and objects to your spreadsheets
• Understand different ways of viewing and printing your data

What You Will Cover:

• Anatomy of a spreadsheet
• Using ribbons and tabs
• Inserting and deleting rows and columns
• Merging and splitting cells
• Moving and resizing cells
• Using Paste Special
• Understanding cell references and formulas
• Basic and advanced functions
• AutoFiIl and AutoComplete
• Sort and filter
• Working with fonts on the Home tab
• Adjusting cell alignment and text direction
• Changing number format
• Using the Format Painter
• Using conditional formatting
• Formatting data as a table
• Adding pictures, SmartArt, shapes, text boxes, and charts
• Creating a PivotTable

Once done, you may get a certificate certified by the Filipino Institute, an internationally accredited organization, for a fee of AED 70. To know more about the free online courses, contact Dean Oliver at onlinelearning@filipino-institute.com or send him a WhatsApp message at +971-58-2439959.