This makes is easier for people to enter valid information in worksheets This video shows skill number 4 in my list – how to create a drop down list in a worksheet cell, with data validation. This video shows skill number 2 in my list – how to create a pivot table to summarize data in Excel. This example uses the SUMIFS function to get the total. This video shows skill number 1 in my list – how to sum numbers based on multiple criteria. Would any of these make your list? There are videos for some of these skills below, and Excel courses that you can take, to improve your skills quickly.Ġ1) Sum or Count cells, based on one criterion or multiple criteriaĠ2) Build a Pivot Table to summarize dateĠ3) Write a formula with absolute and relative referencesĠ4) Create a drop down list of options in a cell, for easier data entryĠ5) Sort a list of text and/or numbers without messing up the dataĠ6) Create a worksheet formula to look up a specific value in a tableĠ7) Record and modify a simple Excel macro and use it to save timeĠ8) Design and build a simple worksheet template, such as an order formĠ9) Create an Excel chart from worksheet dataġ0) Apply conditional formatting that uses a formula as its ruleġ1) Nest two or more functions in a formulaġ2) Insert and protect worksheets (and understand the limits of Excel’s worksheet protection)ġ3) Create formulas for simple date and time arithmeticġ4) Filter unique items from a list Basic Skills for Excel Users – 1 I’m sure your list is different, but here’s mine. If you use Excel at work, or list it on your résumé, what tasks should you be able to do? Are there basic skills for Excel users that office workers should be able to perform with little or no help?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |