Mastering MS Excel (with exercises and solution videos)
Free Download Udemy Mastering MS Excel (with exercises and solution videos). With the help of this course you can A course on the key fundamentals of Microsoft Excel – including practice exercises and solution videos.
This course was created by Jef Jacobs. It was rated 4.9 out of 5 by approx 10544 ratings. There are approx 71988 users enrolled with this course, so don’t wait to download yours now. This course also includes 4.5 hours on-demand video, 26 Supplemental Resources, Full lifetime access, Access on mobile and TV & Certificate of Completion.
What Will You Learn?
- Enter data in any format (e.g. numbers, text or dates)
- How to select data and navigate Excel in a quick and efficient way
- How to format cells so that data is easy to read and understand
- Manage, clean and organize large tables or spreadsheets
- Use formulas and functions for completing calculations (SUM, COUNT, AVERAGE, etc.)
- Dealing with annoying errors in Excel
- How to copy and paste data (and how to manage formulas and formatting)
- How to fix cell references using the “$” symbol
- Using Text based formulas (e.g. TRIM, PROPER, and CONCATENATE)
- The power of the IF function and its derivatives (e.g. AND, OR, SUMIF, COUNTIF)
- Advanced referencing functions – VLOOKUP, HLOOKUP and OFFSET
- Drawing visually effective graphs and charts (and how to format them)
Hello there and welcome to Mastering Microsoft Excel. You have come to the right place if you want to improve your Microsoft Excel skills. This course will help you feel confident rather than intimidated by Microsoft Excel.
Excel has played a big part in my working career as a university lecturer, management consultant and analytics manager. I hope that you too can make Excel work for you.
This course is structured from basic topics to more advanced ones, but you’re welcome to skip and jump to any chapter that meets your work, life or interest needs.
Each chapter includes downloadable files that you can use to practice what was discussed in each video or to test your overall knowledge. Remember, only by practicing will your skills improve. Happy learning!
Buy Udemy’s Mastering MS Excel (with exercises and solution videos)
Free Download Udemy’s Mastering MS Excel (with exercises and solution videos)
4.1