Emory Microsoft Excel classes in Atlanta Georgia. In Part 2 of this course, we will continue to discuss VLOOKUPSHLOOKUPS to pull together information from large, database like workbooks. From there, we will construct logical comparisons between given and expected values using IFTHENELSE statements to make data more readable. You will discover how to formulate smarter worksheets by understanding Excels time format and using Date Calculations such as TODAY, YEAR, and ROUNDDOWN. New subscriber Patrick wrote for help with a Microsoft Excel problem Hi Terry Im wondering if you can help me with a mouse problem I have. Track time spent volunteering, traveling, or working by creating a worksheet that calculates the interval between time in and time out. To keep data accurate, we will also learn to use Data Validation criteria. Using COUNTIF, SUMIF and AVERAGEIF will help us perform calculations on data meeting specific criteria to extract more meaning from our worksheets. Finally, discover how to calculate totals, averages, and counts within a database system based on certain criteria using DSUM, DAVERAGE, and DCOUNTAudience We designed this course for current, advanced users of Excel who want to know more about formulas and functions. This course builds on Excelling at Excel The FUNdamentals, Excelling at Excel The 5 Fs, and Excelling at Excel Formulas and Functions. Software We teach this course using Microsoft Excel 2. PCs, but the content should also apply to Excel 2. Windows. Material learned in this course may not apply to Excel for Mac. After completing this course, participants will be able to. Explain more uses of VLOOKUPSHLOOKUPSEstablish criteria using Data Validation to more easily search for data. Measure time in hours and minutes, days, and years. Create multiple IF THEN ELSE statements for more efficient functions. Develop functionsCOUNTIFS, SUMIFS, AVERAGEIFS, DSUM, DCOUNT, and DAVERAGEthat give results based on criteria.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |