The top 20 Macro courses you need to take

1. Macros & VBA Excel

4.4

(1,540)

This course is an Introduction to VBA & Macros in excel. In this course we have tried to cover all the topics necessary for you get started on creating applications in Excel as per your needs. As always, to make things easier we have included links to download Exercise files as well as the results for each topic...

2. Create a Macro Processor with PERL

In this 1 hour guided project, you will build a macro processor and create your very own macro markup language then you can expand! We will focus on file operations in PERL in this guide project. Prerequisite: Basics of PERL including variables, arrays, conditionals, loops, and print statements...

3. Analyzing Macro-Environmental Factors Using Creately

By the end of this 2 hour-long guided project, you will be fluent in identifying and analyzing business markets and how to discover their attractiveness to new products and services. This project is designed to engage and harness your visionary and exploratory abilities. You will be using proven models in competitive strategy and the program Creately to explore and analyze these models. This is an important step for individuals or companies wanting to explore new markets for products or services. We will practice critically examining external factors that could affect the business sector. You will engage in evaluating through examples and hands-on practice examining factors effecting business including Political, Economic, Social, Technological, Legal, and Environmental. You will be ready to take an entrepreneurial idea through a scientific and logical process, helping you validate your ideas for new business or service...

4. Case Studies in Macro Economics

3.9

(74)

Course Description This is a tour of historic economic events decoding them to understand core concepts in Macro-Economics. Let's parse that 'why macro-econ': Central bank and Government budget decisions effect an individual's financial situation. Knowing what are the stimulators of these decisions can smooth out financial planning. This is where learning Macro-Economics will help sail your boat.'story-telling': Macro-economics is nothing but an engaging story of how, why and in what way do People, Government and Central Bank react to economic events. No wonder that the process of learning Macro-Economics should also be a story. We have done exactly that. By looking into historical events with a magnifying glass, we elaborate every little concept that literally govern economic decisions.'the big picture': Half knowledge is always dangerous. Everything in macro-economics connects in some way. Understanding how everything intersect in the bigger picture of things only would assure sound decisions. This course helps you understand why recession follows boom, or why interest hike trails inflation. We will connect the dots of major macro-economic concepts. What's Covered: Recession of 1970s: Cause and effect analysis, Government Decisions, Fiscal and Monetary policiesUnemployment and inflation: Effects on aggregate demand and supply, relation between unemployment and inflationGDP and Income: 4 components of GDP, Concept of Value Added, Nominal and real growth, Price Index, National Income, Disposable Income, Consumption and SavingsHow does GDP Grow?: Analysis of the growth stories of Japan, China and SingaporeInvestments and Interest Rates: Expectation, Revenue and Costs, why do interest rates change, Controls on Money Supply2008 Global Economic Recession: Root causes demystified, effects of recession and interplay of macro-economic factorsBalance of Payments: Current account and capital account transactions broken downForeign Exchange Rates: Purchasing Power Parity, determinants of real exchange rates, connection of Oil Prices and exchange ratesThe bigger picture: Why spike in oil prices are followed by recession and how does everything connect...

5. Advanced Microsoft Word VBA Macro Programming

4.5

(250)

