About this Event
1. Introduction to Microsoft Excel
- Brief overview of Microsoft Excel
- Importance of Excel in daily and professional tasks
- Navigating the Excel interface (ribbon, tabs, cells, rows, columns)
2. Basic Excel Operations
- How to create, open, and save an Excel workbook
- Inputting data (text, numbers, dates)
- Editing data (cut, copy, paste, undo, redo)
- Formatting cells (font, color, alignment, borders)
- Adjusting row height and column width
- Auto-fill
3. Introduction to Formulas and Functions
- What are formulas and functions?
- Basic mathematical operations (add, subtract, multiply, divide)
- Using basic functions:
4. Working with Data
- Sorting and filtering data
- Introduction to data validation
- Conditional formatting (highlighting cells based on rules)
- Freezing panes for better data viewing
5. Charts and Graphs
- Creating simple charts (bar chart, pie chart, line graph)
- Customizing charts (titles, legends, colors)
6. Managing Worksheets
- Adding, renaming, and moving worksheets
- Protecting and hiding worksheets
7. Printing and Exporting
- Print settings (print area, page orientation, scaling)
- Exporting files to PDF or other formats
Takeaways:
- Basic Excel skills for personal and professional use
- Confidence in working with Excel spreadsheets, data, and formulas
Event Venue
Online
AUD 25.00