Get certified! Levels 1-5 for Microsoft Excel 2007, Excel 2010, Excel 2013 and Excel 2016. Covers 77-727 and 77-420.
Instructed by Phillip Burton 12 hours on-demand video, 18 articles & 33 downloadable resources
After completing the course, you will…
-
Create, configure and save Excel worksheets and workbooks.
-
Navigate through and format worksheets and workbooks.
-
Customise options and views for worksheets and workbooks.
-
Configure Excel worksheets and workbooks to print (e.g. page setup).
-
Insert data into and format cells and ranges, and create and modify tables.
-
Highlight, filter, sort and group cells, ranges and tables.
-
Create and format Excel charts.
-
Insert and format objects, including modifying images.
-
Create formulas in Excel, including using conditional logic and modifying text.
Learn how to:
Create and manage worksheets and workbooks
- Create and navigate in Excel worksheets and workbooks,
- Format worksheets and workbooks,
- Customize options and views, and
- Configure Excel worksheets and workbooks for distribution.
Manage data cells and ranges
- Insert data into and format cells and ranges, and
- Summarise and organize data in Excel .
Create tables
- Create and manage tables,
- Manage table styles and options, and
- Filter and sort a table.
Perform operations with Excel formulas and functions
- Summarize data,
- Perform conditional operations, and
- Format and modify text.
- Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.
Create charts and objects
- Create charts,
- Format graphic elements, and
- Insert and format objects in Excel
Who this course is for:
- This course is for you if you want to develop your Microsoft Excel skills.
- This course will use the latest version of Excel, but is ideal for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 365.
- This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
- This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
- You will cover the content tested in Microsoft Office Specialist Exams 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core)
- This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.
Similar Udemy Course Coupons
- Microsoft Excel – Excel Only For Beginners
- Microsoft Excel Training: From Zero to Hero in 8 Hours
- Microsoft Excel Beginner to Advanced: Superfast Excel Course
Deal Score+2
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
