Excel on SharePoint

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

4.10 (19 reviews)

Udemy

platform

English

language

Other

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

Why take this course?

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.

Screenshots

Reviews

Wagner

May 19, 2020

Hasta la seccion 5 temas nuevos a partir de ahi revisar dedicar 15 minutos a explicar el Vlookup me parece excesivo. La parte final de manejo de documentos es interesante.

Andrew

May 8, 2020

The instruction is good, clear and concise, but I will re run the course and probably revise my review. TBH it wasnt what I expected but I did glean info from it as I am not familiar with share point.

Billy

September 12, 2019

This was exactly what I needed to learn. So many aspects of Excel work differently when they're on SharePoint. I never would have found this stuff without this course.

Charts

Price

Rating

Enrollment distribution

Excel on SharePoint - Distribution chart