Office Productivity Online Course by Udemy, On Sale Here
Pivot tables, Vlookup/Hlookup/Index/Offset with Match, Formatting, If functions, Filtering, Financial Analysis & more.
An excellent training about Microsoft
Master Excel With Your Keyboard
If you’re a beginner level (or intermediate level) Excel user, this course is for you. This course will introduce you to a range of skills and functions that are vital for any office job. Not only will this course make you more knowledgeable, it will make you a much faster Excel user too through a heavy focus on using the keyboard (instead of the mouse) wherever possible. By the end of this course, the key skills that you will have learned are as follows: Quickly format your Excel workbooks using a range of easy-to-remember keyboard shortcuts to improve the presentation of datasets. Use advanced conditional formatting to quickly highlight entries in your dataset which match a range of criteria. Use If functions and nested If functions to help you categorise your data. Use a range of lookup functions (and combine them with the Match function) in order to quickly pull up relevant data in your Excel worksheet. Use Pivot Tables to quickly extract insights from your dataset. Learn mathematical functions and also learn how to conduct linear regression in your Excel workbook to measure and quantify relationships between variables. Learn about financial functions in Excel which will then be applied to bond valuation problems. The many uses of the Sumproduct formula. You will be introduced to all these key skills and more through watching videos and you will have an opportunity to consolidate and apply these skills through a number of assignments (there are 7 main assignments) that are included in the course.
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.