Logo of The ProTec Professional Training Institute
The Protec is registered with STEVTA and Affiliated with TTB Sindh

Advance Excel

Get the best Online training of Advance Excel

Advance Excel Online Course Detail


Advance Excel offered at The Protec Computer Institute Naval Colony Karachi.

Curriculum


The ProTec Offers Advance Excel course
  1. Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
  2. Saving Excel File as PDF, CSV and Older versions
  3. Using Excel Shortcuts with Full List of Shortcuts
  4. Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet Using Paste Special Options
  5. Formatting Cells, Rows, Columns and Sheets
  6. Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
  7. Page Layout and Printer Properties
  8. Inserting Pictures and other objects in Worksheets
  1. Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc
  2. Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
  3. Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc
  4. Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc
  5. Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc
  6. Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc
  7. Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF, FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc
  8. Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc
  1. Using Conditional Formatting
  2. Using Conditional Formatting with Multiple Cell Rules
  3. Using Color Scales and Icon Sets in Conditional Formatting
  4. Creating New Rules and Managing Existing Rules
  1. Sorting Data A-Z and Z-A
  2. Using Filters to Sort Data
  3. Advance Filtering Options
  1. Creating Pivot Tables
  2. Using Pivot Table Options
  3. Changing and Updating Data Range
  4. Formatting Pivot Table and Making Dynamic Pivot Tables
  1. Creating Pivot Charts
  2. Types of Pivot Charts and Their Usage
  3. Formatting Pivot Charts and Making Dynamic Pivot Charts
  1. Advanced Filtering
  2. Data validation
  3. Consolidation
  4. Groups
  5. Subtotal
  1. What is Excel Macro?
  2. How to Record / Run Excel Macro?
  3. How Add Developer’s Tab in Excel 2013 / 2016
  4. How to add different types of controls like Text Box, Radio button, button etc. in Excel
  1. Visual Basic Editor in Excel
  2. VBA Control Property
  3. How to write Excel Macro
  4. Excel Macro Tutorial: Excel User Form
  5. Combo Box / Drop Down List in Excel
  6. List Box in Excel
  7. User forms
  8. Excel Macros, Excel Terms, Macro comments
  9. What is difference between CELLS () and RANGE ()
  10. How to Open Excel Workbook using Excel Macro
  1. Introduction to SQL
  2. SQL SELECT Statements
  3. Manipulating Data (Insert, Delete, Update)
  4. SQL DDL Statements (Create, Alter, Drop)
  5. Restricting and Sorting Data

Courses you may like


Coding for Kids

Coding for Kids

Duration: 3 Month(s)

View Course
Computer Basics

Computer Basics

Duration: 3 Month(s)

View Course
Foundation Maths

Foundation Maths

Duration: 2 Month(s)

View Course

ALL ONLINE COURSES


Leave a Message
0