Our classes in Microsoft Excel are designed to give you the hands-on experience you need to excel with Excel. Classes are held fully online, led by a live instructor. In just 90 minutes, you’ll learn how to more effectively and efficiently use Microsoft Excel.
Date and time: Wednesday, March 29, 2023, 3:30 pm Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Work with the IF, nested IF and IF/AND logical functions, the TRIM, PROPER, CONCATENATE, TEXT, LEFT, RIGHT, and MID text functions, VLOOKUP with an approximate and exact match, separating text into …
Date and time: Wednesday, March 29, 2023, 1:30 pm Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn the fundamentals of creating and working with formulas and functions. Start by building and copying simple formulas Understand formulas operators and the order of operations Learn to use functions such …
Date and time: Wednesday, March 29, 2023, 11:00 am Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn to be more efficient when working with Excel Learn keyboard and mouse shortcuts Use the Go To Special command Learn to use Flash Fill and Auto Fill Freeze rows and …
Date and time: Tuesday, March 28, 2023, 3:30 pm Eastern Daylight Time (New York, GMT-04:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn to create several types of professional-looking charts in Excel 2013, 2016 or 365. Identify chart objects and learn to modify, add, and format charts to enhance the presentation of your …
Date and time: Tuesday, March 28, 2023, 1:30 pm Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn list and table design techniques Learn procedures to sort, filter, and validate data Use formulas in lists and tables Remove duplicate records Use the subtotal and outline features Cancellation Policy: …
Date and time: Tuesday, March 28, 2023, 11:00 am Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn about macro security, preparing to record a macro, absolute and relative macro recording. You will record various macros in class including a macro that formats and sums data, one that …
Date and time: Thursday, March 23, 2023, 3:30 pm Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn to organize your worksheets effectively by adding, deleting, moving, copying, and renaming them in workbooks. Learn how to move and copy worksheets to other workbooks Group worksheets for data entry, …
Date and time: Thursday, March 23, 2023, 1:30 pm Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn the basic formatting techniques necessary to enhance the way data displays on a worksheet and in print. Adjust column width and row height Format text, change alignment of data, format …
Date and time: Thursday, March 23, 2023, 11:00 am Eastern Standard Time (New York, GMT-05:00) Event Fee(USD$): 99.00 Duration: 1 hour 30 minutes Description: Learn to analyze and summarize worksheet data using pivot tables and pivot charts using the Recommended Pivot Table feature and the Blank Pivot Table command. In addition, you will learn to …