This advanced Word VBA macro programming course is designed for users who are already comfortable with the basics of Word VBA macros, and who have progressed beyond relying on the Macro Recorder. If you are still new to Word VBA, have a look at the Udemy course Microsoft Word VBA Macro Programming - Introduction.   This advanced Word VBA course carries on from where the above Introductory course finishes.    The main purpose of this course is to take a deep dive into programming the Word VBA object model; but in a practical, hands-on kind of way. Here's a summary of what you will learn: You will learn how to program the Application object, which represents Word itself; how to check the user's location and screen resolution; and how to check which fonts are used in a particular document. Moving onto files and documents, you will learn how to process all files in a given Folder; how to archive files older than a certain date; and how to test whether a given Document is currently open. Next, when we turn our attention to the Range and Selection objects, you will learn the similarities and differences between these two objects; and when to use one in preference to the other. You'll learn the important Word programming skills of verifying the type of object which is currently selected and checking the page location of the selection. In the chapter on Word text objects, you will learn the VBA syntax for processing paragraphs, sentences, words, characters and ranges. You will gain confidence in how to have your macros perform operations like inserting text and copying text without wiping the user's clipboard. This is also the section in which you will learn how to program the Range. Find object to find and replace both text and formatting attributes; how to change the Case of Text, how to create bulleted and numbered lists; how to use the Word VBA objects used which control the formatting of text; how to create style; and how to create tables of contents. Once we've covered the nuts and bolts of working with text, we'll examine the code which you need when working with longer, more complex documents. In this section, you will learn how to create sections, headers and footers; how to work with odd and even headers and footers; how to use the LinkToPrevious Property; inserting Page Numbers; insert an image into a Header; and how to program the PageSetup Object. Then we'll turn our attention to creating and manipulating tables with VBA code; performing such operations as merging cells, formatting tables, converting text to a table, we'll create a macro which will transpose the rows and columns of the currently selected table. The course also covers content controls and interactive forms. You will learn how to combine this powerful feature with VBA programming; how to create content controls programmatically; and how to write code which responds to content control events. Towards the end of the course, we'll discuss the different ways of distributing Your VBA macro solutions. And, to end the course, we'll create a series of solutions which demonstrate how to write Word VBA code which controls not only the Word object model, but the object models of other Microsoft Office programs. We'll create three inter-application solutions: the first combining Word and Excel workflows; the second Word and Outlook; and the third, Word and PowerPoint. So, by the end of this course, you will have a good grasp of all of the intermediate and advanced Word VBA programming techniques that you'll need to master, in order to feel comfortable when undertaking Word VBA projects; either in the workplace, or as a consultant...

6. Intro to Excel Macros Part 1

4.3

(268)

Excel expert David Ringstrom, CPA, takes you step-by-step through the process of creating and using macros-one of Excel's most powerful features. In this comprehensive presentation, he introduces the concept of Excel macros as well as the Visual Basic for Applications (VBA) macro. David also explains step-by-step how to use the Record Macro feature and Excel's Personal Macro Workbook. After completing this course, you'll be equipped to use macros immediately. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics Covered: Making sense of the Enable Content prompt related to macros in Excel. Uncovering macro-related commands within Excel's user interface. Automating a repetitive task, such as formatting a set of phone numbers consistently. Utilizing the Relative References setting for creating Excel macros to be played back on any cell versus specific cells. Understanding the purpose and nuances of Excel's Personal Macro Workbook. Recording a contact info macro. Deciphering and managing Excel's macro security prompts. Converting. XLS workbooks to the up-to-date. XLSX format with just two keystrokes. Understanding how macros are used in Excel, along with the risks and benefits associated with them. Learning the risks and frustrations of using merged cells in Excel worksheets. Learning how to use Excel's Record Macro feature to create simple macros, without having any knowledge of programming. Although each course may be taken individually, this is part 1 of 4.1. Intro to Excel Macros Part 12. Intro to Excel Macros Part 23. Intro to Excel Macros Part 34. Intro to Excel Macros Part 4...

7. Access Macros: Automate Your Access Databases

4.4

(157)

Macros allow you more control over you Microsoft Access database. You get work done faster, and become more efficient. This course, designed to help you create macros for Access databases for day-to-day use, will allow you to: Become familiar with the Macro Builder window - get comfortable working with macros. Create macros for tables - automate actions in the foundation of your databaseAttach macros to buttons on forms and reports - make Access easier for you and your usersCreate macros that start when your database starts - a real time saver! You don't need to know any VBA code to enroll in this course. You just need a willingness to want to save time with macros, to upgrade your skills, and to invest a few hours of time in the process. The examples in this course can be used to create macros in Microsoft Office Access 2010, as well as 2013. You can GAIN MICROSOFT ACCESS MACRO SKILLS. So Click The Take This Course Button On The Right & I'll See You In Class!...

8. Master Excel VBA and Excel Macros

4.2

(101)

MS Excel is the integral part of MIS profession and one of the most useful Application for reporting and analysis. However to be successful in in this field only having the knowledge of MS Excel is not sufficient, the aspirant has to be well versed with Excel VBA as well. You may get to know about VBA at the time of learning and working with Macro itself. Macro enables the user to create a function it often requires. While the user records macros the Excel do a VBA programming for you. You may work on very advance level projects if you have got the knowledge of VBA. Our course curriculum has been considered as one of the most advance one. Moreover it enables the user to do what can we do in Excel but thousand times faster. Excel is the world's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove the redundancy in your workflow and accelerate your productivity drastically! No programming experience is required - complete beginners are more than welcome! VBA is a great language to start with because you can master the fundamentals of programming in a familiar work environment. No extra software is necessary - VBA is bundled with all modern versions of Excel...

