Learn Advance Excel
Advance Excel Syllabus
1)What is a Spreadsheet?
2)Excel Rows and Columns
3) Cell and Cell Addressing
4)Data Types
5)Enter Text and numbers in a cell
6)How to edit text in a cell
7) Content alignments
8)Font formatting in Excel
9)How to change the color of a cell
10) How to save your work in excel
11) Currency symbols in excel
12) How to merge cells
1) How to use Auto fill in excel
2) Copy Paste of Data3) Paste Special Feature
4) Inserting, Deleting and Formatting Rows/Columns
5) Cell Styles
6) Copy and Paste
7) How to use Paste Special
8) Basic Calculations in Excel
1) Working with Tables
2) Inserting and using Pictures
3) How to use Clip Art Feature
4) Working with Shapes
5) SmartArts and Uses
6) Hyperlinks
7) Word Arts
8) Symbols
1) What is Chart
2) Type of Excel Charts
3) Understanding Relation between charts and Data
4) How to Select Appropriate Chart Type
5) Create an Excel Chart
6) Dealing With Data Series
7) Moving and Resizing of Charts
8) Chart Styles and Layouts
9) Chart Titles and Series
10) Use Labels in Charts
1) Page Setup in Excel
2) Understanding Printing Schemes
3) Printing Areas
4) Excel Views
5) Type of Excel Charts
1) Introduction to functions
2) Understanding Implementations of functions
3) SUM Function
4) PRODUCT Function
5) Subtraction and Division in Excel
6) AVERAGE Function
7) MAX Function
8) MIN Function
9) ABS Function
10) FACT Function
11) SQRT Function
12) MOD Function
13) ROUNDUP Function
14) ROUNDDOWN Function
15) ROUND Function
16) COUNT Function
17) COUNTBLANK Function
1) DAY Function
2) MONTH Function
3) YEAR Function Function
4) NOW Function Function
5) TODAY Function
6) DATEDIF Function
7) INT Function
8) POWER Function
9) UPPER Function
10) LOWER Function
11) LEFT Function
12) RIGHT Function
13) LEN Function
14) CONCATENATE Function
15) PROPER Function
16) TRIM Function
1) IF Function
2) COUNTIF Function
3) SUMIF Function
4) VLOOKUP Function
5) HLOOKUP Function
6) MATCH Function
7) INDEX Function
8) Pivot Table in Excel
9) Object Linking and Embedding
1) Data Validation Rules
2) Deal with Data Duplicates
3) Arrange Data from text to columns
4) Named Cell Ranges in Excel
5) Data Grouping
6) Data Subtotaling
7) Use Conditional Formatting
8) Data Consolidation
9) Using Comments
10) Security Options
1) Create Mark sheets in Excel
2) Create Sales Data in Excel
3) Create Salary Structure in Excel
4) Exercise of Text Functions
5) Exercise of Date and time Functions
6) Exercise of Sumif and Countif Functions
7) Create Invoice in Excel
8)Exercise of Lookup Functions
Enquiry form
Our Selected Students
Introduction And Basic Brush-Up Of MS Excel And Excel Back-End Opetions:
⇒ Start-up with MS Excel, Quick review on MS Excel Customize Ribbon, Quick Access Toolbar, Mini Toolbar.
⇒ Difference between Excel 2003and 2007and 2010. Saving of Old version MS Excel 1999 and 2003 files to new excel version MS excel 2007 and 2010.
⇒ Conversion of Excel files to PDF.
⇒ Introduction of Excel shortcut keys: Chart will be provided by Advanced Excel.
⇒ Introduction to Excel Worksheet, Row, Column, Cells etc.
⇒ Detailed discussion on Excel design, Back-End working structure and Excel Options.
⇒ Use of Basic Operators Like: + – / * ^ %.
⇒ Introduction to the Data and Data Formats.
⇒ Copy, Cut, Paste, Hide, Unhide, Link the Data in Rows, Columns and Sheet.
⇒ Inserting, Deleting, Moving, and linking the data in between the multiple sheets.
एडवांस एक्सेल सीखने के बाद एक बेहतरीन कंप्यूटर ऑपरेटर बनजाएंगे और एक बेहतरीन
जॉब मिलेगी अच्छी सैलरी के साथ (कम से कम फीस में एडमिशन लेकर ज्वाइन करें )
Enroll Now - Offer Ends in
cpct full details in hindi&english
सीपीसीटी क्या है CPCT Madhya Pradesh (MP) की एक बहुत...