
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. This private 8-hour program (4 sessions x 2 hours) will provide an introduction to Excel with the basic tools and functions.
Learning Outcomes for Beginner:
- Provides basics of Excel functionalities
- Use the tools available in the software
- Prepare for advanced concepts
Course Topics
- Basic Functionalities
- Understanding Functions
- Charts & Graphs
- 2 Projects
FULL COURSE OUTLINE: BEGINNERS
- Basic Functionalities
- Understanding the Workbooks.
- Navigating in a File.
- Entering text and numbers into a worksheet.
- Typing simple formulas in a worksheet.
- Filling a Series
- Inserting and Deleting Worksheets.
- Copying a Worksheet.
- Renaming a worksheet.
- Moving or copying a sheet to another workbook
- Changing worksheet name, tab colour.
- Grouping worksheets
- Selecting rows, columns and ranges.
- Freezing rows and columns.
- Understanding formatting.
- Applying general formatting.
- Changing font and font size.
- Understanding Borders.
- Applying border to a range.
- Wrapping and merging text.
- Adding comments to cell.
- Hiding, showing, editing and deleting comments.
- Formatting data and Conditional Formatting.
- Protecting a file.
- Protecting a sheet.
- Protecting a cell / range within a worksheet.
- Protecting a worksheet except a cell / range.
- Filtering and searching
- Filtering with multiple criterions.
- Understanding Functions
- Function to sum, average, power, ceiling, floor, max, min etc similar functions.
- Working with dates.
- Understanding relative referencing and absolute referencing.
- Conditional Statements with “If” functions.
- Nested functions.
- Character related functions as left, right, mid etc related functions.
- Lookup functions with vlookup, hlookup, xlookup
- Working with Mathematical operators in formulas
- Working with Subtotals
- Charts & Graphs
- The Charting processes.
- Creating sparklines.
- Choosing the right chart.
- Using a recommended chart.
- Creating a new chart from the scratch.
- Working with different types of charts and their applications.
- Changing chart type.
- Chart designing options
- Project 1
- Project related to data analysis based on the subjects studied above.
- Project 2
- Project related to charting based on the subjects studied above
Skill Level:
Beginner
Materials:
All materials will be provided
Validity Period:
All sessions are valid for 45 days upon booking
Age Requirements:
10 and older
Additional Info:
- Certificate of participation will be awarded upon completion
- Optional KHDA certificate can be awarded with an additional fee payable directly to the instructor
- This course can also be taken online
Location:
At instructor's home (address provided after booking)
Cedre Villas
Dubai Silicon Oasis
Dubai