Microsoft 365 Excel Fundamentals: Formulas, Functions, Formatting and Page Setup - Part 1
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Learn essential Microsoft 365 Excel fundamentals in this comprehensive video tutorial taught by experienced Highline College Professor and YouTuber Mike Girvin. Master formulas, functions, and formatting while building a practical gradebook project. Explore crucial Excel concepts including the Ribbon interface, data analysis capabilities, worksheet structure, and default alignments. Practice efficient data entry techniques using keyboard shortcuts, Fill Handle operations, and selection tricks. Discover how to implement various formula types including aggregate calculations, relative/absolute cell references, and dynamic spilled array formulas. Apply professional formatting with styles, borders, and fonts, while learning essential functions like SUM, AVERAGE, XLOOKUP, IFERROR, BYROW, and BYCOL. Gain practical knowledge about page setup, worksheet management, and Excel's Golden Rule for formula creation. Downloadable practice files and PDF notes are provided to follow along with the hands-on demonstrations. Read more