Mastering Formulas, Functions, and Data Analysis for Business Professionals
Sub Category
- Microsoft
{inAds}
Objectives
- Introduction to the Excel Interface
- Move and Copy Data in Worksheet
- Working with Rand & Randbetween
- Working with ROUND, ROUNDUP and ROUNDDOWN
- Date and DATEDIF Function
- CHOOSE and SWITCH Function
- UPPER, LOWER, PROPER & TRIM
- LEFT, MID, RIGHT & LEN
- SORT and SORTBY Functions
- INDEX, MATCH, XMATCH and EXTACT Function
- Combining EXTACT & VLOOKUP
- Custom Data Validation
- XLOOKUP Function
- Creating a PivotTable from Scratch
- Applying PivotTable Styles
- Create a Bar, Column, Line and Pie Chat
- Inserting and Formatting Slicers
- Proetect Worksheet and Workbook
- Inserting Headers and Footers
- Printing a Workbook
Pre Requisites
- No prior Excel experience is needed
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)