Everything About Advance Excel

data_validation goal macros subtotal pivote vlookup consolidate text_to_columns conditional ole chart data_filterning manymore

contact us


Get in touch with us ......
If issues are related with following Topics

Advance Excel : 

vlookup - hlookup - lookup vector - pivot table - connections of workbooks - get external data -
data validation - consolidations - use of 3D formula - data table - goal seek - data table - scenario manager to forecast budget - subtotal  and sum if formula - flash fill - advance filter - protection of cell , sheet and workbook , macros , print setup - use of text to column, formula auditing , name manager- conditional formatting - transpose - GST billing - payroll working - paste special  - object link embedding - fill series - print settings ......and many more

Microsoft word : 

Document presentation - column wise writing - Table of Content - Mail Merge - Envelope and Label printing - letter writing - drop cap - watermark -  page border and shading - Object linking - use of track changes -  use of book marks - building block organizer - document editing and enhancement
and many more

Advance Tally Erp : 

cheque printing setup - GST auto billing using voucher class - price level - TDS working - Service tax billing - Ledger scrutiny and complete finalization - Reports preparation like Trading , Profit and loss accounts and balance sheet , outstanding and A TO Z reports preparation ( due date wise )- Various Stock programming - Manufacturing voucher WIP - Group and ledger Indexing - Tally ODBC - Tally's Data in excel - budget preparation - get exception reports and scenario management - solution if forget security password -  Bank and Branches & Stock reconciliation  - use of physical stock / memorandum / optional / post dated / reversing journal vouchers - shortcuts techniques...and many more 

Get in touch with us by filling out the form below.

Name
Email *
Message *

””