
Explain what Microsoft Excel is and why we use it, compare it to other Office apps, and highlight Excel 365 features like charting, data types, formatting, and printing spreadsheets.
Learn to use Excel's accessibility checker to identify and fix readability issues before sharing, including unmerging cells, improving contrast, and applying headers for screen readers.
Master data selection in Microsoft 365 Excel by choosing single cells, contiguous ranges, and non-contiguous ranges with ctrl-click and shift-click, plus entire columns, rows, or the workbook.
Learn the order of operations in Excel formulas, from parentheses to subtraction, and why the calculation hierarchy changes results. See how incorrect parentheses affect outputs using sales data examples.
Master basic Excel functions—sum, average, count, max, and min—and use AutoSum to quickly calculate ranges across any dataset.
Master three cell reference types—relative, absolute, and mixed—and learn how copying formulas adjusts references, using $A$1 and $B$1 as absolute, and $A1 and B$2 as mixed to keep totals.
Discover how cell styles automate formatting in Excel, including good, bad, neutral, calculation, input, and heading styles. Learn to apply, modify, delete, and merge styles.
Learn to insert images in Excel, choosing between in-cell and floating images, using device, stock, or online pictures, and apply formatting while understanding the formula bar and cell resizing considerations.
Learn to insert symbols and equations in Excel via the insert tab; symbols are text, while equations are images displayed in a resizable box.
Master Excel’s spell checker to catch misspellings in data and headings. Access it via F7 (with Fn) or the Review tab, and manage suggestions, dictionary additions, and language options.
Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.
With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.
This course aligns with the CAP Body of Knowledge and should be approved for 4.75 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.