Excel on SharePoint
Learn how to create interactive data presentations in Excel that can be viewed in any browser without opening Excel
Description
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.
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
- Learn how to apply conditional formatting to a row based on the value of one cell
- Learn how to configure Conditional Formatting to worksheet based on input from the EWAWP Parameter task pane
- Perform DATE and TIME calculations in Excel using SharePoint list data involving dates
- Learn how to configure the Excel Web Access Web Part to allow for PivotTable interactivity through the browser
- Learn to use named ranges in Excel VLOOKUP formula
- Learn how to supply VLOOKUP values in-cell lists, Data Slicers, EWAWP Parameter task pane, and connected filter web parts
- Learn how to build dashboards in SharePoint using Excel data and browser view options settings
- Learn how to connect an Excel Web Access Web Part to an Excel document library to display any selected Excel file on the same page
Who Should Attend!
- SharePoint content managers looking for ways to use more of SharePoint's built-in functionality
- Data Analysts who need to display Excel data on SharePoint