The next section of this manual will explore a few Excel features that we find handy for everyday chores. First, advanced functions (PMT, FV, VLOOKUP, and HLOOKUP) and logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE) will be covered. Then, AutoFill lists (which can save time when entering data) will be discussed. The section will conclude with information on linking, consolidating, and combining Excel data, with a final lesson on using the classic PivotTable and PivotChart wizard to pivot consolidated data.
Related Products
-
Microsoft Excel Online: Adding Pictures and Shapes
$0.00In this course you will learn how to insert pictures and shapes, and format shapes. -
Introduction to HTML and CSS Coding: Getting Started with CSS
$15.00In this course you will learn how to add the "style" tag to the HTML code, add colors to elements with CSS, and use identifiers to select elements to style. -
Microsoft Excel Online: Organizing Worksheet Data with Tables and Charts
$0.00In this course you will learn how to create and modify tables and charts. -
Online Tools for Small Business
$15.00At the end of this course, you will know about popular free online tools for small business owners, understand basic functions of Google Docs, Canva, Trello, Survey Monkey, and MailChimp, be able to select tools that meet or match your business needs, and know how to use these tools in your business.
Reviews
There are no reviews yet.