Microsoft Excel Expert

MO-201:Microsoft Excel Expert you demonstrate your ability to apply the main features of Excel 2019 at an expert-level, such as creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations. Expert workbook examples include: Custom Business Templates, Multiple-axis Financial Charts, Amortization Tables, Inventory Schedules

1. Import data into workbooks

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

2. Navigate within workbooks

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

3. Format worksheets and workbooks

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

4. Customize options and views

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

5. Configure content for collaboration

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

6. Manipulate data in worksheets

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

7. Format cells and ranges

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

8. Define and reference named ranges

Define a named range
Name a table

9. Summarize data visually

Insert Sparklines
Apply built-in conditional formatting
Remove conditional formatting

10. Create and format tables

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

11. Modify tables

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

12. Filter and sort table data

Filter records
Sort data by multiple columns

13. Insert references

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

14. Manage charts

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

Fees Structure :	6500 INR / 80 USD
Total No of Class :	60 Video Class
Class Duration :	22:30 Working Hours
Download Feature :	Download Avalable
Technical Support :	Call / Whatsapp : +91 8680961847
Working Hours :	Monday to Firday 9 AM to 6 PM
Payment Mode :	Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure Buy Now Sample Demo

Fees Structure :	10000 INR / 120 USD
Class Duration :	30 Days
Class Recording :	Live Class Recording available
Class Time :	Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support :	Call / Whatsapp : +91 8680961847
Working Hours :	Monday to Firday 9 AM to 6 PM
Payment Mode :	Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure Pay Online