Posts

Showing posts with the label Microsoft excel formulas

Turn Your Business Data into Meaning Information Using 10 Powerful Excel Functions

Image
  Excel has many built-in functions that help you deal with your business data and it is very important that you know how to use them to get the most out of your data in a time efficient manner. Our upcoming webinar discusses how to use Excel functions to get useful insights from your business data. The webinar covers the following key areas: ·          Relative Formulas and Absolute Formulas ·          VLOOKUP and HLOOKUP ·          COUNTIF, AVERAGEIF, SUMIFS and NETWORKDAYS LEARNING OBJECTIVES • Learn how employers treat employees during the COVID-19 and not violate discriminatory practices • EEOC makes decision to stop the EEO-1 reporting until 2021 • Other EEOC regulation changes due to COVID-19 pandemic • Learn what the employer challenges are when recalling or deciding to furlough or layoff employees • Learn how the federal resources impa...

Excel Top 10 Functions and How to Use Them - Turn Your Business Data Into Insightful Information

Image
OVERVIEW In the business world, or within your organization, you probably encounter large amounts of data. Whether the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever, Excel has many built-in functions that help you deal with that data. It is very important that you know how to use Excel functions to get the most out of your data in a time efficient manner. By learning how to use the most useful Excel functions you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. WHY SHOULD YOU ATTEND You should attend this webinar if you use Microsoft Excel on a regular basis, and want to be more efficient and productive. AREAS COVERED • Relative formulas • Absolute formulas • IF • And • Or • Vlookup • Hlookup • Match/Index • Sumif • Countif • Averageif • Sumifs • Countifs • Networkdays LEARNING OBJECT...

Turn Your Business Data Into Meaning Information Using 10 Powerful Excel Functions

Image
Excel has many built-in functions that help you deal with your business data and it is very important that you know how to use them to get the most out of your data in a time efficient manner. Our upcoming webinar discusses how to use Excel functions to get useful insights from your business data. The webinar covers the following key areas: ·          Relative Formulas and Absolute Formulas ·          VLOOKUP and HLOOKUP ·          COUNTIF, AVERAGEIF, SUMIFS and NETWORKDAYS LEARNING OBJECTIVES If you handle large amounts of data in Excel and want to learn about the most useful Excel functions, this webinar will help you tremendously. You will learn how to use Excel functions to get useful insights from business data. WHO WILL BENEFIT • Business owners • CEO's / CFO's / CTO's • Managers of all levels • Anybody with large amounts of data •...

Excel Top 10 Functions and How to Use Them - Turn Your Business Data Into Insightful Information

OVERVIEW In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be. Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of Microsoft Excel formulas and functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. WHY SHOULD YOU ATTEND You should attend this advanced Excel training if you use Microsoft Excel on a regular basis, and want to be more efficient and productive. AREAS COVERED • Relative Formulas • Absolute Formulas • IF • AND • OR • VLOOKUP • HLOOKUP • Match/Index • SUMIF • COUNTIF • AVERAGEIF • SUMIFS • COUNTIFS • NETWORKDAYS LEARNING OBJECTIVES If yo...

2020 refresher on MS Office: Word, Excel, PowerPoint and Outlook

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, Ex...

Turn your business data into meaning information using 10 powerful Excel functions

Image
Excel has many built-in functions that help you deal with your business data and it is very important that you know how to use them to get the most out of your data in a time efficient manner. Our upcoming webinar discusses how to use Excel functions to get useful insights from your business data. The webinar covers the following key areas: ·        Relative Formulas and Absolute Formulas ·        VLOOKUP and HLOOKUP ·        COUNTIF, AVERAGEIF, SUMIFS and NETWORKDAYS LEARNING OBJECTIVES If you handle large amounts of data in Excel and want to learn about the most useful Excel functions, this webinar will help you tremendously. You will learn how to use Excel functions to get useful insights from business data. WHO WILL BENEFIT • Business owners • CEO's / CFO's / CTO's • Managers of all levels • Anybody with large amounts of data • Anybody who uses Microsoft Access/E...

Excel Top 10 Functions and How to Use Them - Turn Your Business Data Into Insightful Information

Image
OVERVIEW In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be. Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of Microsoft Excel formulas and functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization. WHY SHOULD YOU ATTEND You should attend this advanced Excel training if you use Microsoft Excel on a regular basis, and want to be more efficient and productive. AREAS COVERED • Relative Formulas • Absolute Formulas • IF • AND • OR • VLOOKUP • HLOOKUP • Match/Index • SUMIF • COUNTIF • AVERAGEIF • SUMIFS • COUNTIFS • NETWORKDAYS LEAR...

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...