Old Search System: microsoft excel




  • Oreilly - Visual Basic for Microsoft Excel

    Oreilly - Visual Basic for Microsoft Excel by | Released June 2012 | ISBN: 9781771370080...


    In this VB for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within...


  • Statistical Process Control (SPC) Using Microsoft Excel

    Statistical Process Control (SPC) Using Microsoft Excel Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...



    What you'll learn
    Statistical Process Control
    SPC
    Pareto Analysis
    Control Charting
    Process Capability Analysis
    Regression Analysis
    Quality Engineering Statistics
    Analytical problem solving methods
    How SPC is a key component in the product design and manufacturing processes
    Requirements
    Manufacturing background is helpful
    Microsoft Excel experience is helpful
    Description
    Statistical Process Control (SPC) Using Microsoft...


  • Microsoft Excel: Build AI-like Chatbot & Dynamic Table

    Microsoft Excel: Build AI-like Chatbot & Dynamic Table Video: .mp4 (1280x720, 30 fps(r)) | Audio:...


    What you\'ll learn
    Create dynamic financial and non-financial table
    Create dynamic commentary
    Build AI-like Chatbot
    Requirements
    You need Microsoft Excel to be installed on your computer or laptop
    Description
    What are your challenges?
    • you want to impress your boss by giving instant answers?
    •Or do you feel frustrated to answer the same questions over...


  • Complete Inventory Management in Microsoft Excel &TALLY ERP9

    Complete Inventory Management in Microsoft Excel &TALLY ERP9 Video: .mp4 (1280x720, 30 fps(r)) | Audio:...



    What you'll learn
    What Is Inventory?
    What Are The Types Of Inventory?
    What Is Inventory Management?
    What Are The Objectives For Inventory Management?
    What Is The Inventory Valuation?
    What Are The Types Of Inventory Valuation?
    What Is The First In First Out (FIFO) Inventory Valuation Method?
    What Is The Last...


  • Microsoft Excel Masterclass (2016/2019) - Basic to Advanced

    Microsoft Excel Masterclass (2016/2019) - Basic to Advanced Video: .mp4 (1280x720, 30 fps(r)) | Audio:...


    What you'll learn
    Learn Basic Techniques of Excel like Maths, Logical Functions and Text Functions
    Learn the Art of Orgnaizing your data, Sorting , Filtering and deriving meaningful outputs.
    Learn to Use Basic Charting Techniques in Excel
    Learn Advanced Techniques like Pivots, Lookup Tables, Formatting data and Basics of Macros.
    ...


  • Microsoft Excel 2020| VBA & Macro| Data Analysis & Reporting

    Microsoft Excel 2020| VBA & Macro| Data Analysis & Reporting https://www.udemy.com/course/microsoft-excel-complete-beginner-tutorials/ Get yourself equipped with...


    What you'll learn Macro and VBA for automation Basic analytics Data Validation, Pivot table, Vlookup Requirements Basic computer knowledge Description Get yourself equipped with knowledge in Excel. What you will become after going through this course: Master Microsoft Excel from Beginner to Advanced Build a solid understanding on the Basics...


  • Microsoft Excel Training: Learn Essential Excel Skills

    Microsoft Excel Training: Learn Essential Excel Skills Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...


    What you'll learn
    Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting.
    Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges.
    Excel Formatting: Adjusting...


  • Your Gateway To Microsoft Excel: The Basics

    Your Gateway To Microsoft Excel: The Basics Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...


    What you\'ll learn
    The basics of Microsoft Excel 2010 by working with rows,columns,ranges,references,formulas, and useful functions.
    Requirements
    Basic Mathematics
    Description
    This course teaches students the basics of Microsoft Excel. In this course we will navigate through excel rows and columns, we will see what is a cell and a cell address. next we...


  • Complete Microsoft Excel Course: Zero to Hero

    Complete Microsoft Excel Course: Zero to Hero Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...


    What you\'ll learn
    Basics Of Microsoft Excel
    Creating Charts
    Creating Graphics
    Formulas and Functions
    Programming Excel With VBA
    Advanced Uses Of Microsoft Excel
    Requirements
    A computer with internet access on it
    Description
    Welcome to my course. In this course i will assume that you are a complete beginner and by the end of...


  • Microsoft Excel - Excel from Zero to Hero (2020)

    Microsoft Excel - Excel from Zero to Hero (2020) Video: .mp4 (1280x720, 30 fps(r)) |...


    What you'll learn
    Learn the Microsoft Excel from the beginning
    Explore and learn the important functions in Microsoft Excel
    Learn how to analyse data using Excel
    Learn about PivotTable and use it for analysis
    Learn how to perform basic calculations
    Learn Excel by doing using practical examples
    Requirements
    This course starts...


  • Microsoft Excel 2019 VL 16.41 Multilingual MacOS

    Microsoft Excel 2019 VL 16.41 Multilingual MacOSLanguages: English, Arabic, Simplified Chinese, Traditional Chinese, Czech, Danish,...


    Excel features
    - Recommended charts. Choose the best chart that Excel recommends for your data.
    - PivotTable Slicers help you discover patterns in large volumes of data.
    - Use the Analysis Toolpak add-on to perform complex statistical or engineering analyses.
    - The Formula Builder pane helps you create formulas that enable you to tap...


  • How to Program Microsoft Excel as a Modbus Master HMI

    How to Program Microsoft Excel as a Modbus Master HMI Video: .mp4 (1280x720, 30 fps(r))...


    What you\'ll learn
    Have an understanding of how ActiveX controls work with Microsoft Excel
    Install the MBAXP Modbus ActiveX control in Microsoft Excel
    Write VBA code to read Modbus data from a Modbus Slave/Server
    Write VBA code to write Modbus data to a Modbus Slave/Server
    Use Modsim32 as a Modbus...


  • Complete Payroll Management in Microsoft Excel & TALLY ERP9

    Complete Payroll Management in Microsoft Excel & TALLY ERP9 Video: .mp4 (1280x720, 30 fps(r)) |...


    What you\'ll learn
    Introduction to Payroll?
    How to Prepare Payroll By Using Microsoft Excel?
    How to Install The Tally ERP9?
    What Are The Steps For Payroll Management Process?
    How To Enable Payroll Features On Tally ERP9?
    How To Enter The Opening Balance In Tally ERP9?
    How To Create A Template...


  • Microsoft Excel 2019 (365): Crash Course

    Microsoft Excel 2019 (365): Crash Course Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100...


    What you'll learn
    This is a crash course in Excel 2019 to take you from Beginner To Advanced level in under 7 hours
    You will learn introductory topics such as the Excel interface, sheets, rows, columns and data types
    Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
    Formatting (Format...


  • Microsoft Excel 2019 VL 16.40 Multilingual MacOS

    Microsoft Excel 2019 VL 16.40 Multilingual MacOSLanguages: English, Arabic, Simplified Chinese, Traditional Chinese, Czech, Danish,...


    Excel features
    - Recommended charts. Choose the best chart that Excel recommends for your data.
    - PivotTable Slicers help you discover patterns in large volumes of data.
    - Use the Analysis Toolpak add-on to perform complex statistical or engineering analyses.
    - The Formula Builder pane helps you create formulas that enable you to tap...


  • Learn Advanced Excel: Take the Next Step w/ Microsoft Excel

    Learn Advanced Excel: Take the Next Step w/ Microsoft Excel Video: .mp4 (1280x720, 30 fps(r))...


    What you'll learn
    Learn advanced Charts, Formulas, Shortcuts, Pivot Tables and Visualizations
    This course builds on your existing beginner to intermediate Excel skills.
    Get ready for that raise, promotion or new job by Supercharging your Excel skills.
    Requirements
    You should have a basic understanding of beginning Excel before starting this course.
    ...


  • Microsoft Excel Step by Step Training for Beginners!

    Microsoft Excel Step by Step Training for Beginners! Video: .mp4 (1280x720, 30 fps(r)) | Audio:...


    What you'll learn
    Basic controls – Opening Excel, Navigation, Scrolling Zooming
    A Quick Glimpse of the Power of Excel – Full Table Design, fill handle, Autosums, Basic Formula's, Formatting, Wordart, Status Bar
    The Quick Access Toolbar – Productivity Tool, Keyboard Shortcuts
    Cell and Sheet Control – Cell Inputting, Table Navigation,...


  • Microsoft Excel Beginners Guide to using Images and Styling

    Microsoft Excel Beginners Guide to using Images and Styling Video: .mp4 (1280x720, 30 fps(r)) |...


    What you\'ll learn
    Image importing via Excel \"Insert Image\"
    Image importing from Google
    Image Resizing, Moving, Rotation and Cropping
    Print Screen Copying
    Artistic Effects
    Sharpness, Brightness and Constrast Adjustment
    Preview Hovering
    Colour Saturation, Tone and Recolour
    Image Restting
    Image Styling
    Picture Styling
    Border Styling
    Picture Effects
    Multiple Image Control
    Instant...


  • Microsoft Excel Logic Theory and If Functions (Intermediate)

    Microsoft Excel Logic Theory and If Functions (Intermediate) Video: .mp4 (1280x720, 30 fps(r)) | Audio:...


    What you\'ll learn
    Logic function theory
    \"If\" function variations
    \"And\" funtion
    \"Or\" function
    Absolute Referencing
    Nested Logic Functions
    \"If\" function combinations
    Number and Text Concatenation
    Error Handling
    Requirements
    Pen and paper to take notes
    Microsoft Excel 2007 or later
    Access to a computer/internet
    Description
    WHAT'S YOUR STORY?
    Are you a business professional needing...


  • Analyze Huge Data with Ease Using Microsoft Excel Filters!

    Analyze Huge Data with Ease Using Microsoft Excel Filters! Video: .mp4 (1280x720, 30 fps(r)) |...


    What you\'ll learn
    Setting up Filters
    Applying Filters
    Sorting Alphabetically
    Using the checkbox function
    Using the search field
    Sorting by colour
    Filtering by colour
    Number Filtering: Equals and Does not equal
    Number Filtering: Greater than and Less than
    Number Filtering: Above and Below Average
    Number Filtering: Top Items
    Applying Multiple...