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.
- Basic proficiency with Excel, including PivotTables, Pivot Charts, VLOOKUP, and named ranges
- Basic proficiency with SharePoint document libraries and web part pages