Knowledge excel

Utilize the Excel Password Recovery Software by eSoftTools that can effortlessly reset and recover the password from the Excel Workbook with Excel Worksheet. It includes 3 recovery methods, that are, Dictionary attack, Mask attack, and Brute Force attack. It suitable to work with all Windows OS versions and is competent with all the MS Excel Extensions (.xlsx,.xlsm,.xls,.xlsb,.xla,.xlam). No requirement of technical knowledge to utilize this software as the GUI of this software is user-friendly. A Trial version is given to every user that can easily recover the first 3 letters of the Excel password without any cost.

The most essential thing to consider during the hiring process of excel executive is to check how much hands-on experience he or she is having in Advanced MS Excel Course in Gurgaon from SLA Consultants Gurgaon. An Excel should have an in-depth knowledge and practical experiencing in Management Information System of any reputed business organization. Excel should have the basic knowledge of mathematical functions, logical functions, reference functions, and database management tools. To get more details visit at https://slaconsultantsgurgaon.in/training-institute-advanced -excel-course/ Course Content Module 1 - Basic and Advanced Excel Certification 1. Introduction to Excel 2. Mathematical Functions in Advanced Excel 3. Date and Time Function in Advanced Excel 4. Text Functions and Data Validation in Advanced Excel 5. Statistical Function and Other Functions in Advanced Excel 6. Logical Functions in Advanced Excel 7. Lookup and Reference Functions in Advanced Excel 8. Power Pivot- MIS, Data Analysis and Visualization 9. Data Collection Method in Advanced Excel 10. Analysis Single/Multidimensional Analysis in Advanced Excel 11. Advanced Dashboard in Excel 12. Two Live Report Development in Advanced Excel Free Any One (Basic SAS/R Programing /Tableau /Power BI) Basic SAS R Programming Basic Tableau MS Power BI Contact Us: SLA Consultants Gurgaon 3rd Floor, Gourav Plaza, DLF Phase - 2 Sikanderpur, Gurgaon - 122002 Call +91-9560126889 E-Mail:- training@slaconsultantsindia.com Website:- https://slaconsultantsgurgaon.in/

No.1 Best Excel Course in New Delhi NCR are undoubtedly important for those who want a corporate job as a data analyst, Then Join best Institute SLA Consultants India. This Advanced Excel Institute also helps the participants to become an MIS expert with adequate knowledge and expertise of advanced excel To get more details visit at https://www.slaconsultantsindia.com/institute-advanced-excel -training-course.aspx Course Content Module 1 - Basic and Advanced Excel Certification 1. Introduction to Excel 2. Mathematical Functions in Advanced Excel 3. Date and Time Function in Advanced Excel 4. Text Functions and Data Validation in Advanced Excel 5. Statistical Function and Other Functions in Advanced Excel 6. Logical Functions in Advanced Excel 7. Lookup and Reference Functions in Advanced Excel 8. Power Pivot- MIS, Data Analysis and Visualization 9. Data Collection Method in Advanced Excel 10. Analysis Single/Multidimensional Analysis in Advanced Excel 11. Advanced Dashboard in Excel 12. Two Live Report Development in Advanced Excel Free Any One (Basic SAS/R Programing /Tableau /Power BI) Basic SAS R Programming Basic Tableau MS Power BI CONTACT US: SLA Consultants India 82-83, 3rd Floor, Vijay Block, Above Titan Eye Shop, Metro Pillar No 52 Laxmi Nagar, New Delhi, 110092 Call:+91-9560126889 Email:- training@slaconsultantsindia.com Website:- https://www.slaconsultantsindia.com/

Advanced Excel is individual proprietorship establishment which is originated by SOL Technologies Solutions (Excel and VBA Professionalism). We are the leading professional Institute with the specialization in Advanced Excel and VBA Macros. Our institute portfolio encompasses the Advanced Excel and VBA training for Individual, Group and Corporate Interventions and Excel & Macros Corporate Trainings, Advanced Excel Institute in Delhi has trained 10000+ working professionals on same topic Advanced Excel & VBA Macros. We are Excel training Institute who has done multiple batches for Excel Training in Delhi. We are truly devoted to our students to groom their knowledge in Excel and VBA and help them to reach on the top of the ladder. Further More Information about Advanced Excel Training Institute in Delhi, NCR So Visit Us. https://simplyonlinelearn.com/advanced-excel-training-course

