Course Details

  • Home
  • Course Details

Microsoft Excel

Avinash Karnani

4.5 

  • Overview
  • Curriculum
  • Certificates

Requirements

  •   The only prerequisite is that you have access to Excel 2019 and the willingness to complete the exercises and practice tests.
  •   Please note that MOS exams are all Windows based. This course uses Excel in a Windows environment. Apple Mac users should note that there are differences between the Windows and Mac versions of Excel

What You'll Learn

  •   How to successfully pass the MO-200 Microsoft Certified Excel Associate Exam
  •   Be confident and competent in your use of Microsoft Excel for everyday business use
  •   Be ready to begin to study to become a certified Microsoft Office Specialist Associate in Excel 2019

Who this Course is for

  •   Students who are either total beginners with Microsoft Excel or who are intermediate users who want to obtain certification in Core Excel
  •   Existing users of Excel who want to learn how to pass the MO-200 exam and obtain official certification for their skills.
  •   Existing users of Excel who want to have access to the type of exercises which will ensure they will pass the Microsoft Office Specialist Associate Certification in Excel 2019
  •   Graduates seeking to gain professional qualifications

• Import data from .txt files
• Import data from .csv files

• Search for data within a workbook
• Navigate to named cells, ranges, or workbook elements
• Insert and remove hyperlinks

• Modify page setup
• Adjust row height and column width
• Customize headers and footers

• Customize the Quick Access toolbar
• Display and modify workbook content in different views
• Freeze worksheet rows and columns
• Change window views
• Modify basic workbook properties
• Display formulas

• Set a print area
• Save workbooks in alternative file formats
• Configure print settings
• Inspect workbooks for issues

• Paste data by using special paste options
• Fill cells by using Auto Fill
• Insert and delete multiple columns or rows
• Insert and delete cells

• Merge and unmerge cells
• Modify cell alignment, orientation, and indentation
• Format cells by using Format Painter
• Wrap text within cells
• Apply number formats
• Apply cell formats from the Format Cells dialog box
• Apply cell styles
• Clear cell formatting

• Define a named range
• Name a table

• Insert Sparklines
• Apply built-in conditional formatting
• Remove conditional formatting

• Create Excel tables from cell ranges
• Apply table styles
• Convert tables to cell ranges

• Add or remove table rows and columns
• Configure table style options
• Insert and configure total rows

• Filter records
• Sort data by multiple columns

• Insert relative, absolute, and mixed references
• Reference named ranges and named tables in formulas

• Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
• Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
• Perform conditional operations by using the IF() function

• Format text by using RIGHT(), LEFT(), and MID() functions
• Format text by using UPPER(), LOWER(), and LEN() functions
• Format text by using the CONCAT() and TEXTJOIN() functions

• Create charts
• Create chart sheets

• Add data series to charts
• Switch between rows and columns in source data
• Add and modify chart elements

• Apply chart layouts
• Apply chart styles
• Add alternative text to charts for accessibility

₹2,859
  • Mentor : Avinash Karnani
  • Level : Intermediate
  • Category : Productivity
  • Format : Hybrid
  • Avail 25% discount before 10th Sept 2023!!!
Join Course
Share This :

Have Any Question?

  • khargym@skillspark.org