Excel Basics
- #4 – GETTING TO KNOW excel
- #5 – CREATING AND OPENING workbooks
- #6 – SAVING AND SHARING workbooks
- #7 – cell basics
- #8 – modifying columns, rows, and cells
- #9 – formatting cells
- #10- worksheet basics
- #11- page layout
- #12- printing workbooks
Formulas and Functions
- #13- single formulas
- #14- complex formulas
- #15- relative and absolute references
- #16- functions
- Working with Data
- #17- freezing panes and views options
- #18 – sorting data
- #19 – filtering data
- #20 – groups and subtotals
- #21 – tables
- #22 – charts
- #23 – sparklines
- This assignment gives you practice using what you have learned about Excel without step-by-step directions