
This course includes exercise files for each lecture. It is recommended that you download the exercise files (Excel_Practice_Files.zip) and un-zip the files somewhere convenient like your desktop. Also Included is a FREE high quality Quick Reference Guide. If you can print it out in color and have it laminated for best results.
Customize the quick access toolbar in Excel 2019 to keep favorite commands like save, undo, redo, open, and font color accessible across tabs.
Understanding Workbooks and Worksheets
Using the formula bar to make simple formulas.
Using the status bar for fast information. No formulas needed!
Understanding all the ways to navigate in Excel efficiently.
Learn to quickly access the Short Cut Menu and the Mini Tool Bar.
Learn the several ways to access Excel help.
Learn how to use Excel's autofill tool to populate cells by recognizing patterns and series. Drag the autofill handle to extend days, quarters, months, and acronyms across rows or columns.
Master copying formulas and functions into adjacent cells with autofill, using a relative reference to expand across rows and down columns.
Create a percentage change formula to measure how profits change day to day, using (current minus previous) divided by previous, with proper parentheses and percent formatting.
Create and customize an Excel table to treat data as a single entity, using headers, total row, filters, sorts, slicers, design options, and convert to range.
Move, copy, and insert data in Excel 2019 using drag, control X/V, and shift-insert; understand formula behavior on copy and how to insert or shift entire columns.
Learn to prepare and print Excel worksheets using page layout view, page break preview, and print preview, with orientation, margins, scaling, and headers and footers.
Learn how to split screens in Excel to view different parts of a worksheet simultaneously, including four-way splits and independent scrolling across panes.
Master auto outlining in Excel to group data by formulas and view quarterly totals. Collapse or expand groups by level to present concise, drillable summaries.
Link worksheets and workbooks with formulas to create cross-worksheet totals using sum. Audit dependencies and manage absolute and relative references across multiple workbooks.
Demonstrates using the if function and nested ifs in Excel to calculate shipping costs based on thresholds (4500 and 3000), with true/false outcomes and autofill.
Office 365: Complete Excel Course
This Microsoft Excel course is up to date with all the latest features and enhancements. However it works great with 2019, 2013 and 2010 versions as well.
Enroll now to get over 9 hours and 75 lessons of professional training!
Comfortable pace and easy English. Great for ESL.
Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration.
Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course.
When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel:
Create attractive and effective spreadsheets
Sort and format large sets of data
Create and format tables quickly
Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others
Create dynamic Pivot Tables and Pivot Charts
Automate your tasks with Macros
Secure workbooks and worksheets
Use conditional formatting to highlight data
Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future!