Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles. Transfers to other open sessions of the same course are available. Weve officially started construction on our Crewe Center for the Arts, which will open in 2025 with state-of-the-art teaching, learning, and performance spaces. Use your college or university email address to verify your student status and sign up to save over 50 on the regular price of Microsoft 365 Personal. Series bundles are not eligible for partial drops or refunds. By the time you finish this course, you will know all the possible features and function of Microsoft's powerful spreadsheet software. You will learn advanced techniques for PivotTables, conditional formatting to highlight duplicate entries, and importing external data using Excel's built-in Power Query tool. Visit and log in with your UofL email and the password to your email After youre logged in, you should be able to download Microsoft Office. You will master advanced features that most users don't even know exist, such as scenarios and data tables to perform what-if data analysis. The Summer Health Professions Education Program (SHPEP) at the University of. This course will help you make the most of your investment in Microsoft Excel 2019. Shaping the Future of Dentistry, Medicine, Nursing and Pharmacy. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands to create macros that eliminate repetitive tasks. You will master charting and then learn more of Excel's time-saving features like PivotTables, Slicers, and Sparklines. Google Drive is still available, however. This course builds on the fundamental techniques you learned in the introductory Excel 2019 course. As of Summer 2020, students have moved from Google G Suite to Microsoft 365. This course also introduces you to Quick Analysis, Flash Fill, and other powerful charting tools, which are further explored in the intermediate course. You will then learn common formulas and functions, sorting and analyzing data, custom charts and graphs, and how to create three-dimensional workbooks. You will first learn how to quickly and efficiently create fully formatted worksheets. This course focuses on the fundamentals of Excel 2019. UofL Health provides comprehensive care at our UofL Health Jewish Hospital location, in Louisville, Ky.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |