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
-
Introduction to HTML and CSS Coding: Styling Text with CSS
$15.00In this course you will learn how to change the font-family of a section of text, change the font size of a section of text, use additional CSS text properties, including font-style, font-weight, line-height, and text-align, and use the CSS font style shorthand. -
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. -
Microsoft Excel Online: Getting Started
$0.00In this course you will learn how to use formulas and functions, work with data, rows, and columns, and sort and filter data. -
Introduction to HTML and CSS Coding Part 2: Responsive Web Design
$15.00In this course, you will learn how to use flexible layouts, media queries, and flexible media.
Reviews
There are no reviews yet.