9. Macro Photography & Focus Stacking Made Easy

4.7

(357)

Explore the amazing world of Close-up and Macro Photography and Focus Stacking with an internationally published photographer. Learn the techniques and equipment (optical, lighting and support) needed to achieve sharply focused, well-exposed photographs of flowers, insects and much more. This intensive course will show you how to get the most from your DSLR and mirrorless camera and how to enhance its macro capabilities in very affordable ways. Find out, for instance, how to turn your ordinary lens into a superb macro lens for only a few dollars. Or how to turn your on-board flash into a macro flash for small change. The course covers every type of close-up shot, all the way to extreme macro, and equipment ranging from macro and reversed lenses to close-up attachments and bellows. It also covers focus stacking techniques (including processing through Photoshop and Helicon Focus) as well as software and equipment for extreme macro. What Udemy students are saying about this course: This course had a lot of great tips and instruction on macro photography for a beginner like me. I've learned about cameras and other equipment used in macro photography. The instructor has a vast range of knowledge that he presents in an easy to digest manner. I like how the instructor uses DIY equipment as well as equipment that can be purchased. It gives the student options when first starting out with macro photography. This course is a great reference guide as well. I know I'll be referring back to it as I practice. If you're a beginner like me, I highly recommend this course! - Jamie SantellanoGreat work; good quality videos; precise, clear commentary instructions and product recommendations. Great Teacher! Worth watching if you are interested in macro photography, as I am. Now to get my camera and already purchased gear and go out to find shots and to shop for some new gear that was suggested. Look out world, here I come! - Rudra TysonJust a great discussion. I really enjoyed the out of the box ideas to make macro photography cheaper. Really good detailed explanation... - Ross Brewer...

10. Unlock Excel VBA and Excel Macros

4.7

(40,210)

Go from Beginner to Microsoft Excel VBA Expert! I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes: Over 50 Microsoft Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too. Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need. Simple explanations for complex concepts. High quality video and different delivery methods to keep things interesting. Lots of ideas to automate your current tasks. Learn from Google or from this Course?I've been there! I first learnt VBA from Google. It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing: The WHY - why does the code work in one situation but not another. Structure - topic sequence, real-case examples, workbooks, documentation. Don't waste your timeDon't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing. I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!! - Randy TaylorLeila is the real deal. there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q & A opportunities to answer specific questions. Trust me, this is the course you want to take.  - Justin FazzioWhat you can look forward to in this course: Understand how to use the right syntax in VBAUseful Excel VBA codes you can directly use for your workUse the macro recorder for simpler tasks and improve the codeWorking with the Visual Basic EditorDebugging tools and error handling methodsDifferent ways to reference ranges and cellsDifferent methods to loopHow to work with data typesPivotTables in Excel using VBAImporting data from other files and exporting data to text filesInteracting with other applications (Word, PowerPoint, Outlook)ActiveX and Userforms to enhance the Excel interfaceBasically all the knowledge you need to automate tasks in Excel...

11. (Oxford) Diploma: Real World Macro Economics

4.5

(69)

April 2021 update: New section added but - warning! - this includes homework. If you're keen on participating and discussing (with Instructor interaction) then this course is ideal BUT if you just want to watch videos and never post in Q/A this is not for you! LATEST ADDITION: In-depth analysis of the ECONOMICS of Donald Trump and Joe Biden. Up to date as at 27th October 2020. Who knows - this may influence the way some people vote!! This course looks at the two economies of the UK and the USA as they stand in early June 2019. During the visit to the UK by President Trump we look at the two economies - the one the UK PM is leaving behind as a legacy and the one President Trump is (temporarily) departing from. As part of the analysis we apply basic macroeconomic concepts. Key topic areas include: National debtBudgetsConsumptionUnemploymentInflationGrowthTradeThis course is fully up to date and will be of interest to anyone interested in current, real world, economicsJust added: July 2019: Workbook: Economics and declutteringChaptersChapter 1: The economics of declutteringChapter 2: Decluttering the companyChapter 3: How to declutter like an EconomistChapter 4: Buy less…Chapter 5: The economics of tidying upChapter 6: Declutter your businessChapter 7: Mistakes people make when declutteringChapter 8: The Kondo Effect: the economy-changing magic of tidying upTopics: DeclutteringSunk costsCosts of clutterMarie Kondo5S lean manufacturingLean managementDeclutter your mail inboxDeclutter your home officeWasting time and opportunitiesThinking like an economistA rich life with less stuffMinimalismHow much is enoughThe art of letting goRecyclingStatus quo biasDiminishing returnsDecluttering mistakesMinimalismConsumerismMinimalism and economics: the endowment effectTwo new workbooks have been added - one for Christmas 2019 and one for New Year 2020...

