The Faculty Success Center is excited to announce NEW curated Learning Paths within LinkedIn Learning that have been designed specifically for University of Cincinnati Faculty.
Each Learning Path has been carefully selected and reviewed to provide faculty with the best possible experience.
This collection series will be available online.
Additional Info:
To access this material, please follow these instructions:
1. Open a new tab and go to https://www.linkedin.com/learning
2. Log into LinkedIn Learning with your UC account
3. Copy and paste the link in the Link for the session on your LinkedIn Learning tab to access the materials. It is important that you are logged into Linkedin Learning prior to accessing the course materials or else the link will not work.
Introduction to Microsoft Excel for Educators
Link: https://www.linkedin.com/learning-login/share?account=2133849&forceAccount=true&redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fpaths%2Funiversity-of-cincinnati-fec-introduction-to-microsoft-excel-for-educators-1%3FshareId=29020f97-123c-4c00-890f-dd7d9ae48e5a
Excel Essential Training (Office 365/Microsoft 365)
- Describe the process for adding a command to the Quick Access toolbar.
- Cite the shortcuts for Undo and Redo.
- Name the keys commonly used to move, copy, and insert data.
- Explain how to create a chart.
- Summarize the process for freezing and unfreezing panes.
- Describe methods for sorting data.
- Explain how to create Pivot Tables.
Link: https://www.linkedin.com/learning/paths/university-of-cincinnati-fec-introduction-to-microsoft-excel-for-educators-1-1?shareId=6fb96795-9cce-43b6-8dc4-8609ac142b17&accountId=2133849&u=2133849&success=true&authUUID=A9RXe3L9R72NipVwEQZ9lg%3D%3D
Introduction to Formatting in Excel for Educators???????
- Controlling fonts, borders, colors, and alignment
- Adjusting numeric formats quickly
- Accentuating dynamic data with conditional formatting
- Adjusting rows and columns
Link: https://www.linkedin.com/learning/paths/university-of-cincinnati-fec-introduction-to-formatting-in-excel-for-educators-2?shareId=6880a07f-15ec-4a30-8f48-be796d4463cb&accountId=2133849&u=2133849&success=true&authUUID=bFAuW0KbSBG8tLq6BZKf6w%3D%3D
Advanced Formatting Techniques (365/2019)
- Working with alignment tools
- Adjusting numeric formats
- Tables, styles, and themes
- Row, column, and sheet adjustments
- Worksheet formatting tools
- Displaying data as an outline
- Adding and formatting images
- Power formatting techniques
Link: https://www.linkedin.com/learning-login/share?account=2133849&forceAccount=true&redirect=https://www.linkedin.com/learning/paths/university-of-cincinnati-fec-advanced-formatting-in-excel-for-educators-2-1?shareId=d1ac05a1-8824-45b2-b0d7-fbad3285494d
Introduction to Formulas and Functions
- Define “formula.”
- Identify three comparison operators.
- Name two keys used to end editing mode in a cell.
- Recall the key used to open the Help pane in Excel.
- Recognize a valid time range in the Subtotal dialog box.
- Determine which formula would calculate the sum of a Sales column in a Sales Data table.
- Identify the file type that can be opened directly into Excel.
- Explain how to enable Flash Fill.
- Summarize the purpose of a precedent in a formula.
Link: https://www.linkedin.com/learning-login/share?account=2133849&forceAccount=true&redirect=https://www.linkedin.com/learning/paths/university-of-cincinnati-fec-introduction-to-formulas-and-functions-for-educators-3?shareId=04d58e3f-3e0a-4b8c-9f47-758b8e3b6e8b
Advanced Formulas and Functions
- Recognize the results of the MOD function.
- Identify the Excel random number generating functions.
- Apply the ROMAN function to convert a Roman numeral to Arabic.
- Give an example where the LEFT and RIGHT functions could be used.
- Describe the TRIM function.
- Define the Excel Text functions.
- Differentiate between Information functions.
Link: https://www.linkedin.com/learning-login/share?account=2133849&forceAccount=true&redirect=https://www.linkedin.com/learning/paths/university-of-cincinnati-fec-advanced-formulas-and-functions-for-educators-3-1?shareId=332a5aac-ad36-4bd3-ad70-b2787ee4892a
Introduction to Charts and Graphs
- Identifying chart elements and chart types
- Creating a basic chart
- Choosing a chart layout and style
- Working with column, bar, and line charts
Link: https://www.linkedin.com/learning-login/share?account=2133849&forceAccount=true&redirect=https://www.linkedin.com/learning/paths/university-of-cincinnati-fec-introduction-to-charts-for-educators-4?shareId=3c57ba4d-206c-4aee-a38d-490703833c71