Lifetime

Mastering Microsoft Excel 2019 is easy with our Step-By-Step Training course Learn Microsoft Excel 2019 Interactive Training Course - Basic to Advanced User Learn Microsoft Excel 2019 Interactive Training Course - Basic to Advanced User Click image to enlarge Description Excel 2019 Training CD Course with Interactive Exercise and Hands-on Labs Special Bonus: unlimited Online Access and free Microsoft office courses Product Features: Learn Microsoft Excel 2019 in less time and more effective than other training methods. New! Classroom approach: Learn each topics, practice with interactive exercises and Hands-on Labs. Come with practice files that the user can use along with the instructor - the best way to learn how to use Excel. Break down complex features into easy smaller topics to understand and go over the topics later. Learn Excel New Ribbon Interface and how to create spreadsheets with formulas, graphs, charts, and much more! Master these special functions - VLookup, Auto Fill and Flash Fill and many more! Exclusive Features: Helpful captions and clear narrations for you to follow along Practice with interactive exercises Take the Hands-on Labs to reassure what you have learned Level: Beginner to Intermediate Lesson 1: Getting started with Excel 2019 Introduction to Excel spreadsheet Getting familar with New Interface of Excel 2019 Customizing the Quick Access toolbar Understanding the Status Bar Using Zoom-in and Mini Toolbar Using simple keyboard keys to move around Lesson 2: Basic Operation Creating and Converting Workbooks Understanding Type of Data Entering Data using Enter and Tab Performing basic operations: edit, move, copy and delete Entering Data using AutoFill Using Flash Fill and adding comments to the cell Lesson 3: Formatting Sheets, Cells and Tables Changing Font Settings of a Cell Applying Number Formats Adjusting row height and column width Hiding/unhiding rows and columns Applying Borders, Shading and Gradient Fill Using cell formatting Using Table Formatting Lesson 4: Formulas and Functions Using Formulas Entering Formulas Using Sum Formulas Using Sum, Average and SumIF Function Using Vlookup Function ​Lesson 5: Editing Graphics Inserting pictures Editing pictures Using SmartArt Inserting shapes Overlapping, grouping,& hiding graphics Capturing a Screenshot Lesson 6: Chart Design Inserting Charts Adding Chart Elements Changing Source Data Changing Chart Layout and Format Formatting Chart Elements Enhancing a chart Hierarchical and Statistical Charts Using 3D Maps Creating Sparklines Lesson 7: Managing Data Lists and Pivot Table Report Creating and Filtering a Data List Using Sort & Filter Using Subtotal Creating PivotTable Report Lesson 8: Automating Tasks with Macros Installing Developer Tab Recording Macro Editing Macro Macro Security Lesson 9: Helpful Keyboard shortcuts and hints Creating Excel Spreadsheet/chart in Word and PowerPoint Using Keyboard Shortcuts Helpful Hints Lesson 10: Using Excel for Financial Analysis Analyzing a potential investment Setting up an integrated Budgets Based Upon a Series of Assumptions Creating Pro-Forma Financial Statements from Your Budgets Analyzing Financial Ratios, Contribution Margin and Breakeven Point Bonus - Free Online Access: You are qualified to receive free access to our online site: stepbysteplearn. - Access the course from your PC, Tablet or Mac - Free courses, such as Financial Analysis using Excel - updated contents - lifetime membership - download practice files - 24/7 unlimited access Content: CD-ROM System Requirements: Windows 10, 8, 7, Vista and XP CD or DVD Drive Internet Access is not required. Pictures sell! Auctiva offers Free Image Hosting and Editing.300+ Listing Templates! Auctiva gets you noticed! The complete eBay Selling Solution. Track Page Views With Auctiva's FREE Counter

