Excel Macros VBA + Power Query (2 in 1 course)

With this video, Andy Rathbone, best-selling author of Windows 8 For Dummies, shows you step by step how to use every new feature of Windows 8. Tackle the all-new Start screen, use the Charms bar, organize and launch apps, and then connect to the Internet, manage the Windows Mail app, and add your social media accounts. Toss in networking, security, and how to manage photos, video, and music, and you have the ultimate show-and-tell! Windows 8 Training: Windows 8 for Dummies -Discover how to: • Launch apps from the Start screen • Locate and use the desktop • Customize Windows security • Use the newest Internet Explorer • Set up a home network • Play music and videos Take this Windows 8 Training: Windows 8 for Dummies course now and learn basics of Windows 8. /p

This course will cover everything from Excel fundamentals to advanced tools and functions. Whether you're just learning to navigate Excel or are already using it regularly but don't quite have a grasp on all of its tools, this course will teach you so many things that will make your job easier and beef up your resume. For a complete breakdown of the course, check out the curriculum.

Il corso si appoggia ad un file (allegato) che contiene tabelle di partenza su cui andare a preparare delle analisiLe funzionalità dovranno essere estese ai casi reali, gli esempi simulano solo una parte della realtà ma sono esplicativiUtilizzerete gli Scenari, la Ricerca Obiettivo, l'Analisi in Tabella Dati, i fogli di Previsione ed il Risolutore

Requirements· No Prior Excel Knowledge Required· Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is RecommendedDescriptionMicrosoft Excel: Formulas for BeginnersThis Microsoft Excel course will teach you the foundational excel formulas in record time! Below are the formulas that you will learn:· VLOOKUP· IF· SUM· AVERAGE· COUNT· MIN· MAX· CONCAT (Replaced CONCATENATE in 2016)· LEN· REPLACETopics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)Whether you have been struggling with a specific formula or you have just started your excel journey, this course will walk you through the basic excel formulas in an easily to understand and approachable format. I've designed this course to be as short as possible to cut the fluff and to allow you to ingest the information quickly and effectively. My goal is to have you fluent in these formulas and use this as a booster to your excel learning expedition.Who this course is for:· This Microsoft Excel courses will take you through all of the most common formulas that you need to be successful in excel.· This course is designed for the beginner, but the intermediate user will still benefit from the content.

Learn the most powerful and commonly used logical functions in Google Sheets to automate decisions, filter data, and generate smart reports — all taught in simple language with practical examples.Whether you're managing attendance, sales, tasks, or performance reports, this course helps you master essential conditional formulas like IF, IFS, COUNTIF, and SUMIFS with real-life use cases used by MIS professionals and business users.What You’ll Learn:Use IF, IFS, AND, and OR to build smart logic inside your spreadsheetsApply COUNTIF and COUNTIFS to count data based on single or multiple conditionsUse SUMIF and SUMIFS to calculate totals dynamically from filtered dataCombine logical functions for advanced automation in business scenariosCreate condition-based dashboards, trackers, and MIS reportsAvoid errors and write clean, readable logical formulasSave hours by reducing manual effort with data-based decision formulasThis Course is Ideal For:Office professionals, MIS executives, and data entry specialistsStudents and job seekers preparing for Excel or Google Sheets-based rolesFreelancers and business owners managing daily data and reportsAnyone who uses spreadsheets for work and wants to automate decision-makingLearners who understand basics of Google Sheets and now want to go deeper into functionsStart automating your spreadsheets, building smarter dashboards, and analyzing data like a pro —Enroll now and master Google Sheets logical functions with confidence.

**This course includes downloadable course instructor and exercise files to work with and follow along.**Welcome to this Microsoft Excel Intermediate course. In this course, you’ll learn how to utilize Data Validation tools effectively to control the input of data into your worksheets, enhancing data integrity and efficiency. This powerful tool ensures accurate data entry by allowing you to control what can be entered into specific cells, reducing errors and improving the integrity of your data. You will explore how to create dynamic drop-down lists, making it easier to select values rather than typing them manually. You will also learn how to handle common issues, such as duplicate values, and how to set up automatic updates as your data grows. Each lesson includes video tutorials and downloadable exercises, ensuring hands-on practice for comprehensive learning.Whether you're a beginner or an experienced Excel user, this course will equip you with the skills to create high-quality spreadsheets that meet the needs of your audience. Join us and elevate your Excel proficiency today.In this course, you will learn how to:Identify the purpose of Data Validation.Create a Data Validation Drop-Down List.Troubleshoot common issues with Data Validation lists.Use the UNIQUE function to eliminate duplicates in lists.This course includes:41 minutes of video tutorials6 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion