Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 0 / 100
Live Chat with CourseDuck's Co-Founder for Help
Need help deciding on a excel course? Or looking for more detail on Edward McCrae's Excel 2019? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community
Course Description
This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.
Instructor Details
- 0.0 Rating
- 0 Reviews
Edward McCrae
Ed specializes in Excel Workbook development, Access Database Design, and SharePoint site creation and administration. Ed has been in the technical training industry since 2006 and has taught Microsoft Office 97-2016, Microsoft Project, SharePoint 3.0 - 2013, as well as a host of other applications and business skills classes.
Students also recommend
-
Microsoft Excel - Online Tutorial for Beginners (2010)
-
0.0 (0 Reviews)
-
- Provider: Chandoo.org
- Time: 1h 30m
Free