🔅 Excel Formulas and Functions Quick Tips

🌐 Author: Jess Stratton
🔰 Level: General

⏰ Duration: 35m

🌀 These bite-sized tips will help you learn how to use Excel's most common functions and formulas.

📗 Topics: Microsoft Excel

📤 Join @linkedin_learning for more courses

🔸 Full description 🔸

The myriad formulas and functions in Excel are a large part of what makes it such a uniquely powerful program. But for many users, figuring out how to apply these formulas and functions to solve everyday problems can seem overwhelming. In this course, staff instructor Jess Stratton demystifies these powerful features, sharing bite-sized tips designed to help you work faster and more efficiently in Excel. Jess begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She goes over identifying values, then digs into a variety of useful Excel functions. Jess highlights how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.

📦 Exercice Files

🔅 Excel: Setting Up a Database (Microsoft 365)

🌐 Author: Dennis Taylor
🔰 Level: Intermediate

⏰ Duration: 47m

🌀 Learn how to create a simple yet powerful database using Microsoft Excel. This course covers all the steps, from preparing data to using slicers to filter data.

📗 Topics: Microsoft Excel, Database Design

📤 Join @linkedin_learning for more courses

🔸 Full description 🔸

Did you know you can use Excel to create a simple database and get even more insights into your data? Join instructor Dennis Taylor and learn how to create a simple database. Dennis explains how to prepare lists that are suitable for data analysis. He goes into how to use the Form tool to view and manage records in a list, then covers how to use the Data Validation command to enter data quickly and accurately. Dennis steps through how to convert data to a table and use its many valuable features. He discusses the Table Design tab, demonstrating how to access the many formatting features to apply to tables. He demonstrates how to expand tables quickly and easily by adding adjacent rows and columns, as well as total rows. Dennis highlights some techniques for creating formulas using field names. He concludes by showing you how to use slicers to filter data with appealing, easy-to-read visuals.

📦 Exercice Files

🔅 Practice It: CSS Layout

🌐 Author: Julia Dyck
🔰 Level: Intermediate

⏰ Duration: 1h 52m

🌀 Get hands-on practice with some of the most powerful CSS features.

📗 Topics: Cascading Style Sheets

📤 Join @webdev_trainings for more courses

🔅 Excel: Mastering Pivot Table Dashboards and Reports

🌐 Author: Jordan Goldmeier
🔰 Level: Intermediate

⏰ Duration: 1h 16m

🌀 Discover an approachable, foolproof way of thinking about and using PivotTables in Microsoft Excel.

📗 Topics: Pivot Tables, Excel Dashboards, Microsoft Excel

📤 Join @linkedin_learning for more courses

🔸 Full description 🔸

PivotTables are one of the most important features available in Microsoft Excel. They simplify data analysis, allowing you to create summaries and reports instantly, and they just got even better. The new Excel data model takes things a step further by letting you connect PivotTables to build out a miniature database. In this course, instructor Jordan Goldmeier shows you how to get up and running with PivotTable basics. Discover an approachable, foolproof way of thinking about PivotTables that allows you to build summaries across different column fields with ease from any dataset. Along the way, learn how to use PivotTable connections to create an interactive dashboard for replication and reuse.

📦 Exercice Files

🔅 Ionic 4.0 Essential Training

🌐 Author: Sani Yusuf
🔰 Level: Intermediate

⏰ Duration: 5h 4m

🌀 Learn how to develop a single code base using the Ionic 4.0 SDK to ensure your app is compatible across the popular mobile and desktop operating systems.

📗 Topics: Ionic Framework

📤 Join @linkedin_learning for more courses

🔸 Full description 🔸

Learn how to use Ionic to develop a highly performant mobile app that is compatible across the popular mobile and desktop operating systems. In this project-based course, Sani Yusuf walks through the ins and outs of the 4.0 framework. He shows how you can create a single code base that effectively works across iOS, Android, and Windows. First, Sani provides an overview of Ionic and introduces key features in the latest version of the mobile SDK. Then he takes you through the step-by-step process of building an app, including the setup process, working with templates, previewing apps on a device, developing UI and navigation components, working with Ionic Natives, connecting to the back end, and more.

📦 Exercice Files

🔅 Git Essential Training

🌐 Author: Barbara Forbes
🔰 Level: Beginner

⏰ Duration: 1h 23m

🌀 Learn about the basics of Git and get comfortable working with Git, as well as GitHub Star and Microsoft MVP, on your own projects.

📗 Topics: Git

📤 Join @linkedin_learning for more courses

🔸 Full description 🔸

If youve ever wondered why someone should use Git or how to use it for version control, this is a great course to get started. Azure MVP and GitHub Star Barbara Forbes guides you through the installation process, the Git workflow, setting up and pushing code into a repo, and committing changes, all with a focus on version control and how Git can help you achieve it. Find out why people use Git. Learn how Git works, locally or through a provider, and how you can get it installed, configured, and running the way you need it to work. Follow the full process of pushing your code with Git, then explore ways to make changes to files. Discover important concepts in Git, like how to ignore files you dont want to include, how branching can help you with development, what should be in a commit, and how to troubleshoot if you get into trouble. Plus, get current instruction on using GitHub Star and Microsoft MVP.