We are Excel training Institute who has done multiple batches for Advanced Excel Training Institute in Delhi. We are truly devoted to our students to groom their knowledge in Excel and VBA and help them to reach on the top of the ladder. Advanced Excel Institute is the excel tutorial where you can find the solutions of all your Excel and VBA related problems. We are Microsoft Authorized Testing Centre where we provide the training on all the topics of Excel and VBA Macros. Further More Details about Advanced Excel Training Institute in Delhi So Contact us-+91-9311002620 Or Visit Website- https://www.htsindia.com/Courses/business-analytics/adv-excel-training-course

We are Excel training Institute who has done multiple batches for Excel Training in Delhi, India. We are truly devoted to our students to groom their knowledge in Excel and VBA and help them to reach on the top of the ladder. Advanced Excel Institute is the excel tutorial where you can find the solutions of all your Excel and VBA related problems. We are Microsoft Authorized Testing Centre where we provide the training on all the topics of Excel and VBA Macros. Our main focus areas are Strong Advanced Excel Formula writing skills, Strong Advanced Dashboard Presentation Skills, Strong VBA Macros Skills. Further More Information Here- 9311002620 or Visit Website- https://www.htsindia.com/Courses/business-analytics/adv-excel-training-course

Advanced Excel is the most powerful tool which is used in every small and medium enterprise. The Advanced ms excel training in gurugram will reveal many tricks and shortcuts to the Employees who can use and apply to the best knowledge in their current jobs. SLA Consultants Gurgaon is a leading training and development institute that provides the best advanced excel course in Gurgaon as per industry needs that is considered the best to increase the performance of the employees. With the help of Advanced Excel classes in Gurgaon provided to the employees of the company and the students who want to make they are the field, by this, they will be able to perform numerous technical functions such as tracking requests, developing charts and tables, generating reports, complex data analysis, and calculations, etc. Thus, it is necessary for aspiring candidates to learn and master the techniques of Advanced excel. For more details visit at https://slaconsultantsgurgaon.in/training-institute-advanced -excel-course/ Course Content Module 1 - Basic & Advance Excel Module 2 - Macros | VBA & Dashboard Module 3 - MS Access & SQL Module 4 - Tableau / MS Power BI/SAS Base & Advanced (Free Any One) Module 5 - Basic SAS Module 6 - Basic Tableau Module 7 - R Programming Module 8 - MS Power BI Contact Us: SLA Consultants gurgaon 3rd Floor, Gourav Plaza, DLF Phase - 2 Sikanderpur, Metro Pillar No 50 Gurgaon, Haryana, 122002 Call: +91-9999491895 / +91-9069663742 Email:- training@slaconsultantsindia.com

Advanced knowledge of Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks. The way Excel is used depends on the needs and duties of specific departments or job roles. Advanced Excel is quite different from Basic Excel, the focus for the user is more on DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros. Some of the other important concepts to explore while working on Advanced Excel are: If Statements. Sum Products.

High Technologies Solutions offers you the best advanced excel course which helps you to know about the all concepts of excel and to be a data analyst We have highly experienced trainers for Advance Excel courses. The Module of High Technologies Solutions is so simple and compressive that includes complete knowledge of Excel beginning to Advance.contact here +91-9311002620 visit https://www.htsindia.com/Courses/business-analytics/adv-excel-training-course

At High Technologies Solutions, students are given the best way of learning and understanding concepts of Advance Excel. We have highly qualified trainers for Advance Excel courses. The Module of High Technologies Solutions is so simple and compressive that includes complete knowledge of Excel beginning to Advance. Students get numerous assignments and live session for enhancing their Excel skills.contact here +91-9311002620 visit https://www.htsindia.com/Courses/business-analytics/adv-excel-training-course

At High Technologies Solutions, students are given the best way of learning and understanding concepts of Advance Excel. We have highly qualified trainers for Advance Excel courses. The Module of High Technologies Solutions is so simple and compressive that includes complete knowledge of Excel beginning to Advance. Students get numerous assignments and live session for enhancing their Excel skills.contact here +91-9311002620

HTS institute provides you the advanced excel course with 100% placement and improves your data analysis skills We have highly skillful trainers for Advance Excel courses. The Module of High Technologies Solutions is so simple and compressive that includes complete knowledge of Excel beginning to Advance.contact here +91-9311002620 visit https://www.htsindia.com/Courses/business-analytics/adv-excel-training-course

High Technologies Solutions offers you the course and that is advanced excel in Delhi. We surely have so much for you to make you best in data analysis.We have highly skillful trainers for Advance Excel courses. The Module of High Technologies Solutions is so simple and compressive that includes complete knowledge of Excel beginning to Advance.contact here +91-9311002620 visit https://www.htsindia.com/Courses/business-analytics/adv-excel-training-course

Best Advanced excel institute in Delhi/Noida is High Technologies Soloutions which provides best advanced excel training. All the trainers have 5+ years experience in their fields. HTS focus more on practical knowledge than theory which makes training sessions more interesting.HTS provides 100% placement help. Join now!! Call at +919311002620 or visit our website. http://www.htsindia.com/Courses/business-analytics/adv-excel-training-course

Male Accounts executive with basic knowledge of tally and excel and billing

We are looking for candidates for data entry. For more details contact us on the contact number or through E-mail. The knowledge of MS word and MS excel is required.

Required Office Assistant, knowledge in ms word who can make MIS reports with good hand in typing. salary: 9000 to 10000INR. timing: 10am to 6:15pm. ONLY FOR FEMALE. office situated in gomtinagar(lucknow).

#Required #Branding #Executive with Knowledge of #Hoding and #Branding PPT Excel Vlookup Location Chandigarh Min 1-2 Yrs Exp. Qualification Min. Graduation Salary CTC 25k Address:- A.K. Job Solution Sco 87,88 First Floor Sector 34 A Chandigarh Contact Us:- 9041835968

diploma net working and computer technology ms word excel software development company using this technology to make information and data available on any device at any time and something that can be accessed at any time. This technology is used to develop both desktop applications and web-based solutions.

We compile business intelligence, marketing goals, brand vision, and product knowledge to provide all of the above execution plans tailored to your needs. Whether you are a startup or have already gone public, we have a growth plan for everyone. We Counsel You,We do Product-Market Fit Survey,We do Business Health Analysis,We Plan Conversion Optimization,We Create a Roadmap and much more... We believe in:- “SUCCESS IS 20% SKILLS AND 80% STRATEGY. YOU MIGHT KNOW HOW TO SUCCEED, BUT MORE IMPORTANTLY, WHAT'S YOUR PLAN TO SUCCEED?” For more information visit: adriders.biz/services/online-strategy-examples/

Preparing MIS Report Keeping the records Keeping the sales reports Generating various reports Preparing Daily, weekly and Monthly reports. Develop reports, analyze and review reports formulas like V-Lookup, H- Look Up, Pivot, For Any Queries please contact Our HR Department On 70441/14428 For More details Or Send Your Resume In hr.brightstars@gmail.com

Skills: Fluent English Communication, Good Powerpoint Knowledge / Excel, Techno Savvy Salary: 10,000 15,000 per month Job Description: Co-ordinating with our different teams and Stake holders for event elements, handling end to end execution of events, handling on ground execution tasks etc. Joining: Immediate Interested candidates can apply on 9960680445

Knowledge of export documentation, Pre Shipment & Post Shipment documentation. Having exposure in MS office(Excel & word). Good communication skill via email etc.Interested candidates can email their resumes for interview purpose. Prime Placement & Manpower Services, Address:- B - 5, Jayraj Complex, 2nd Floor, Opp. Creata Ice-Cream, Soni Ni Chali 4 Rasta, Odhav Road, Ahmedabad 382415,Gujarat, INDIA. Jalpa Ph - 9377-1657-78. Visit: www.primeplacement.org / www.ppmsjobs.com for Current Openings. Email- recruit.primeplacement@gmail.com / vinod@primeplacement.in / jalpa.primeplacement@gmail.com

Immediate Openings for Admin Executive Staffs... We are immediate Wanted Admin Executive freshers staffs in Manufacture Industry. Qualification: MBA Experience: Freshers Salary: 12k to 18k Prepare excel data (excellent Excel knowledge is must) & presentations PPT. Creating PO in ERP. Follow-up with internal stakeholders and vendors on ongoing tasks/projects. Collecting information/status/updates from various business users & Vendors. IT policy draft and updates. Strong Communication Skill. Should Have Knowledge In Excel. Should Have Good Knowledge In English (Verbal And Written). Further Details Contact Nandhini HR 99623@@21948

