top of page

Excel- Slice &  Dice Data

Filters

Learn how to use filters to display only the records that meet criteria that you specify and hides rows that you do not want displayed.

Slicers

Slicers contain a set of buttons which help you quickly filter the data in a spreadsheet, without the need to open drop-down lists to find the items that you want to filter.

Data Validation

Data validation can be used to define restrictions on what data can or should be entered in a cell. 

SQL- Introduction to Oracle

Example of SQL Application using Oracle DBMS

The following video will walk you through how SQL queries are written in Oracle. This will give you a feel for how SQL is used with an Oracle database which is one of the most popular DBMS's used in organizations. Don't worry about installing any software now. For the time being we will provide you online tools to practice queries. Once you get comfortable with writing queries, we will walk you through installation.

Data in Action

bottom of page