Microsoft Excel for Work and Business - Basic Course

It’s the chore on everyone’s to-do list, but somehow we never get around to it: Going paperless.Whether you’ve been meaning to start moving your household documents to the cloud, or you want to start scanning an automating the paperwork related to your very small business or home office, now is the time!Every January, I hear so many of my self-employed friends complain about having to dig through receipts and get their records in order before tax time.So let’s get this done.Over the years, I’ve figured out ways to make going paperless easier and less intimidating.We’ll talk about how to tackle a little at a time so you don’t get completely overwhelmed at this big task in front of you.We’ll figure out what systems will work best for you, and how to put them in place.I’ll show you how to handle ordinary household documents, like:House and car recordsTax recordsBanking recordsHealth and medical recordsRental propertiesBoats, RVs and other toysKids and school recordsPetsFamily records like old family photosAnd we’ll work on small business records. For this, we’ll dive into:Scanning business documents and forms that you use over and overTracking receipts and expensesTracking incomeDeciding when to upgrade to a full accounting system like QuickbooksWhether you’re going paperless for your home, office, or both, we’ll pay special attention to:Password and internet securityStoring back-upsOrganizing documents so they’re easy to findKeeping systems in place that will change how you work going forward.I made this class for all of you who are still struggling with how to go paperless without losing control of all your important records.

Hello there,Welcome to the "Oracle 12C R2 RAC Administration and Data Guard for 12C R2" online course.Oracle 12C R2 RAC Administration, to manage 12C R2 Data Guard environment and become Oracle Database masterOracle rac, oracle data guard, oracle rac 12c, rac, data guard, oracle database administration, oracle 12c, oracle 12c data guard administration, oracle 12c rac, oracle 12c database administrationAre you a junior Oracle DBA?Are you DBA who is managing other RDBMS and want to immigrate to Oracle?Do you want to become an Oracle DBA at an international company?Do you want to learn Oracle Database Data Guard Administration for Oracle 12C R2?Do you want to manage the Data Guard environment?Do you want to learn the practical side of Oracle Data Guard Administration?Do you want to become a seasoned DBA?If you think so, you are at the right place.This time I’ve designed for you "Oracle 12C R2 RAC Administration and Data Guard for 12C R2” a straightforward course for the Oracle Database 12C Release 2 (12.2). In the course, you will have down-to-earth way explanations with hands-on examples. With my course, you will learn Oracle Database step-by-step. I made this course simple and easy with real-life examples. This course is expertly designed to teach everyone from complete beginners, right through to professionals ( as a refresher). In the course, you will have down-to-earth way explanations with hands-on examples on Oracle 12C Release 2 RAC and Oracle Data Guard 12C R2. During the course, we focus more on the practical side of Oracle Database. All my students will have a chance to learn not only the whats but also learn th

Power Apps is a suite of apps, services, and connectors, as well as a data platform, that provides a rapid development environment to build custom apps for your business needs. Using Power Apps, you can quickly build custom business apps that connect to your data stored either in the underlying data platform (Microsoft Dataverse) or in various online and on-premises data sources (such as SharePoint, Microsoft 365, Dynamics 365, SQL Server, and so on).Learning to code isn't necessary for app development. Anyone can build an app without coding. All you need to do is find the right app builder to accommodate your needs. Then it's just a matter of learning to use that platform, adding your features, and customizing the look and feel of the app with your own branding.A no-code app builder is actually as straightforward as the name implies—it’s development software that allows users to create apps without needing to know how to write code. Originally crafted for teammates without coding experience, this type of development helps anyone create fully functional apps via a simple visual editor.With a no-code app builders’ declarative interface, you’re drag-and-dropping pre-coded elements exactly where you want them, and the code follows suit. It’s not that coding isn’t happening—it’s that the elements have already been built behind the scenes, and you’re just telling them where to go. With a combination of cloud-based spreadsheets like Excel, Google Sheets etc. Housing your data and an idea of how you want to display that information, it’s surprisingly simple. You’ll be deploying apps in no time.Power Automate is an online workflow service that automates actions across the most common apps and services. For example, you can create a flow that adds a lead to Microsoft Dynamics 365 and a record in MailChimp whenever someone with more than 100 followers tweets about your company. When you sign up, you can connect to more than 500 services, and can manage data either in the clou