Job description Key Responsibilities: 1. Responsible for SABRE ticketing, 2. Responsible for ticketing, Exchanges - refunds & reissues in SABRE and ONLINE Airlines B2B logins 3. Completion of Quote's - Issuance & Reissues within given TATs 4. Report preparations on ADM with reasons & raise issues with airlines if necessary; provide ADM explanations after weekly ARC reconciliation 5. Exception handling of records after ARC reconciliation 6. Preparation of weekly MIS, management reports, daily sales reports 7. Any other activity required for managing customer experience and reporting requirements & compliance's KEY COMPETENCIES 1. Experienced with SABRE ticketing, 2. Should have experience on International ticketing, Issuance - Exchanges - Refunds & reissues 3. Should have experience on MIS reporting with Excel or CSV tools 4. Should be able to understand full ticketing process from fare-search to reporting 5. Knowledge of IATA reporting for ADM/ACM is must QUALIFICATION & EDUCATION, EXPERIENCE, TRAINING & KNOWLEDGE Qualification & Education: Commerce graduate Travel & tourism certification, IATA certification is must Experience: Minimum 3 -5 years' work experience with experience in Travel/Airline/Hospitality with ticketing knowledge / experience Training & Knowledge: Strong Application knowledge and understanding of business requirements A good working knowledge of Microsoft Office Suite including Word, Excel, PowerPoint and Outlook, Microsoft Project Excellent written and verbal communication skills Online Tools n B2B login's of Airlines and Wholesalers

Job Vacancies for a Good industry in Ludhiana: (a) Position HR Recruiter Male / Female Experience 3 months minimum / fresher Salary 12 - 15,000 monthly Job Location Ludhiana Local Candidates can apply only Responsibilities- Participating in recruitment efforts Posting job ads and organizing resumes and job applications Scheduling job interviews and assisting in interview process Ensuring background and reference checks are completed Preparing new employee files Maintaining current HR files and databases Skills Required Basic computer knowledge Good communication skills (b) Position Telesales (ONLY FEMALES) Experience 0-1 year Salary 15K+ Incentives Job location Ludhiana Openings 10 Line up candidates with good convincing skills & knowledge of E-mail & MS- Excel. Responsibilities Generating and qualifying leads from cold calling Managing, tracking and following up on leads by calling them Conducting sales presentations through the phone and screen sharing Meeting monthly and quarterly sales goals in accordance with goals Creating and updating activity reports (c) Position Customer Service Executive (Only Male) Experience 0-1 year Salary 10 15k + Overtime Job location Ludhiana Openings 9-10 Line up candidates with good communication skills in English & knowledge of E-mail & MS- Excel. Responsibilities Contact potential or existing customers to inform them about a product or service using scripts. Answer questions about products or the company. Ask questions to understand customer requirements and close sales. Direct prospects to the field sales team when needed. Enter and update customer information in the database. Take and process orders in an accurate manner. Handle grievances to preserve the company s reputation. Keep records of calls and sales and note useful information. (d) Position Graphic Designer Qualification Any equivalent to work Experience 1 year Salary 10 12k Job Location - Ludhiana (Punjab) Pick local candidates only Openings 6- 7 Job Responsibilities Design web pages, brochures, logos, Labels,advertisements, and other communication materials. Communicating with clients to gain an understanding of what they want. Create or incorporate illustrations, pictures, and designs to reflect the desired theme and tone of the communications. Produce drafts for review by clients and make revisions based on the feedback received. Review final productions for errors and ensure that final prints reflect client specifications. Required skills Proficient in graphic designing tools such as Adobe Photoshop, Corel Draw, Illustrator, Inkshape & related software knowledge Video editing Flex designing (e) Position Social Media Executive/Digital Marketing Executive (Male / Female) Experience 1 year minimum Salary 12 - 15k Openings 6-7 Job Location - Ludhiana (Pick local candidates) Qualification Any Google Ads Certificate Digital Marketing Course (both things are mandatory) Responsibilities Manage the social media accounts of the organization in Facebook, Youtube etc. Proficiency across publishing & advertising platforms of Facebook, Youtube. Monitor & evaluate social media results through deep analytics & metrics Assist with general day to day administrative tasks. Report regularly on performance & engagement across multiple social media platforms. Other skills Strong communication & inter personal skills Extremely organised Experience in building social media communities & general marketing experience (f) Position E-Commerce Marketing Executive (Male/Female) Experience: Minimum 3 months (in same field) Qualification: Any relevant to this field Salary: 12 - 20,000 monthly Openings: 10 Job Location Ludhiana Skills Required Good communication skills (both verbal and written) Proficiency in MS-Office & managing data Strong analytical skills Responsibilities- Managing catalogs listing, organizing photo shot, product uploads and content optimization on market place like Amazon, Flipkart etc. Provide weekly reports on campaign performance including engagement, revenue generation etc. Optimizing and modifying the existing product listing on marketplace to increase the product visibility. SEO and allied digital marketing activities in shopping portals like Amazon (g) Position Hindi Content Writer Male / Female Experience 6 months minimum Salary 12 15k Qualification - Any Job Roles Conceive, write and deliver compelling, on-brand, actionable content for a range of mediums - online, digital, social, mobile and print Manage additional aspects of the content creation including research, fact-checking, key-word optimization, editing, proofing, posting, and monitoring for engagement opportunities Exploring content trends by regular research and analysis Skills Required Excellent command in Hindi Language Computer Proficiency Interested candidates visit or call us at for interview at TRUEZONE Unit No.42,2nd Floor,CITY COURT,Zirakpur. Contact No.: 9988036622,7837671359,9779996980 Landline: 01762504007

