Excel on SharePoint
Learn how to create interactive data presentations in Excel that can be viewed in any browser without opening Excel
4.17 (20 reviews)
126
students
2.5 hours
content
Sep 2019
last update
$39.99
regular price
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
Screenshots
Related Topics
2299284
udemy ID
3/30/2019
course created date
3/22/2020
course indexed date
Bot
course submited by