Advance Entrepreneur Kit

SQL Fundamentals

• DDL Statements – CREATE, DROP, ALTER, etc.
• DML Statements – UPDATE, RENAME, DELETE, TRUNCATE, ALTER, MODIFY, etc,
• DQL Statement – SELECT
• Restricting and Sorting Data
• Date and Time
• Join, Merge Tables
• VIEWS, INDEX, Stored Procedures, Managing synonyms and sequences

MS Office

• MS WORD – Word Interface, Editing, Proofing and Shortcut keys
• MS WORD – Font Formatting, Formatting Paragraphs, Setting page layout, Inserting Pages and cover pages
• MS WORD – Headers and Footers, Printing Documents, Bullets and Numbering, Tabs, Tables
• MS WORD – Inserting Watermark, Reviewing Documents, Styles, Table of Contents, Using Templates in Word
• MS WORD – Sending emails to multiple recipients, develop PDF files.
• MS POWERPOINT – PowerPoint user interface, Presentation Views, Create and manage slides, Managing sections
• MS POWERPOINT – Applying Themes and Changing slide backgrounds, Reviewing Presentations, Header and Footer, Formatting a Presentation
• MS POWERPOINT – Adding Pictures to Slides, Grouping and Ungrouping Images, Arranging Images, Adding Shapes, Merging Shapes, Adding Effects to an Image, Adding Audio & Video, Adding and Formatting Tables
• MS POWERPOINT – Adding and formatting charts, Add & Format SmartArt, Animations, Transitions
• MS POWERPOINT – Running a slide Show, Creating a Video, Creating a PDF
• MS OUTLOOK – Configuring Outlook, Customizing Reading Pane and Conversation Display, Personalize Message Content, Creating and Sending Emails, Specifying the signature
• MS OUTLOOK – Message Tab, Review Tab, Adding Voting buttons, Sending and Receiving Emails
• MS OUTLOOK – Quick Search, Creating a subfolder, Creating Rules, Trash Folder, Contacts, Creating Contact Group, Calendar, create an Appointment
• MS OUTLOOK – Meeting, Event, Task, Shared Email
• MS EXCEL – MS Excel Screen and its Elements, Entering Values in cells, Workbook & Worksheets, Columns and Rows
• MS EXCEL – Formatting the cells, Number Formats, AutoSum, AutoFill, Formulas, Paste Special
• MS EXCEL – Page Layout, Cell Referencing, Math Function, Date & Time Functions
• MS EXCEL – Date Functions Contd…, Text Functions, LOOKUP Functions
• MS EXCEL – Filtering, Advanced Filtering, Sorting, Workbook Views
• MS EXCEL – Group & Ungroup, Subtotals, Charts
• MS EXCEL – Pivot Table, Tables
• MS EXCEL – Proofing, protect workbook and worksheet, data validation
• MS EXCEL – Document inspector, conditional formatting

Advance Excel

• Cell referencing – Relative, Absolute and Mixed Referencing, Logical Functions – If condition, Logical Operators like AND, OR, NOT, Nexted If condition
• Advanced Math Functions – COUNTIF, COUNTIFS, SUMIF, SUMIFS, MOD(), VLOOKUP(), HLOOKUP(), LOOKUP()
• Text Functions • LEFT, RIGHT, MID, TRIM, LEN, FIND & SEARCH, CONCATENATE Date & Time Functions • DATE, DAY, MONTH, YEAR, TODAY(), NOW() Arrays. Defined Names
• Data Validation, Handling Invalid data ISNUMBER(), ISTEXT(), INDIRECT(), EXACT() functions
• Array formulae. One formula, one million calculations. SUMPRODUCT () – all the gain of an array formula with less of the pain.
• Conditional Formatting
• Elements of a chart. Types of charts
• Pivot table. GWTPIVOTDATA(). Slicer. TimeLine. Pivot Charts
• Problem solving. Calculations that make decisions – understanding TRUE ad FALSE. What Boolean Logic is and why it’s useful in practice? Combining logic and arrays to solve complex problems. Practical examples.
• Goal Seek. Data Table. Solver
• Tables
• Adding data from an External Source. Using Linked Tables in Excel data model. Creating a relationship between the tables. Creating a PowerPivot table. DAX functions. Calculated column. Calculated fields. Types of Calculated Fields. KPI (Key Performance Indicator)
• Conditional Formatting – beyond simple Conditional Formats. Basing conditions on a formula and deciding whether a batsman is out or not. Choose currency symbols for a whole sheet by changing a single cell. Getting your rules in the right order and knowing when to stop. Graphical
• Conditional Formats – the detailed options. Using invisibility to your advantage.
• Create charts to inspire. How to make good charts? Simple steps to make your charts clearer. Why small can be better than large? What are pie charts? Why 3D charts can be 50% worse? Mixed chart types, trend lines and projections? Advanced chart techniques: break-even lines and waterfall charts. Pictures in chart columns.
• Sparklines. Camera tool
• Templates
• Recording a macro. Visual Basic Editor. Working with a Code window. VBA fundamentals – Objects – Collections – Properties – Methods
• Range property – Cells property – Offset property – Object Browser
• Programming fundamentals – Variables – Data Types – Arrays – Object variables – User Defined Data Types – Built in functions – MsgBox() and InputBox() – With – End With
• Loops and Constructs – If Then Construct – Select Case – For Next Loops – For Each – Do while Loops – Do Until Loops

Salesforce Admin

• Introduction to Cloud Computing, IAAS (Infrastructure as a Service), PAAS (Platform as a Service), SAAS (Software as a Service)
• Introduction to CRM, History to Salesforce, Introduction to SalesForce.Com, Case study
• Understanding salesforce environment
• Salesforce standard objects
• Collaboration in Salesforce – Setting in Chatter, Using Chatter, Private groups, Public groups, invite customers, Post a message by email, Chatter feeds, Chatter tagging
• Salesforce Data Model
• Data Validation
• UI Design & Mapping with Department
• Expanding the App Using Relationship
• Security and Sharing
• Data Management
• Using Custom Workflow Processes
• Approvals Process
• Advance Automation
• Analyzing Data with Reports and Dashboards
• Salesforce Deployment
• Migration strategies
• Sandbox creation
• Sandbox refresh
• Connection setup between environments
• Inbound Change Set
• Outbound Change Set
• Ways to migrate data from a Salesforce environment to Other
• Packaged deployment

Digital Marketing

• Digital Marketing – Overview
• Domain & Hosting Basics
• Website Planning and creation
• Search Engine Optimization
• Search Engine Marketing-Google Adwords
• Social Media – Youtube, Facebook, LinkedIn Marketing
• Google Analytics
• Email Marketing
• Ecommerce Marketing & Lead generation for Business
• Creating Internet Marketing Strategy
• Content Marketing
• Affiliate Marketing
• Making Money via Adsense
• Blogging
• Online Reputation Management