Posts

Showing posts with the label EXCEL

Be A White Hat Hacker and Pen Tester

Image
Be A White Hat Hacker and Pen Tester About this Course Become a white hat hacker and learn all the practical techniques for penetration testing with this amazing course which will provide conceptual framework to your security training. The course not only covers theoretical concepts but cover the practical demonstrations of various tools like Metasploit , Scapy and WireShark. The course is divided into the following main sections: Ethical Hacking Concepts -What is Ethical Hacking? Know about different types of hackers. Get to know about hacktivism and practical pen testing techniques Real World Information Gathering -Learn about foot printing and reconnaissance, Email harvesting, Learn and master SSL scan, Maltego, Whatweb, HttpRecon. Work on techniques like IP address geolocation, DNS and Mail Server Enumeration Scanning and Vulnerability Gathering -Learn to use scapy for packet crafting and port scanning, Learn to use network scanning techniques and work on vulnerability

2021 Microsoft Excel from A-Z: Beginner To Expert Course

Image
2021 Microsoft Excel from A-Z: Beginner To Expert Course What you'll learn Learn to master Excel from A-Z How to become a professional Data Analyst How to be a better, faster, stronger Excel user How to land your first job as an Excel Expert How to save hours of time and boost your productivity in Excel How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH How to use math, statistical, logic and text functions How to use VBA and Macros How to use VLOOKUP/HLOOKUP in formulas How to create basic and advanced formulas Mastering Pivot Tables Creating Charts from your data Show less Requirements basic computer skills Description Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel

Marketing Analytics and Retail Business Management

Image
Marketing Analytics and Retail Business Management What you'll learn Become proficient in using powerful tools such as excel solver to create forecasting models Learn how to estimate the trend and seasonal aspects of sales Perform market basket analysis and calculate lift to derive a store layout that maximizes sales from complementary products Understand how to interpret the result of Linear Regression model and translate them into actionable insight Learn practical concepts of how to get revenue/profit optimized price point in case of Bundle products. Learn why cable companies bundle landlines, cell phone service, TV service, and Internet service (Bundling) Perform RFM (Recency, frequency, and monetary value) analysis to help you maximize profit from promotional mail campaigns. Learn to calculate customer’s lifetime value under different scenarios and use it to increase the company’s profitability. Incorporate the impact of discount rate and retention rate to calculat

Excel Lessons - Zero to Pro for Teachers and Office Workers

Image
Excel Lessons - Zero to Pro for Teachers and Office Workers What you'll learn A Beginner's Guide to Microsoft Excel, Spreadsheets, Formulas, Shortcuts, Advanced Tables Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing Excel by creating Pivot tables with slicers Knowledge of all the essential Excel formulas Master Excel's most popular lookup functions such as Vlookup, Hlookup, IF etc. Make great presentations using the Conditional and Table formatting options Increase your efficiency by learning how to create and use important Excel shortcuts Make great reports for your chief of your department. Organize and manipulate your data in Excel as a professional. Requirements You will need a PC or a Laptop with any version of Excel installed in it Be positive and believe yourself :) Description Some reasons why you should choose this Excel course Carefully designed curriculum teaching you only the most used functionalitie

Microsoft Excel- Complete Master Program in MS Excel [2021]

Image
Microsoft Excel- Complete Master Program in MS Excel [2021] What you'll learn ******At End of this course you are become a master in Excel***** *****You will become a Master in Excel Basics***** At end of the course you are become a Master in Pivot Tables, Data visualization with charts, dynamic Arrays, core formulas, excel shortcuts *****Build a solid understanding of ESSENTIAL Microsoft Excel functions***** Solve complicated Excel problems WITHIN MINUTES *****Conduct effective analytics - THOUSANDS OF TIMES FASTER***** ****Impress your boss, colleagues, partners by being THE BEST at Excel in the office**** Harness full potential of Excel by creating Pivot tables with slicers Requirements No prior experience required: beginners and experts will learn a lot from the course Microsoft Excel installed, preferably version 2016 or higher Mac users are welcome, but note that the user experience will be significantly different across platforms Description Weak Excel muscles ca

Zero to Hero in Microsoft Excel: Complete Excel guide 2021

Image
What you'll learn A Beginner's Guide to Microsoft Excel - Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros Knowledge of all the essential Excel formulas Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match Harness full potential of Excel by creating Pivot tables with slicers Make great presentations using the Conditional and Table formatting options Visually enchant viewers using Bar charts, Scatter Plots, Histograms etc. Increase your efficiency by learning how to create and use important Excel shortcuts Explore fun and exciting use cases of Excel Requirements You will need a PC with any version of Excel installed in it Description 6 Reasons why you should choose this Excel course Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment Concise