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
After taking this course, you may get a certificate certified by the Filipino Institute, an internationally-accredited organization, for a fee of AED50. The same certificate may also be attested by the Knowledge and Human Development Authority (KHDA) and the Ministry of Foreign Affairs (MOFA).
To know more about this program, email onlinelearning@filipino-institute.com or contact +971 54 577 2940.
Course Features
- Lectures 50
- Quizzes 0
- Duration 18 hours
- Language English
- Students 2879
- 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
-
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