How much Excel do you know?

Hello Excellent,

I am sure your week has been awesome. On my side, it has been a multiple Ctrl+S+H, where "S"= "Smile" and "H"="Happy". 

As you look forward to another weekend starting in few hours, let me quickly intimate you of our discussion lines starting from next week and we shall abide by this plan so we can all easily learn together from basic to the advance space without leaving any row or column untouched. 

How much Excel do you know? Are you a beginner, learner, basic, intermediate or advance user? Are you an Excel MVP or GM?  Join our discussion starting from next week Monday till the last row and column are filled up. Within this space, we shall be gist-ing on;  

1. The Excel Environment

• Entering and editing data
• Entering and editing text and values
• Entering text and values
• Editing cell contents
• Using AutoFill to fill a series
• Entering and editing formulas
• Creating a basic formula
• Entering cell references
• Editing a formula
• Working with the order of operations- "BODMAS"

2. Using Functions

Starting with

3. Advanced Formatting

• Using special number formats
• Using functions to format text
• Working with styles
• Working with themes
• Other advanced formatting

4. Outlining and Subtotals

• Outlining and consolidating data
• Creating subtotals

5. Cell and range names

• Creating and using names
• Managing names

6. Tables

• Sorting and filtering data
• Advanced filtering
• Working with tables
• Using Lookup functions

7. Pivot Tables and Pivot Charts

• Working with Pivot Tables
• Rearranging Pivot Tables
• Formatting Pivot Tables
• Using Pivot Charts

8. Advanced Charting/ Dashboards

• Chart formatting options
• Combination charts
• Graphical elements
• Building intuitive dashboards

9. Documenting and Auditing

• Auditing features
• Comments in cells and workbooks
• Protection
• Workgroup collaboration

See you then....

Oladapo Sorinola 

BB pin 52E9802D

07014282477, 07062932708