This course covers Microsoft Excel in-depth with focus on business data analysis and an intro to Macros. So make sure you follow the videos in the order I have labelled them.

The outline are:

Data Manipulation in Excel

a. How Excel handles different data types

b. Data consistency, starting with the end in view

c. Building Datasheets that can easily scale

d. Sorting

i. Cascaded sorting

ii. Sorting across rows (left to right sorting, not the usual up to down sorting)

iii. Sorting and Conditional Formatting to identify trends

e. Filtering

f. Data cleaning

i. Removing duplicates

ii. Text-to-column

iii. Grouping

iv. Data Validation

v. Conditional Formatting

g. Data formatting

i. Using Tables (and when to convert to tables)

ii. Formatting for printing

iii. Formatting for email

iv. Data Review and formatting for 3rd party use

h. Named Ranges

Charts

a. Chart types

i. Line chart and when to use it

ii. Column chart and when to use it

iii. Bar chart and when to use it

iv. Pie chart and it’s dangers

b. Combining charts; when and how.

c. Dynamic Charts, using filter.

d. Best practices when making charts

e. Sparklines

a .Best Practices

b. Excel Dashboards

c. Data Visualization

d. Having the audience/recipient in mind

e. E-mails and Excel reports

Excel to PowerPoint and Word

a. Linking PowerPoint/Word Charts to Excel

b. Embedding Excel sheets in PowerPoint/Word

c. Making a Powerful PowerPoint Presentation

Reporting

a. Best Practices

b. Excel Dashboards

c. Data Visualization

d. Having the audience/recipient in mind

e. E-mails and Excel reports

And more...