Responsibility: Preparing and sorting documents for data entry Entering data into database software and checking to ensure the accuracy of the data that has been inputted. Resolving discrepancies in information and obtaining further information for incomplete documents. Creating data backups as part of a contingency plan. Responding to information requests from authorized members. Requirement: Experience Required: 0 to 2 Year(Freshers) Good Typing Speed, Internet Knowledge & Microsoft Office Excel / Word Sound knowledge of Computer / MS Excel Should have good communication skills Should be active & responsible Willing to join as soon as possible Education: Bachelor's (Required) About Company: GoComet is world's best freight quote comparison platform used by enterprises to make freight procurement efficient and fast.As a technology company, we are revolutionizing the $200 Billion international logistics space by eliminating inconsistencies in the procurement process at various stages of procurement like RFQs, quote comparisons, human dependent negotiations and insufficient disclosure of terms. Our enterprise SaaS product that is currently used by large manufacturing conglomerates (like Olam, Mondelez, Sun Pharma, Tata, Aditya Birla) combines the power of data science with progressive machine intelligence to drive sharp reverse auctions bringing out best possible end to end rates for shipments. We are backed by top VCs in Singapore and India and have 5 Offices across India, Singapore and Thailand.

Best Business Analytics Coaching in Noida, Ashok Nagar, will provide extensive and in depth knowledge in Business Analysis tools which include Microsoft Advanced Excel, Microsoft Power BI, MS Access and SQL, Python Overview and R-programming. All of these are considered extremely powerful and highly reliable Data Analytics tools which can be used by business organizations to identify the risks and opportunities in the market along with customer behavior and latest trends to make better decision making for the business. For More info Visit Our Website: https://slaconsultantsnoida.in/business-analyst-training-course/ Business Analyst Course Module 1 - Basic and Advanced Excel With Dashboard and Excel Analytics Module 2 - VBA / Macros - Automation Reporting, User Form and Dashboard Module 3 - SQL and MS Access - Data Manipulation, Queries, Scripts and Server Connection - MIS and Data Analytics Module 4 - Tableau | MS Power BI ▷ BI & Data Visualization Module 5 - Python | R Programing ▷ BI & Data Visualization Module 6 - Python Data Science and Machine Learning - 100% Free in Offer - by IIT/NIT Alumni Trainer

