Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it
Learn Excel fundamentals through a comprehensive video series covering three versions: Excel 2007 (videos 1-23), Excel 2010 (videos 20-40), and Excel 2013 (videos 1-27). Master essential spreadsheet skills starting with basic grid navigation, formatting, and formulas, then progress to advanced topics including cell references, functions, and data analysis. Explore Excel's core capabilities through systematic instruction on calculations, formula construction, and the application of Excel's Golden Rule for efficient spreadsheet design. Develop proficiency with essential functions like SUM, COUNT, COUNTIFS, SUMIFS, IF, and VLOOKUP while learning proper data organization techniques. Discover formatting options including stylistic formatting, number formatting, conditional formatting, and percentage displays. Build expertise in data analysis tools such as sorting, filtering, PivotTables, and chart creation across multiple chart types. Practice keyboard shortcuts for increased efficiency and learn to customize the Quick Access Toolbar and Ribbon interface. Understand the importance of proper data setup for analysis features and explore advanced concepts like relative, absolute, and mixed cell references. Gain hands-on experience with real-world applications including business calculations, payroll time sheets, loan calculations, and project management scenarios. Each lesson builds systematically upon previous concepts to create a solid foundation for completing most Excel tasks, from basic spreadsheet creation to sophisticated data analysis and reporting.
