Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master Excel 2007 fundamentals through this comprehensive video course covering essential spreadsheet skills from basic navigation to advanced data analysis. Learn what Excel is and explore keyboard shortcuts before diving into formulas with cell references, functions, operators, and mathematical operations. Discover how to work with named cell ranges, range functions, and understand the differences between relative, absolute, and mixed cell references in formulas. Explore proper spreadsheet setup techniques, stylistic and number formatting options, percentage formats, and the ROUND function for precise calculations. Master date and time formatting and calculations, then advance to creating basic charts and setting up pages for printing. Develop data analysis skills through sorting techniques, subtotals, pivot tables, filtering, and dynamic ranges. Complete your Excel education by mastering essential functions including IF statements and VLOOKUP formulas. Access 24 downloadable video files to follow along with hands-on practice exercises that reinforce each concept taught throughout this 3-hour comprehensive training program.