Business Analytics Course in Delhi, Laxmi Nagar will provide extensive and in depth knowledge in Business Analysis tools which include Microsoft Advanced Excel, Microsoft Power BI, MS Access and SQL, Python Overview and R-programming. All of these are considered extremely powerful and highly reliable Data Analytics tools which can be used by business organizations to identify the risks and opportunities in the market along with customer behavior and latest trends to make better decision making for the business. For More info Visit Our Website: https://www.slaconsultantsindia.com/business-analyst-training-course.aspx Business Analyst Course Module 1 - Basic and Advanced Excel With Dashboard and Excel Analytics Module 2 - VBA / Macros - Automation Reporting, User Form and Dashboard Module 3 - SQL and MS Access - Data Manipulation, Queries, Scripts and Server Connection - MIS and Data Analytics Module 4 - Tableau | MS Power BI ▷ BI & Data Visualization Module 5 - Python | R Programing ▷ BI & Data Visualization Module 6 - Python Data Science and Machine Learning - 100% Free in Offer - by IIT/NIT Alumni Trainer

SERVICENOW ADMIN AND DEVELOPMENT During this 3-day interactive training course you will implement various system administration functions in your own instance, which is a safe sandbox to perform fundamental administration and configuration tasks: • Perform core configuration tasks. • Work with UI Policies, Data Policies, UI Actions, Business Rules and Client Scripts. • Use the Mobile Platform. • Activate Plugins. • Add users, groups, and roles. • Manage data with Tables, the CMDB, Import Sets, and Update Sets. • Work with two key Process Applications: Knowledge Base and Service Catalog. • Create Workflow activities and approvals. • Configure Alerts and Notifications. • View Upgrade History and Status. • Control System Access and Data Security. • Create Baseline Performance Metrics. • Run Reports, configure SLAs, and perform Instance Branding and Customization. • Integrate social IT elements and learn best practices. We weave a scenario throughout our course to present real world, relevant lab exercises. The 3-day class features lecture and group discussions, as well extensive hands-on practice and reinforcement delivered in a wide variety of labs, tech talks, and a comprehensive case study. Click here to view the entire course outline. Who Should Attend This course is designed for new ServiceNow System Administrators, those who are 0-3 months into a new deployment. Prerequisites The Foundations online learning course has six modules which introduce the ServiceNow platform and interface, where you explore what you can do on the platform. Class Schedule (includes 1 hour lunch break)- 3 days. Service now Advanced Administration Are you administering a ServiceNow system and need to fine-tune features based on your organization's needs? Want to learn how to automate more of your company processes? This two-day course provides hands-on practice for implementing new workflows and changing system settings. Best Practices around a core set of ServiceNow applications are detailed and applied to course work. Starting with a Requirements document, students implement workflows and system enhancements to a ServiceNow system that has been in production for approximately 6-12 months. A compelling story is woven throughout the course content and lab work to help students learn to: • Capture class work in update sets to understand their purpose and movement. • Implement new workflows that use a variety of activities to understand how records are generated from workflows. • Coordinate Service Catalog options, including two-step checkout, cart controls, and variables. • Create and link Content Management System (CMS) content blocks and pages to present a menu of services to ServiceNow users. • Use a database view and trend data to do reporting. Field color assignment and security controls are discussed in relation to reporting. • Implement a Web Services integration and learn about the possible data paths into ServiceNow. • Set system controls that direct the right data to the right users at the right time. • Investigate performance issues, learn troubleshooting tools, and use system logs to find issues. Who should attend: This course is designed for ServiceNow administrators and consultants who maintain ServiceNow systems that have been in production for approximately 6-12 months and successfully passed the System Administration certification. Prerequisites • Certified System Administrator • Students should work all of the exercises and labs from lessons 1 – 8 of CodeAcademy's JavaScript course. • scripting in ServiceNow is highly recommended Course Details: • 2 day, Onsite Instructor Led training course Scripting in Service Now Need to take advantage of the extensibility of ServiceNow? Want to add new functionality or modify the baseline behavior of your instance? If so, attend Scripting in ServiceNow to learn how to use our JavaScript API. This class begins with client side scripting and transitions to server side scripting. You will write, test, and debug scripts using real-world, relevant lab exercises. The class features lecture and discussion as well extensive hands-on practice and reinforcement delivered in a wide variety of lab activities. During this interactive training course you will perform scripting functions in your own instance. This will provide a safe sandbox for practicing and becoming comfortable with both client side and server side scripting, including UI policies, business rules, and best practices. The course content and lab work help students learn to: • Determine when it is appropriate to script • Configure a ServiceNow instance for Scripting • Write, test, and debug client side scripts o Client Scripts o UI Policies o UI Scripts • Write, test, and debug server side scrip o Business Rules o UI Actions o Script Actions o Workflow Scripts o Scheduled Jobs o Develop Scripting best practices o Write, test, and debug Script Includes o On Demand Functions o Server side o Client/Server • Manage Events Who should attend? Experienced ServiceNow System Administrators wishing to extend the functionality of their instance. We recommend that you have a minimum of 3-6 months of experience with the ServiceNow platform and have attended the System Administration course. System Administration certification is preferred. Prerequisites Ability to write, test, and debug JavaScript. Course Details: 3 day, Onsite Instructor Led training course. SERVICE NOW ONLINE TRAINING COURSE CONTENT: 1) INTRODUCTION TO SERVICENOW TRAINING • Introduction to service now instances & Process • SNC Navigations • SNC Applications and Modules • Forms, Lists and Tables 2) BASIC FORMS AND LIST MODIFICATIONS AND ADMINISTRATION • Personalizing Forms • Creating new sections in forms • Personalizing Lists and List controls • Introduction to Different types of Fields • Dependent choice field creation 3) CONFIGURING USERS AND GROUPS AND ADMINISTRATION • Users • Groups • Roles • Roles tagging to users and groups 4) TABLES & COLUMNSAND ADMINISTRATION • Introduction, schema map, creating tables adding fields etc. • Auditing tables and fields • Skipping a field from Auditing • Recovering deleted data 5) APPLICATIONS AND MODULESAND ADMINISTRATION Creating and modifying applications and modules and other related activities of Servinow admin Limiting access of Applications and modules to specific set of roles 6) INTRODUCTION ON DIFFERENT MODULES • Incident Management • Problem Management • Change Management and it’s workflows • Servicenow Training developer Level Management 7) CHANGE MANAGEMENT • Different types of change requests and their significance • Change Types and Respective workflows • Risk Assessment Plugin activation • Risk Questionnaires configuration and defining thresholds and conditions • Approvals debugging in workflows • Creating Dynamic approvals 8) SERVICE LEVEL MANAGEMENT • SLA definitions and triggering conditions • SLA schedules • Excluding and Including holidays in Schedules • Retroactive start usage in SLA • SLA workflow and Notifications on breach 9) SERVICENOW TRAINING CATALOG • Introduction to Items and Categories • Record Producers • Introduction to Variables and Variable Sets. • Creating workflows • Associating workflows to Items 10) EMAIL NOTIFICATIONS AND EVENTS • Email notification creation(when to trigger, whom to trigger, What content to send) • Templates utilization in email notification • Events creation • Email notification through events • Email notification in workflow via notification and events • Send to event creator usage • Email Inbound and Outbound server properties setting • Debugging mail sending issues 11) IMPORT SETS AND TRANSFORM MAPS • Data load through excel • Transform Mapping(Auto and Manual mapping) • Transform Scripts to restrict inserts and update • Data source creation (FTP,JDBC,LDAP,files like excel,csv) • Utilizing data source in Data loads • Scheduled Imports 12) CMDB AND DISCOVERY • CMDB purpose in incident & problem & change request • CMDB classes structure • Data load using import sets into CMDB • CMDB relationships creation • Different ways how data come into CMDB(importsets,discovery,3rd party CMDB integration) • Discovery purpose • Help the helpdesk in ServiceNow • How to enable Discovery in Snow 13) SCRIPTING • Client Side scripting • Client Scripts (Intro, How to write and use) • UI Policy (Intro, How to write and use) • Server Side scripting • UI Action (Intro, How to write and use) • Business Rules and Global Business Rules (Intro, How to write and use) • Script Include 14) UPDATE SET • Creating an update set • Using an update set • Creating update source • Retrieving update sets • Moving changes between instances • Errors skipping and checking • Advantages and best practices 15) REPORTS, GAUGES AND HOMEPAGE • Creating Quick reports from lists • Creating Reports, Gauges and Homepages • Various types of reports and usage • Using Script Includes in reports • Scheduling reports • Report Administration 16) INBOUND EMAIL ACTIONS 17) ACCESS CONTROL RULES (ACL) 18) MID SERVER INSTALLATION • Mid Server setup download • MID Server configurations • Running MID servernow Training • Debugging MID server issues 19) SSO AND LDAP BASICS AND PROCESS • Purpose of SSO and LDAP • SSO considerations and requirements basics • SSO properties configurations • LDAP server configurations • LDAP OU definitions, Data Sources and Transforms