In this first course of the specialization Excel Skills for Business, you will learn the essentials of Microsoft Excel. Within six weeks, you will be able to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
- Critical Core of Excel.
- Performing calculations.
- Working with Data.
- Final Assessment.
What will you learn
- How to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.
- How to write formulas and functions, use them to perform calculations and understand the different cell references.
- How you can manage your spreadsheets — find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.
- How you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.