Excel on SharePoint

Excel on SharePoint

This course teaches several Intermediate-advanced Excel topics, with an emphasis on ensuring that the elements in Excel are fully usable through the browser on SharePoint.  Topics include:

Charts, Conditional Formatting, Date and Time Functions, PivotTables, Pivot Charts, VLOOKUP formula, Excel Dashboards, and Excel Document Libraries on SharePoint. 

Full written tutorials and accompanying sample files available for every section.

Learn how to create interactive data presentations in Excel that can be viewed in any browser without opening Excel

Url: View Details

What you will learn

• Create and configure Excel workbooks for use in and on SharePoint
• Learn to create basic charts online with Excel Web App
• Learn how to prepare Excel files to present charts online through the Excel Web Access Web Part

Rating: 4.05

Level: Intermediate Level

Duration: 2.5 hours

Instructor: Russell Mangum