Posts

Showing posts with the label how to create pivot table in excel

Microsoft Office Boot Camp - Tips and Tricks of Word, Excel, PowerPoint and Outlook (3 Hours)

Image
OVERVIEW In today’s business world, just about every job requires some computer skills. Microsoft Office, also known as Office 365, is the software that most computers use. The Microsoft Office suite includes  Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook . This 3-hour webinar will give you tips on all 4 of those topics. WHY SHOULD YOU ATTEND This boot camp is beneficial for anybody who deals with large amounts of data or uses MS Office on a regular basis, and wants to be more efficient and productive. AREAS COVERED • Microsoft Word o Selecting Text o Bullet Lists o Number Lists o Tables o Columns o Page Setup • Microsoft Excel o Relative Formulas o Absolute Formulas o AutoSum o The IF Function o Sorts o Filters o Conditional Formatting o Subtotals • Microsoft PowerPoint o Adding Slides o Adding Text o PowerPoint Views o Adding Background and Themes o Adding Pictures o Animations...

Productivity hacks for MS Office tools: deliver better and faster results

Image
Microsoft Office, also known as Office 365, is the software that most computers use and today almost every job requires a basic knowledge of the tool to work efficiently. Our upcoming boot camp discusses tips, tricks and best practices on Microsoft Word, Excel, PowerPoint and Outlook to help you enhance your productivity and performance. The boot camp covers the following key areas: ·        Microsoft Word - Selecting Text, Bullet Lists, Number Lists, Tables and more ·        Microsoft Excel - Relative Formulas, Absolute Formulas, AutoSum, IF Function and more ·        Microsoft PowerPoint - Adding Slides and Text, PowerPoint Views, Background and Themes, and more ·        Microsoft Outlook - Sorting and Filtering emails, Flagging emails for follow up, and more LEARNING OBJECTIVES This webinar helps you become efficient with Microsoft Word, E...

Microsoft Office Boot Camp - Tips and Tricks of Word, Excel, PowerPoint and Outlook (3 Hours)

Image
OVERVIEW In today’s business world, just about every job requires some computer skills. Microsoft Office, also known as Office 365, is the software that most computers use. The Microsoft Office suite includes Microsoft Word,Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook . This 3-hour webinar will give you tips on all 4 of those topics. WHY SHOULD YOU ATTEND This boot camp is beneficial for anybody who deals with large amounts of data or uses MS Office on a regular basis, and wants to be more efficient and productive. AREAS COVERED • Microsoft Word o Selecting Text o Bullet Lists o Number Lists o Tables o Columns o Page Setup • Microsoft Excel o Relative Formulas o Absolute Formulas o AutoSum o The IF Function o Sorts o Filters o Conditional Formatting o Subtotals • Microsoft PowerPoint o Adding Slides o Adding Text o PowerPoint Views o Adding Background and Themes o Adding Pictures o Animations • Microsoft Out...

Pivot Tables 101: create insightful business reports, summaries and visualizations

Image
In business, the data we base our decisions on is kept in databases and spreadsheets and they are not very valuable unless converted into summaries, reports, and visualizations. Our upcoming webinar discusses how Excel PivotTable serves as an incredibly dynamic and easy-to-use tool for this kind of reporting and data visualization. The webinar covers the following key areas: ·          Formatting data as a Table and creating charts to illustrate your insights ·          Formatting and creating a presentation ·          Linking multiple tables through relationships LEARNING OBJECTIVES In business, the data we base our decisions on is kept in databases and spreadsheets in list form. The list by itself is essential, but useless without summaries, reports, and visualizations. A Microsoft Excel Pivot Table is an incredibly dynamic and easy-to-use tool fo...

Excel Pivot Tables 101 - Detailed Data Analysis with Pivot Tables: Calculating Sums, Averages, Counts and More

Image
OVERVIEW Microsoft Excel Pivot Tables are one of the most powerful and easy-to-use features in Excel, but most people are intimidated by them. These tables allow users to take a large set of data – rows of data about things like customers, products, sales, locations, employees, anything at all – and build reports to make real business decisions. But how exactly do you make a powerful Pivot Table? In this session, we’ll review everything from the fundamentals like how to create pivot table in Excel to techniques that allow them to be used for dashboards and other visualizations. Neil will help you analyze and visualize essentially any kind of data in Microsoft Excel. He will share how Pivot Tables can immediately give you an insight into any part of your business. With just a couple of clicks, you can build a report and charts around your employees, your sales, your tasks – anything that’s relevant to you. WHY SHOULD YOU ATTEND Unlike many webinars, Neil’s sessions are 1...

Use Microsoft Excel Pivot Tables to Easily Summarize and Analyze Data

Image
OVERVIEW PivotTables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs.In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables , you’ll be saving time and making your job easier. WHY SHOULD YOU ATTEND Attend the webinar to get an in-depth knowledge of PivotTables, including how the tool helps in making customized reports and how it helps in making better business decisions. AREAS COVERED Why PivotTables are the hidden gems of Excel How to analyze large data sets from different business perspectives Create a PivotTable to summarize data Make understanding the data easier for others Use PivotTables to answer questions about the data Analyze patterns in the data Customize the summary by grouping data Format PivotTables for easy viewing Use a chart to view the summary visually LEARNING OBJECTIVES In j...

3 Hours Microsoft Office Boot Camp - Tips and Tricks of Word, Excel, PowerPoint and Outlook

Image
Microsoft Office, also known as Office 365, is the software that most computers use and knowing the advanced tips and techniques is essential to perform tasks effectively. Our upcoming boot camp discusses pro skills and techniques for Word, Excel,PowerPoint, and Outlook. The boot camp covers the following key areas: ·          Word - Selecting Text, Page Setup, Bullet Lists and more ·          Excel - Relative Formulas, Absolute Formulas, AutoSum and more ·          PowerPoint - Adding Slides, Adding Text, PowerPoint Views and more ·          Outlook - Sorting and Filtering Emails, Flagging Emails for follow up and more LEARNING OBJECTIVES Improve your knowledge about the various tools of Microsoft Office. Learn important tips and tricks to work with Word, Excel, PowerPoint and Outlook. WHO WILL BENEFIT •...