12. Excel Automation: Learn VBA & Macros From Scratch!

4.7

(219)

This course is built for Existing Excel users who would like to make their life more simpler and smarter by automating manual/repetitive work in Excel. FAQsQ: I've never done coding before and have no background to VBA. Can I still learn it?A: Yes, This course is mainly targeted to those who are absolutely new to coding/programming. I've trained over 5000 students with no programming background successfully. Q: I'm not a great learner, I find difficulty understanding and working with codes/programming. can I learn it?A: I consider myself as the worst student. So if I can learn it, you can too. Q: Why is coding/programming considered so difficult? Can a person with not a great memory learn it?A: Anything is difficult to remember and understand, if you do not have ample background to it, which answers the WHYs? of those concepts. Moreover, I'm myself the person who's not too great at memory, and that makes me ensure that I use simple language, with relatable examples and provide ample background to the concepts in my course. Q: I know how to record macros and I'm doing pretty well? What more this course has to offer?A: Recording is just one part of your learning. there are many more concepts in VBA which a person should know, to get smarter and more efficient at coding. This course doesn't revolve around recording the macros only. It focuses more on how to Write the macros from scratch. The idea is to make sure you are able to understand the codes so well, that it becomes easy for you to make more smarter macros going forward. Refer to the course contents of this course to know the details of what will be covered in this course. If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first  -  This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you learn it correctly and can re-implement the concepts when required. After completing this course you will be able to: Build your own full fledged macros from scratchWrite your macrosUnderstand your macrosEdit/Modify your macros to improve performanceCreate your own User Defined FunctionsAuto execute Macros on Several Events. Re implement the concepts to different problemsStart Loving to code (in case you currently don't)Looking forward to having more interactions with you in the course. Happy Learning!...

13. Excel Macros & Excel VBA Programming for Beginners

4.8

(1,508)

COMPLETELY REDONE ON MARCH 2022 WITH NEW VIDEOS! Become a proficient Excel Macros & VBA Programmer in a very short time. Excel VBA is powerful. Everybody wants to learn Excel Macros and VBA. They can make Excel work like magic. But most Excel users never use them. Others spend several days on a multi-hour course or working through a 1000-page book, getting overwhelmed with information. So why waste a great deal of time learning things you may never use? In this course, my goal is to help you learn ways to create Excel Macros that won't burst your brain. Also to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training. Content and overviewA macro is a sequence of instructions that automates some aspects of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, which is a programming language developed by Microsoft. If you think Excel VBA programmers are smarter or more gifted than you, then you're mistaken. Yes, macros can be intimidating, and yes, programming is a huge topic. If you saw a course on Excel programming with hundreds of lectures, would you really watch all of them?But wait a minute… What about people who may not have a programming background but aspire to reap the utmost from the program? Are there any programming principles and well-guarded secrets that you can learn and use to create any Macros you want? In this course, you will find several short, to-the-point lectures covering Excel Macros and VBA entertaining and accessible to non-techies. The goal is not to make you a star Excel programmer. If you want to be that, go for it! But I'll give you some best practices and make this course extremely practical. After all, you are not a programmer, you just need to write an Excel Macro to help you get your work done. Why is this course different? It's super practical. Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them. It's comprehensive and fast. Microsoft Excel Macros and VBA are complex, that's why the course is broken down into bite-sized piecesI update the Excel class monthly with new lectures! It has a Homework-Quiz after the section so to prove that you have learned the material. You will learn the most current version of Microsoft Excel (2019), but the concepts are compatible with Excel 2007, Excel 2010, Excel 2013, and Excel 2016Compatible with Microsoft Office for MacintoshAre you looking to learn practical Macro and VBA techniques you can put to use instantly? If so, then this is the course for you. It's entirely project-based and it's full of examples that are fully explained and easy to understand. It has been recorded with the brand new Excel 2019 in full HD 1080p. If you get stacked don't worry. I have fast and full support through the discussion board. And if you don't like the course simply return it. There is a 30-day money back guarantee. At the end of this Microsoft Excel class you will be given a Certificate of CompletionWhat are you waiting for? Enroll now! (it is 100% no risk deal)...

