Working With Excel and Function Keys Windows Mac. F4 COMMAND+Y Repeats the last command or action, if possible. F9 Fn+F9 Calculates all worksheets in all open workbooks. F11 Fn+F11 Creates a pivot chart in the new worksheet. Excel and the Function Key Shortcuts Author: Investintech.com Inc. Conquer some of the most daunting features in Microsoft Excel: formulas and functions. In this Excel for Mac 2016 update to his popular series, author Dennis Taylor presents numerous formulas and functions in Excel and shows how to use them efficiently. The course begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. Dennis then covers how to perform logical tests with the IF, AND, OR, and NOT functions; search and retrieve data with lookup functions (VLOOKUP, MATCH, and INDEX); analyze data with statistical functions; use text functions to clean up worksheets; work with array formulas and functions, and master date and time calculations. Dennis focuses on practical examples that transition effortlessly to real-world scenarios. Start watching to take advantage of the tremendous power offered by Excel formulas and functions. Instructor •. Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training. Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado. By: Curt Frye course • 2h 3m 10s • 47,332 viewers • Course Transcript - [Voiceover] When you work with certain formulas, sometimes you recognize that a result is just dead wrong. It's way off. On this worksheet called debug values, I've zoomed in. We're looking at cell D13. Eset antivirus for mac turn off usb. I know that answer is wrong. I'm not sure why it's about half of what it should be, so I'm going to edit this. Now, I can do this in the formula bar or, maybe a little better, right on the cell itself. Because I've zoomed in so much, I'll double click the cell, and do the editing in here. Now, what I'd like to be able to do is to highlight portions of this to see what a portion of it is equal to. If I highlight this calculation right here and find out what it's equal to, maybe that will help me figure out what's going on or it might not. ![]() I'm not sure, but I've got it highlighted. I'll press the function key F9, and that's as if to say, throw away the formula and show me the result for just the highlighted portion of the formula. So, function key F9 brings me this. Now, maybe that • Practice while you learn with exercise files. Free firewall software for mac computer. Watch this course anytime, anywhere. Course Contents • Introduction Introduction • • • 1. Formula and Function Tools 1. Formula and Function Tools • • • • • • • • 2. Formula and Function Tips and Shortcuts 2. Formula and Function Tips and Shortcuts • • • • • • • • • • 3. IF and Related Functions 3. IF and Related Functions • • • • 4. Lookup and Reference Functions 4. Lookup and Reference Functions • • • • • • • • • • 5. Statistical Functions 5. Statistical Functions • • • • • • 6. Power Functions 6. Power Functions • • • • 7. Selected Financial Functions 7. Selected Financial Functions • • • • 8. Math Functions 8. Math Functions • • • • • • • • • 9. Date and Time Functions 9. Date and Time Functions • • • • • • • • 10. Text Functions 10. Text Functions • • • • • • • • 11. Array Formulas and Functions 11. Array Formulas and Functions • • • • • • • 12. Reference Functions 12. Reference Functions • • • • • 13. Information Functions 13. Information Functions • • • • • Conclusion Conclusion •.
0 Comments
Leave a Reply. |