MS Excel - Data Analysis for Beginners

MS Office course designed for employees of the University of South Bohemia. 

Working with lists, filters, summaries, and visual elements for better data orientation.

Lists and working with data

• Principles of proper data organization: headers, consistency, no empty rows

Filtering data

• Using automatic filters

• Filtering by value, text, numbers, date, filtering by cell color or font

• Clearing filters and returning to the entire list

Sorting data

• Sorting ascending/descending by one column

• Multi-level sorting (e.g., by department and then by name)

• Sorting by custom criteria (e.g., custom category order)

Advanced filter

• Difference between automatic and advanced filters

• Creating criteria for an advanced filter, using an advanced filter to select specific data

Summaries and data grouping

• Using the "Summary" function (Data → Summary)

• Automatic calculations: sum, average, count

• Grouping and ungrouping data using levels

Dynamic filling

• What is dynamic filling (Flash Fill), automatic text splitting or merging

Automatic table (format as table)

• Converting a list to a table using "Format as Table"

• Advantages: automatic expansion, filtering, styling

Conditional formatting for advanced users

• Creating rules for highlighting values

• Color scales, data bars, icons

• Custom rules using formulas

• Examples: highlighting values above average, marking duplicates, visualizing trends

Charts – creating a simple chart

Mgr. Vendula Mikolášková
This email address is being protected from spambots. You need JavaScript enabled to view it.