14. Master Microsoft Excel Macros and Excel VBA

4.6

(23,959)

Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016 Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA. During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks. As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers. Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects. Below are a few samples of the projects you will complete by enrolling and participating in this course. Automate placing and formatting a title on a worksheetInteract with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should workCleaning up multiple Excel Worksheets and prepare the data to be reported onCreate a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report WorksheetAutomate the creation of Excel Formulas to SUM data up in your ReportWorking with Excel VBA User FormsImporting Data from External Text Files Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros. So, don't lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you...

15. Microsoft Word VBA Macro Programming - Introduction

4.4

(1,269)

There are many online training courses on Excel VBA; but this is the only Word VBA course dedicated specifically to using VBA macro programming to automate Microsoft Word.  Marta: This course helped me develop my own macros, and start grasping more complex coding principles. Thank you!  The Word VBA video tutorials in this course are designed to give you all the ammunition you'll need to start creating your own custom macros to automate Microsoft Word tasks and operations. Microsoft VBA (Visual Basic for applications) allows you to control Microsoft Office programmatically. You can write macros which perform repetitive tasks saving your organisation, or your clients, time and money. Word users learn VBA macro programming for a number of reasons: some people are looking to enhance their career prospects; some are looking to save themselves time; others are aiming to save their company money and increase productivity.  Perhaps you are an advanced Microsoft Word user looking to venture beyond the use of the macro recorder. Perhaps you are a Microsoft Office specialist looking to enhance your skills portfolio and make yourself truly indispensable in the workplace. Perhaps you have already learned how to automate Microsoft Excel using VBA and you are now looking to do the same with Microsoft Word. Whatever your reasons for wanting to learn to write Word VBA macros, this course will equip you with everything you need to get started and feel confident about writing your own Word VBA code.  Sarahjane: I had no previous training on Word VBA coding but had used Word VBA code to create a complex Userform & document; primarily by copying and pasting from example code found on the internet - this was very time consuming and I found it almost impossible to customise and debug my code because I didn't really understand how the code worked. This course has broken down the concepts of code and syntax and shown me how to create useful and efficient interactions between the various code parts of my project - I can now see much better ways of structuring and coding my Userform & document and will be rewriting the majority of it...

16. Excel Macros & VBA for Excel Report Automation

4.6

(126)

Excel Macros - VBA for Report AutomationThe objective of this course is to make you expert in writing own macros code Exclusive for Report Automation.  If you see the course outline its all practical topics and only those codes has been taught which is regularly used in the report automation.  The other benefit is its a complete class room training hence i have very slow step by step to make you understand each topics. In this course i have even covered Sheets and Files Consolidation & Segregation Project which is regular required in Report Automation in Corporates. OverviewAdvanced Excel users encounter repetitive tasks such as: reports that need to be produced, data that needs to be updated or tables that need to be formatted on a regular basis. Using "Macros" many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class they can record the steps or operations that they want to perform, and then press a button to repeat them over and over again (and again). Prerequisite: Proficient knowledge of Microsoft Excel. This class is for non-programmers. Target StudentThis course is for individuals who use Excel 2016, 2013 or 2010 frequently and who need to automate routine tasks. Programming experience is not required. Thanks & RegardsRamzan RajaniMicrosoft Excel Specialist and Certified Trainer...

17. PowerPoint VBA Macros and Coding Interactive Presentations

3.9

(118)

When it comes to PowerPoint VBA, there is not much information out there to help you master it compared with Excel, Access and Word.  In this course you will learn how to construct macros and use ActiveX controls using VBA for PowerPoint through example presentations.  You will be taught how to create a complete PowerPoint user interface step by step, including techniques for loading and saving files, manipulating controls, and playing random music playlists across slides...

18. Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)

4.1

(217)

Microsoft Excel is a powerful tool essential for managing and presenting datain today's working environment. In this one day excel course, you  will gain the knowledge and skills required  to create and edit worksheets, use formulas and functions, sort and filter detail data visually, and present summary information in a consumable and professional format. A macro is a sequence of instructions that automates some aspect of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. The Power Query and Power Pivot features in Microsoft Excel can make a powerful combination. Power Query enables you to discover, connect to, and import data, and Power Pivot lets you quickly model that data.  You will learn how to use the DAX formula language to provide lookup abilities. I will walk you through step-by-step how to use Power Query to select data, prepare a query, cleanse data, and prepare data for Power Pivot. Also i will walks you through the Power Pivot workflow, showing how to create a data model, import additional data if needed, build relationships between data, and create calculations and measures. You will learn hands on real-world scenarios for working together with Power Query and Power Pivot. What You Will Learn Include: What is Office 365 Setting up Office 365 Excel 2016 user interface Exploring the Excel Ribbon  Customizing the Quick Access Toolbar Keeping Tabs on the Ribbon Entering Data  Opening a new workbook  Entering Data in Excel Basic Data entry Entering Data with Autofill Entering Date Entering Time Undo and Redo Changes Adding Comments Giving your worksheet a title Saving your work Creating Formulas and Functions  Using formulas for arithmetic tasks Re-using Formulas Calculating YTD Profits Calculating Percentage Change Using Relative and Absolute Reference Using RANK Function STD Function Small and Large Functions Median Function Count and counta functions Formatting   Exploring Fonts Adjusting Column Width and Row Height Using Alignment  Designing Borders  Formatting Numbers  Conditional FormattingCreating Tables Inserting Shapes What VBA is and why it is so incredibly usefulWhat  are MacrosCreating Macros using macro recorderCreating macro manually from scratchEditing MacrosDebugging MacrosHow to write VBA code and execute it in ExcelHow to make your macros work with workbooks, worksheets and the data on themHow to find and eliminate errors in your programs and make your macros runAutomation using macros. Analyse the macro from the Developer tab or the View tab. Examine the VBA window and VBA components. Distinguish between absolute and relative references. How to save workbook with macrosCreate a moduleCreate procedureCreate a subUnderstand the difference between a module and subRun the code in a subPreparing queriesCleansing data with Power QueryEnhancing queriesCreating a data model in Power PivotBuilding relationshipsCreating Pivot Tables and Pivot ChartsCreating LookupsUsing DAX to link dataCreating data modelCreating relationship between data sourcesAnalyzing data with PivotTables and PivotChartsUsing Power Query with PowerPivotConnecting  to a variety of data sources with Power BICreate and publish reports to Power BI ServiceRefreshing Data Source Updating QueriesUsing Conditional statementsUsing quick and dynamic measuresTransforming data on connected datasetsAfter completing this course you would have gained useful and practical skills to enable you to confidently create spreadsheets  that you can apply formulas and functions to as well as create tables from the data within the spreadsheet and much more...

19. SAS MACRO Programming - Advanced Programming for Beginners

4.3

(112)

Welcome to the course SAS Macro Programming - Advanced Programming for Beginners. Macro facility is an important feature of SAS Language. This course will help the novice SAS user bridge the gap between beginner and advanced programmer. My goal is that at the end of the course, you will not only know and understand Macro Language, but also know to implement it in your programs. Therefore this course includes a lot of assignments. This will allow you to practice and to gain experience. I put a strong emphasis on practice. All the code programmed during the course can be downloaded. However, i recommend and suggest you to write the code independently, so you can understand it in depthI divided the course into four sections. First section is Introduction. It includes lectures such as Installation & Familiarity with SAS University Edition and Introduction to SAS Macro. As you will see, SAS Macro consist of two basic elements: macro variables and macros. So in the second section, we will learn macro variables and n the third section we will learn macros. The last section is Conclusions. If you have any questions about the material, suggestions or ideas how to improve the course, i would be very happy to hear them. Guys, don't hesitate to ask the questions. I will answer any of them. I sincerely hope you will enjoy the course, and i promise that your programming level will increase significantly! Your Instructor...