Categories
- Pharmacy
- Nursing
-
MBA
-
BBA
- U.P. State University
- Veer Bahadur Singh Purvanchal University, Jaunpur
- Chaudhary Charan Singh University, Meerut
- Dr. Bhimrao Ambedkar University, Agra
- Chhatrapati Shahu Ji Maharaj University, Kanpur
- Mahatma Jyotiba Phule Rohilkhand University, Bareilly
- Mahatma Gandhi Kashi Vidyapith, Varanasi
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Deen Dayal Upadhyaya Gorakhpur University
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj
- BCA
-
B Ed
- Lucknow University B.Ed Books
- Chaudhary Charan Singh University/Maa Shakambhari University, Saharanpur
- Dr Bhim Rao Ambedkar University, Agra
- Mahatma Gandhi Kashi Vidyapeeth, Varanasi
- Chhatrapati Shahu Ji Maharaj University
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj (PRSU)
- Mahatma Jyotiba Phule Rohilkhand University(Mjpru), Bareilly
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Bundelkhand University, Jhansi
- Deen Dayal Upadhyaya Gorakhpur University
- Veer Bahadur Purvanchal University (VBPU)
- Maharaja Suhel Dev State University ,Azamgarh (MSDSU)
- Raja Mahendra Pratap Singh State University, Aligarh (RMPSSU)
- Barkatullah Vishwavidyalaya (Bhopal)
- Jiwaji University (Gwalior)
- Vikram University (Ujjain)
- Dr. Harisingh Gour University (Sagar)
- Devi Ahilya Vishwavidyalaya (Indore)
- Rani Durgavati Vishwavidyalaya (Jabalpur)
- Awadhesh Pratap Singh University (Rewa)
- Maharaja Chhatrasal Bundelkhand University (Chhatarpur)
- D. EL. ED
- TET
-
B Com
-
B Sc
- B.Sc. U.P. State Universities Common Syllabus NEP
- Veer Bahadur Singh Purvanchal University, Jaunpur
- University of Lucknow
- Chaudhary Charan Singh University, Meerut
- Madhya Pradesh
- Chhatrapati Shahu Ji Maharaj University, Kanpur
- Dr. Bhimrao Ambedkar University, Agra
- Mahatma Gandhi Kashi Vidyapith, Varanasi
- DEEN DAYAL UPADHYAYA GORAKHPUR UNIVERSITY
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Mahatma Jyotiba Phule Rohilkhand University, Bareilly
- Uttarakhand State Universities
- B.Sc. Bihar Universities Common Syllabus NEP
- University of Rajasthan (Jaipur)
- Haryana
-
B A
- B.A. Of U.P. State Universities Common Syllabus NEP
- Veer Bahadur Singh Purvanchal University, Jaunpur
- University of Lucknow
- Chaudhary Charan Singh University, Meerut
- Chhatrapati Shahu Ji Maharaj University, Kanpur
- Dr. Bhimrao Ambedkar University, Agra
- Mahatma Gandhi Kashi Vidyapith, Varanasi
- Deen Dayal Upadhyaya Gorakhpur University
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Mahatma Jyotiba Phule Rohilkhand University, Bareilly
- Madhya Pradesh
- Uttarakhand
- Bihar
- University of Rajasthan (Jaipur Syllabus as Per NEP2020)
- Haryana NEP-2020
- B Tech
Basics Of Ms Excel
₹150.00
Tax excluded
ISBN - 978-93-5480-621-6
Authors - Dr. Anup K. Suchak , Ms. Rupali Wagmare
Syllabus
1T4-A: Basics of MS Excel
Unit I
Introduction to Excel – About Excel, Features of MS-Excel, The Excel Environment; Quick Access Toolbar, Title Bar, Ribbon Tabs, Name Box, Formula Bar, Scroll Bars, Status Bar, Page Views, Zoom Tool. Ribbon Display Options Button, Excel Workspace, Cells. Creating Worksheets and Workbooks – Creating and Renaming Worksheets, Saving Workbook, Copying and Moving a Worksheet. Inserting and Deleting Rows and Columns, Inserting Header and Footer in a Worksheet.
Formatting Cells; Selecting Cells, Entering Text and Numeric Data into the Cells, Applying Fonts and Background Colour, Aligning Data, Merging Cells, Text Wrapping, Number Formatting – Text, Percentage, Currency, Dates. Creating Series, Resizing Columns Width and Rows Height. Excel Shortcuts – Using Keyboard Shortcuts
Unit II
Excel Formulas and Functions – Performing Basic Mathematical Operations using Formula, Applying Formulas using Cell Names and Range, Formatting Text using Different Text Functions, Performing Calculation using Numerical and Mathematical Functions. If Function, Logical Functions-AND, OR, NOT.
Tables - Creating a Table, Applying Styles to Tables, Adding and Editing Records, Inserting Records and Fields, Deleting Records and Fields.
Unit III
Filters, Grouping and Charts in Excel- Filtering Records, Sorting Data by Single and Multiple Columns, Custom Sort, Changing Sort Order, Eliminating Duplicate Records.
Chart Preparation – Creating Charts, Selecting Charts and Chart Elements, Moving and Resizing Charts, Changing the Chart Type. Apply Custom Data Formats and Layouts- Changing the Data Range, Switching Column and Row Data, Choosing a Chart Layout, Choosing a Chart Style, Printing Charts, Deleting Charts, Applying Word Art Styles to Chart Elements.
Unit IV
Introduction to Pivot Tables- Creating Pivot Tables and Pivot Charts, Manipulating a PivotTable, Changing Calculated Value Fields, Applying PivotTable Styles, Creating a PivotChart, Setting PivotTable Options.
RTMNU2018/BBA/1/03
50 Items
New product