Basic Excel Consultation

Having Basic Excel Queries regarding the following

1. Formula structuring with 1, 2, or 3 functions
2. Formatting the Sheet & Workbook
3. Page Setup (for better Printouts & PDF generation)
4. Conditional Formatting
5. Basic Data Validation settings

1. Formulas covered under Excel Basics:

• Logical Functions: IF, IFERROR, AND, OR, and IFS
• Text Functions: CANCAT, LEFT, MID, RIGHT, UPPER, LOWER, PROPER, and VALUE
• Lookup & References Functions: Basic functionalities of LOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH, and GETPIVOTDATA
• Math & Trig Functions: RAND, ROUND, ROUNDUP, ROUNDDOWN, SUBTOTAL, SUM, SUMIF, and SUMIFS
• Statistical Functions: MAX, MIN, LARGE, and SMALL

>> any of the above functions or a combination of two.