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
- Skill level All levels
- Language English
- Students 4489
- Assessments Yes