Home > Courses > Other > IT & Software > Excel on SharePoint
   3.9  14 reviews on Udemy

Excel on SharePoint

Learn how to create interactive data presentations in Excel that can be viewed in any browser without opening Excel
Course from Udemy
 78 students enrolled
 en
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

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.

Excel on SharePoint
$ 19.99
per course
Also check at

FAQs About "Excel on SharePoint"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

CONTACT

[email protected]

SOCIAL NETWORK

Copyright © Elektev
Privacy Policy