Microsoft excel courses nyc12/11/2023 ![]() ![]() Throughout the class, we'll show you tricks and techniques to speed up your workflow, including navigational and keyboard shortcuts. We will show you crucial database management tools including Named Ranges, Sort & Filter, and Data Validation to help you enter data quickly and efficiently. ![]() Intermediate Excel also covers VLOOKUP and HLOOKUP to query columns and rows. If you’re using Excel to manage large datasets, Intermediate Excel will help you manage data better with lessons on basic database functions. Learn Functions to Manage Your Excel Database In this intermediate-level course, you will learn Pivot Tables, summary tables that calculate statistics and essential information from massive datasets. This course is perfect for those with an understanding of basic formulas and functions, charts, and workbook management techniques. Intermediate Excel covers the essential applications of Excel used frequently by business professionals. Intermediate Microsoft Excel Course at Career Centers Combine charts to illustrate complex relationships between data.Perform descriptive statistics functions with COUNTIFS and SUMIFS.Query Excel data with VLOOKUP and other database features.Use Pivot Tables to summarize large datasets.In this intermediate course, you’ll learn the following skills: Restrict the type of data that can be allowed in a cellĬombine two or more charts into a single chart, with the option of adding a secondary axisĮnd of class project to review key concepts from the classĪre you comfortable with the essential functions of Excel, such as entering data, basic calculations, and formatting spreadsheets? If so, there’s a lot more Excel can do to help with your business needs. Use COUNTIFS function to count cells based on one or more conditions Use SUMIFS function to sum cells based on one or more conditions Use SUBTOTAL function to sum/average/count values based on what is not filtered Tests to see whether multiple conditions are true Use IF statements to return output based on the contents of another cell Use Sort & Filter to find and organize data in large databasesĬreate Pivot Tables to quickly summarize large databasesĬreate multiple Pivot Tables on a single worksheet Use VLOOKUP and XLOOKUP to find information in cell range and return information from another cell range Hardcode the answer to a formula or functionĪssign a name to a range of cells to make it easier to reference those ranges in calculations Use Text to Columns to split text into multiple cellsĪpply formats and perform calculations on selected cells Review various methods for completing calculations Keyboard shortcuts that facilitate quick and easy navigation within cells ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |