Excel Skills for Business Specialization

Course 1 of 4: Excel Skills for Business: Essentials

Learn the essentials of Microsoft Excel
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
Solve a broad range of business problems as you apply the Excel skills and techniques you learn along the way
Practice your Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts

Weekly Assessment

Course Syllabus:

Week	Syllabus	Details
1	Taking Charge of Excel	Describe key components of the Excel user interface Operate essential navigational controls Perform the basics of data entry in Excel Explain basic Excel terminology
2	Performing Calculations	Explain the syntax of basic formulas and functions Use formulas and functions to perform simple calculations Describe the difference between relative and absolute cell references
3	Formatting	Give examples of key formatting tools and their uses in Excel Modify spreadsheets with Excel styles and themes Explain the use of number formatting in Excel Format a raw data sheet using Excel formatting tools
4	Working with Data	Manage rows, columns, and worksheets Identify, retrieve and change data in spreadsheets Explain how to operate Conditional Formatting in Excel Use the conditional formatting tool to highlight specific data
5	Printing	Identify the key printing tools and options in Excel Optimise a spreadsheet for printing Create a spreadsheet for printing with repeating elements
6	Charts	Describe basic chart types in Excel Produce basic charts in Excel Modify charts in Excel