PurposeEffective use of templates allows Excel tables to be constructed efficiently, and logically. It is particularly useful for the Excel developers who use mathematical formulae.In short if you are repeatedly using the same tables, and then reformatting the tables or reapplying the formulae manually then this course is essential to help you be more efficient.Note that here when I refer to Excel tables I simply mean data that is formatted within a group. I do not mean a structured Excel Table (previously called a list).BackgroundThis course includes content from an older course on formatting in Excel. Based on feedback it was decided to expand the subject of Templates to become a separate course.Some of the Excel files used in this course are also provided in the older course and therefore the file names also refer to the previous file names as follows:Template1 (Unformatted7)Template2 (Unformatted8)Template3(Unformattted9)Section 1 IntroductionWe introduce the concepts for templates and outline what will be covered in this course.Lecture 1 Template ConceptsThis lecture explains template concepts in preparation for following lectures.You will learn:• The importance of using templates• Appropriate layouts for templates• The difference between an original template and a clone template• Considerations for setting up of easy to follow templatesThe corresponding sections are:2. Using a clone template for a simple set of data.3. Creating formulae that can be globally applied4. Using a clone template for more complex data5. CloseThe user is not required to know VBA , named ranges or arrays. These will be contained in extension courses.Section 2 Using a clone template for a simple set of d

Learn to manage multiple worksheets and workbooks and easily view and compare data in Excel 2019or Excel 365—in under 30 minutes!When you master Excel, you have one of the most practical and valuable skillsets in modern business. Most businesses rely on Microsoft Excel, so increasing your knowledge is a boon to both business productivity and personal development. Our “Excel in 30 Minutes” series can help you get started. This course is one in a series of ten 30-minute courses. Topics covered include:Managing your worksheets by learning to add, remove, rename, reorder, copy, and color-code themHiding and unhiding sheetsCreating Custom Views to save display and print settings and easily switch between themKeeping header rows or initial columns visible when scrolling by using Freeze PanesUsing Split to display two different parts of the same worksheetTracking important information about a workbook by viewing and adding Workbook PropertiesTake the full series and you will have completed our “Bigger Brains Mastering Excel 2019–Basics” course. High-quality HD content in the “Uniquely Engaging” TMBigger Brains Teacher-Learner style!Objectives. You will be able to:Manage your worksheets including adding, removing, renaming, reordering, copying, and color-coding themCreate Custom Views to save display and print settings and easily switch between themKeep header rows or initial columns visible when scrolling by using Freeze Panes, and use Splitto to compare different sections of a worksheetEasily compare or switch between multiple files or sheetsTrack important information about a workbook by viewing and adding Workbook Prope

A brief glimpse of PowerPivot's usefulness and capabilities...This course is designed for all Excel users -- not just power users capable of building incredible Excel worksheets with functions, VBA, and mystical trickery. Even if you never write a single formula, this course will teach you to build basic relationships and create PivotTables from multiple mapped tables without a single formula.The course will also introduce you to the DAX formula language. DAX is very similar to Excel formulas; however, you do not need to have experience with Excel formulas in order to use them. DAX and it's concept of context can allow you to replicate many complex Excel formulas with very simple DAX formulas. You'll learn to write formulas that are deceivingly simple yet generate results that seem like magic tricks.Dramatically increase the your data crunching capabilities with PowerPivotLearn how to weave datasets together within Excel to create flexible and dynamic reports unlike any you've built before. Incorporate KPIs to give your PivotTable reports dynamic visual cues. Incorporate DAX formulas to create intelligent PivotTables that look-up, link, and allocate values for you. This course is for anyone new to PowerPivot and applicable to any level of Excel user. You will learn DAX from the beginning stages and you don't need to be an expert in Excel to take this course.Change your view of PivotTablesEver spent hours building a table to load into a PivotTable through lookups, references, and connections?How about creating additional columns of complex calculations using SUMIFS or AVERAGEIFS?With some basic DAX, you don't need to understand these complex and challenging functions in order to create complex and powerful analytical computations. You can take advantage of the context-based computations within PowerPivot with the relationship definitions you'll learn about to genera