Learning PHP and MySQL is easy with Step-by-Step Training Learning PHP and MySQL is easy with Step-by-Step Training Learning PHP and MySQL is easy with Step-by-Step Training Click image to enlarge Description PHP 6 and MySQL Step-By-Step Training Course with Sample Codes Amazing eLearning presents the best self-study training course for PHP 6 and MySQL. This is an instructional program that offers a quick and easy method for harnessing the vast potential of the PHP scripting language, MySQL database and their applications. You will spend your time studying and learning the material by using our sample codes. In addition, your schedule is your own. You can study as quickly or slowly you need to. By the time you are ready to find a better job, launch a new project, or take the exam. You will have all the tools, experience and knowledge needed for success. Feature: Step-by-step instructional program Sample codes included for practice Flash-based interactive training Full screen for maximum viewing Easy to follow narrated instructions Player controls for easy Navigation Learn faster than reading a book Table of contents Lesson 1: PHP at a glance 1.1 What’s PHP and its Advantages 1.2 Apache Server 1.3 My SQL database 1.4 Build Apache + PHP + MySQL under windows 1.5 APPSERV installation 1.6 Web page detection Lesson 2: Basic Syntax 2.1 Basic PHP syntax 2.2 PHP statements 2.3 PHP error messages 2.4 echo in PHP 2.5 PHP and HTML 2.6 .PHPS files 2.7 escape symbols 2.8 PHP Information page Lesson 3: Variables and Constants 3.1 Upper case and lower case usage 3.2 Statements and semicolons 3.3 Whitespaces 3.4 Constants and their syntax 3.5 Variable names 3.6 Function names 3.7 Class names 3.8 Types of data: Integer, Float, String, Boolean, Array, Object, Resource, and Null 3.9 Expressions and operators 3.10 Number of operands 3.11 Priority of operators 3.12 Variables and variable variables 3.13 Superglobals 3.14 Similarities and differences between constants and variables Lesson 4: String 4.1 string constants 4.2 variable interpolation 4.3 single quotes strings 4.4 double quotes strings 4.5 HEREDOC strings 4.6 printing strings 4.7 accessing single characters 4.8 string trim 4.9 encoding, decoding and escape characters 4.10 string searching operations 4.11 regular expressions Lesson 5: Arrays 5.1 Indexed Array and Associative Array 5.2 Array Creation & Array Identification 5.3 Array Elements Processing 5.4 Multidimensional Arrays 5.5 Extracting Array Elements Value 5.6 Conversion between Arrays and Variables 5.7 Array Sorting 5.8 Array searching Lesson 6: Objects-Oriented Programming 6.1 OOP Basics 6.2 Define “ Class ” 6.3 Create “Objects “ 6.4 Create Objects Initial Value 6.5 Methods of Class 6.6 Data Encapsulation 6.7 Data Inheritance 6.8 Data Polymorphism 6.9 Class Inspection 6.10 Object Inspection 6.11 Object Serialization Lesson 7: Forms, Cookies and Sessions 7.1 Variables 7.2 Server Information 7.3 Form Processing 7.4 Set Response Header 7.5 COOKIE 7.6 SESSION Lesson 8: Flow Control 8.1 IF Construct 8.2 SWITCH Function 8.3 WHILE Loop 8.4 FOR Loop 8.5 FOREACH Loop 8.6 EXIT Command Lesson 9: Functions 9.1 Function Introduction 9.2 Function Call 9.3 Function Definition 9.4 Function Parameters (Passed by Value, Passed by Reference); 9.5 Valid Variable Range (Global Variables, Static Variables); 9.6 Default Parameter 9.7 Changeable Parameter Number 9.8 Return Value 9.9 Variable Function 9.10 Anonymous Function Lesson 9: A PHP 6 Unicode 9.11 Unicode in PHP 6 Lesson 10: MySQL Database Application 10.1 MySQL Operational Mode 10.2 Start PHP MyADMIN 10.3 Modify Password by PHPMY ADMIN 10.4 Where to Use SQL Syntaxes? 10.5 SQL related syntax 10.6 How to Create Tables? 10.7 Syntaxes Correlated to Database and Tables; 10.8 Column Data Access Syntax 10.9 Data Reading Syntax 10.10 Data Modifying Syntax 10.11 Data Deleting Syntax 10.12 Others Syntax Lesson 11: Using PHP to connect to mySQL Database 11.1 connect to MySQL using mysql_connect() 11.2 The MySQL syntax executing function, mysql_db_query() 11.3 Another MySQL executing function, mysql_query() 11.4 fetch the Autonumber of the newly inserted data using mysql_insert_id() 11.6 fetch data from a returned array with mysql_fetch_array(), mysql_fetch_row(), and mysql_fetch_assoc() Lesson 12: PHP and E-Mail 12.1 E-MAIL Operating Principles 12.2 Clients Setting of OUTLOOK 12.3 Sending Mail by PHP Lesson 13: PHP Application – online ordering system 13.1 Create a simple online order system Total training time: ~24 hours Content: CD-ROM disc (sealed in a DVD-case) System Requirements: Platform: Windows 10, 8, 7 and Vista Processor: Pentium 133 Mhz or higher RAM: 32MB Hard drive space: 10MB CD-ROM Drive speed: 24X Images sell! Get Supersized Images & Free Image HostingCreate your brand with Auctiva's Customizable Templates. Attention Sellers - Get Templates Image Hosting, Scheduling at Auctiva.com. Track Page Views With Auctiva's FREE Counter