In this training, you will learn, using practical examples, how Power Pivot provides Business Intelligence functionality & reporting within the familiar environment of Excel.Power Pivot, a free add-in for Excel, written by Microsoft, puts the "power" into Pivot Tables (hence the name!). Power Pivot removes many of the limitations and frustrations that many advanced users find with Pivot Tables. For exam..
Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions is available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances, or just a casual user, these Excel functions can be very important time savers and enhance your ..
When it comes to dynamically lookup and retrieving information from small or huge tables of data Lookup functions can elevate you to a new world of accuracy, productivity, and time savings in Excel. To work efficiently with lookup functions you must start with a clear understanding, good habits, and application of correct structure and syntax.This course effectively teaches lookup techniques and demonstrate..
You can use Excel for basic tables, spreadsheets, calculations, and charts through powerful data management, PivotTables, professional graphs, and automation of repetitive tasks. Confident skills in this most popular and powerful Microsoft application are becoming an essential requirement in Banking, finance, business, government, and education sectors.Gain a solid foundation to efficiently build your knowl..
Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro. VBA is the programming language that is built into Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - an..
Excel provides the ability to connect a cell to data entered into another cell. A linked cell behaves as if it actually contains the data in the original cell. A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. A 3-D reference is a useful and convenient way to reference several worksheets that follow the same pattern while cells on each worksheet contain th..
For most business users (and many home users too), Microsoft Outlook has become the standard application for managing emails, calendar appointments, and to-dos. With an abundance of features and versions for desktop and mobile, there’s really no excuse not to be organized. Or so the theory goes. With the average office worker receiving over 100 emails per day, the reality for most people is email ..
You will begin by organizing data through the use of sorting, filtering, and creating subtotals. We can augment those tools by using conditional formatting. Putting that data into Excel’s Table format, we gain additional tools for manipulating the data, as well as being able to work with that data as an independent source of data separate from anything else on the worksheet. Once we have the data needed to ..
To work efficiently with formulas and functions you must start with a clear understanding, good habits, and application of correct structure and syntax. Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at an introductory level.This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you ..
To work efficiently with formulas and functions you must start with a clear understanding, good habits, and application of correct structure and syntax. Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel beyond the introductory level. This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspectiv..
Linking between spreadsheets, workbooks and applications offers huge efficiencies but needs a clear understanding to work accurately and avoid risks that linking can pose. Understand and apply the power of linking techniques within Excel and other key MS Office applications to boost productivity and efficiency for you and your organization. Object Linking and Embedding (OLE) makes content that is created in..
PivotTables are the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate and chart data in minutes. A PivotTable displays a summary of a selected data set in a condensed format of rows, columns, data fields, and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particular data in real-time. T..
Mail merge saves you significant time and effort, producing mass mailings and labels is much simplified, especially compared to the process of preparing individual letters or envelopes for many people. One standard letter can be created and sent to a huge range of recipients without having to manually add each name and address.MS Word "mail merge" creates personalized letters, emails, envelopes, or mailing ..
With 16 chart types in MS Excel including the new funnel chart, there are many choices to present information in a clear, engaging, and professional manner. Each chart type has up to 7 sub-chart variations plus a massive range of formatting options and variations. Maximize your use of this powerful Excel feature and take data analysis and interpretation to an effective and appealing level, helping your audi..
Styles can save you significant time and effort by applying consistent formatting throughout your document and instantly creating a Table of Contents which is automatically updated. A Table of Contents can include titles or descriptions and page numbers for sections or chapters and outline your content giving readers a high-level view of the structure and segments in your documents.Indexing allows you to ma..