Advanced Excel

 

About this course
       Excel and Advance Excel

 

What you'll learn

Advanced Excel

Working with Styles & Formatting

  • Cell Styles

  • Creating lists using Table

  • Formatting the structure of a list

  • Advanced Conditional Formatting

  • Working with different option of conditional formatting

 

Working with Range Names

  • Defying a range name

  • Defying the scope of a range name

  • Modifying/deleting the range name

 

Data Validations

  • Specifying a valid range of values for a cell

  • Specifying a list of valid values for a cell

  • Specifying custom validations based on formula for a cell

  • Using dynamic range name in validation

Charting

  • Add a Chart to an Excel Spreadsheet

  • Add, Remove and Format Gridlines

  • Apply a Chart Layout, Chart Style

  • Format an Axis

  • Change the Axis Scale

  • Format the Data Series

Working with Pivot tables

  • Creating subtotals

  • Multiple-level subtotals

  • Creating Pivot tables

  • Formatting and customizing Pivot tables

  • Using advanced options of Pivot tables

  • Creating group in Pivot tables

  • Pivot charts

  • Create a standalone Pivot Chart

Dashboard

  • Creating Dashboard

  • Using Timeline, Charts, Slicer and Sparkline.

Course Details
 
  • Duration:  hours

  • hours effort:  8 hours per week

  • Price With GST: 5000/-

  • Subject: 

  • Level: 

Prerequisites​

Marathahalli Office:

Real Time Signals Technologies Private Limited

#102, Krishna Grand, Over Marathahalli Bridge,

Bangalore, Karnataka, India 560037

BTM office:

Real Time Signals Technologies Private Limited,

#4, 2nd Floor, 1st phase, 2nd Stage, BTM Layout,

Opposite to Udupi Garden,

Bangalore-76, bengaluru, Karnataka, 560076

Whitefield office:

Real Time Signals Technologies Private Limited,

#1906, Brigade Metropolis,

Mahadevpura,

Bengaluru, Karnataka, 560048

Belgium Europe office:

Real Time Signals Technologies,

Hemelstraat 42, 2018 Antwerpen

Belgium, Europe

Thane Office:

Real Time Signals Technologies Private Limited,

#202, GARDEN ENCLAVES BLDG NO1,

VASANT VIHAR,

THANE 400607, MAHARASHTRA, India 

 

 © 2014-2018 by Real Time Signals Technologies. All Rights Reserved.