#203 Manzeera Plaza ameerpet,Opp:Aditya Trade Centre @voice :9989 3500 24

EXCELGENIUSES

ADVANCEEXCEL

Excel (2007/10/13)

Introduction To MS- EXCEL Uses Of Excel Basics Of Excel Sheet Views Of Excel Sheet FunctionsIn Excel

1. Date &Time 2. Text 3. Information 4. Logical 5. Mathematical&Engineering 6. Statistical 7. Financial 8. Lookups

Home Menu: o Font Setting o Conditional Formatting, o Table Creation o Cell Styles o Fill Series o Data Clearing Styles o Merging & Wrap Text o Number Formats o Format Painter o Paste Special o Text Orientation

Insert Menu: o Pivot Table & Charts o Charts(Creatation,Merging,Scaling) o Combo Charts o Spark lines & slicer o screenshots o Notes Board Creation o Draw The Shapes o Create The Classification Diagrams(Smart Arts)

Complete Excel for Reporting

Faculty :NagarajuBezawada(ExcelRaju) Exp : 6+yrs Duration : 30 Days Class time : 1 Hours Lab Time : Unlimited New Batch : Every Monday Tracks : Norman/fast/weekends/online Material :5 GB softcopy for Ref Fee :Rs 3500/-

Excel Dashboards

#203 Manzeera Plaza ameerpet,Opp:Aditya Trade Centre @voice :9989 3500 24

o Content Menu Creatation By Using Hyperlinks o difference between hyperlink and object o Header &Footer

page layout: o set margins o excel sheet orientation o sheet size o printing selected area in the sheet o printing repeated row or column for more sheets o selection panel

Formulas: o What Is The Naming Of The Range, How To Use It. o Name Manager o Excel Sheet Orientation o Formula Auditing o Other Use Full Formulas

Data:*** o How Connect With External Data Base o How To Update Automatically Database o Filter And Adv Filters o Sorting o Text To Columns o Remove Duplications o Data Validation

Pre-Defined

Custom Validations o Working With More Sheets(Consolidation) o What -If-Analysis(Goal Seek,ScenarioManager,Data Table) o Group ,Ungroup & Sub Total

Review & View: o Security To The Book, Sheet& Cells o Spelling &Comments o Sharing The Book To Others o Track Changes s o Freezing o Macro Recording& Basic Editing Tips

#203 Manzeera Plaza ameerpet,Opp:Aditya Trade Centre @voice :9989 3500 24

Extra:***(for working professionals)

o Office Button New Features o Introduction of the online reporting tools(Zoho,ducksboards) o Working With Excel Templates o Creating Excel Templates o What is Add-ins,How To Add Pre Add-Ins To Excel o How To Add New Add-Ins To Excel (ASAP,Kutools,powerpivot&Pdf...)

o Custom Number Formats o Converting Excel To Pdf,Pdf To Excel ,Excel To Word......) o Dash Boards o MIS o Data Analysis(Statistical Report)

Power BI o Power pivot o KPI o Other BI Tools

#203 Manzeera Plaza ameerpet,Opp:Aditya Trade Centre @voice :9989 3500 24

Hi Dears,

Greetings from EXCELGENIUSES !!!

EXCELGENIUSES Invites you to attend

Advanced Excel 2013 And Macros (VBA) with Power

BIINTEGRATION Training Demo.

Attend Free Classroom/Online Demo On

Advanced Excel 2013 And Macros (VBA)with Power BI

NOTE: If you are interested For Demo Or NEW BATCH, Please Register

With Us:

Voice :9989350024

Trainer Name :Nagaraju B

Web :www.excelgeniuses.com

@ :rajuraju.net@gmail.com,info@excelgeniuses.com

Facebook :www.facebook.com/excelraju

Video :#203 MazjeeraPlaza,Ameerpet,Hyderabad,

Opp:Aditya Trade Centre-500016.

Kindly Refer to your friends who are looking for Advanced

Excel 2013 And Macros (VBA) with Power BI

Why We Are The Best?

Go through the student reviews about EXCELGENIUSES on sulekha,justdail and thinkvidya

websites.

Thanks & Regards

EXCELGENIUSES

Communication