"Crack Coding Challenges with Real-World SQL Solutions Specialist"

The session focused on practical Excel skills, including data manipulation, VLOOKUP/XLOOKUP functions, and file formatting. The student worked on a real-world problem of updating product pricing in a spreadsheet. The tutor provided guidance on data cleaning, formula application, and error handling.

The Tutor and Student reviewed Excel functions including SUMIF, SUMIFS, COUNTIF, UNIQUE, TRANSPOSE, and VLOOKUP. The Student practiced using these formulas to analyze sales data based on different criteria. The Student was assigned practice exercises using the functions covered in the session, focusing on solidifying their understanding of SUMIF, COUNTIF, and VLOOKUP.

The Student reviewed conditional Excel functions including IF, IFS, IFERROR, AND, and OR, as well as SUM, AVERAGE, and COUNT functions. They practiced applying these functions to different scenarios and datasets. The session concluded with a plan to cover data validation and VLOOKUP in the next class, along with a review of a spreadsheet from the student's work.

The session reviewed Excel formulas including conditional formatting, text manipulation (LEFT, RIGHT, UPPER, LOWER, PROPER, TRIM, SUBSTITUTE), IF statements, nested IFs, logical operators, IF ERROR, OR, and AND. The student practiced applying these formulas to sales data and other examples. The tutor assigned exercises from a shared file to reinforce the concepts covered.

The Student learned Excel shortcuts for cell navigation and selection and practiced using these in conjunction with filling and formatting operations. The class also covered paste options, format painter, text alignment, borders, cell coloring, and number formatting. The Student will practice these shortcuts and techniques further, focusing on using keyboard shortcuts instead of a mouse.