Welcome to PR Computer Academy, we have over 07 years of expertise
PR Computer
301, 3rd Floor, Shreenath Complex,
Nr. 17-22 Bus Stop, Sector-22,
Gandhinagar-382022
C-239, 2nd Floor,
Pramukh Mastana Complex,
Kudasan, Gandhinagar-382421
+91 9998126282
prcomputeracademy@gmail.com
Home
About us
Our Course
Latest News
Notable Alumni
Software
Contact us
CCE Pre Test
PR Computer
Home
About us
Our Course
Latest News
Notable Alumni
Software
Contact us
CCE Pre Test
Course Details
Home
Course Details
ADVANCE EXCEL
Admin
30 March 2023, 04:25 PM
Advance
Excel
File, Home, Insert, Page Layout, Formulas, Data, Review, and View all Menu Use
Spreadsheet Creation, Mark Sheet & Salary Sheet
Fourmula
Basic formula
Vlookup-Hlookup
Sum, Sumif, Sumifs
Round, Roundup, Mround, INT
Count, Countif, Countifs
RATE, PV, NPER
PMT, PPMT, IPMT,
IF, AND, OR
Paste Special, Go To Special
Coustom Number Formatting, coustom list, Conditional Formatting
Pivot Table, Pivot chart
Advance page Setup
Sort & filter, Advance Filter, Data Validation, Goal Seek, Scenario manager
Sheet and Worksheet Protection
Freeze Panal and Macros