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.
Course Features
- Lectures 50
- Quizzes 0
- Duration 18 hours
- Language English
- Students 4043
- Assessments Yes
-
Lesson 1: The Basics
-
Lesson 2: Working With Data
-
Lesson 3: Basic Excel Tools
-
Lesson 4: Basic Formatting Tools
-
Lesson 5: Advanced Formatting Tools
-
Lesson 6: Advanced Elements
-
Lesson 7: Viewing and Printing
-
Quick Reference Guide
-
shing25
Excel 2007- Free Course
Thank you . I learned a lot. -
hergreensapphire
Excel 2007-Free Course
Thanks A lot! so helpful for me. -
Eliza
Excel 2007 - Free Course
Big help!. I learned a lot. Thank you so much! God Bless -
mamajarucon@gmail.com
Excel 2007 - Free Course
Very Helpful