1-on-1 Microsoft Excel Training for Beginners (DSO)

1-on-1 Microsoft Excel Training for Beginners (DSO)

by Jupiter Training & Consulting

380 AED

(VAT inclusive)

1-on-1 Microsoft Excel Training for Beginners (DSO)

380 AED

(VAT inclusive)

by:
when:
Flexible Dates
where:
Dubai - Dubai Silicon Oasis
level:
Beginner
Validity Period: All sessions are valid for 45 days upon booking
We offer a best price guarantee for our classes. If you get a better price, let us know & we'll give you a free AED 100 voucher.
Description:

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

Register for the class
Schedule
# Sessions
Price
Click here for schedule information

Each session takes 2 hours

After booking this class you will be contacted by the instructor to set your schedule as per your availability.

Instructor's working hours
SunMonTueWedThuFriSat
9:00AM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
9:00AM
To
9:00PM
Share this class:

Categories