Rating 4.05 out of 5 (17 ratings in Udemy)
What you'll 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 …
Rating 4.05 out of 5 (17 ratings in Udemy)
What you'll 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
DescriptionThis 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.
