Let me take you through some of the material covered in the course. Core Excel begins with the basics. We cover the Excel interface, the concept of workbooks and worksheets, and many tricks for selecting cells and entering data. We also look at Excel’s powerful find and replace tools. Then we get you started with formulas and cell references. These are the key to setting up calculations in Excel, so we make sure you are properly introduced to important concepts like absolute and relative references. Next, we enter the world of Excel formatting. We look in depth at options for formatting numbers, including dates and times, and even show you how to create your own custom formats. We also walk you though Excel’s tools for alignment, wrapping and merging, font formatting, and borders and fills. Then we get to something really fun - conditional formatting. Conditional formatting is simply an awesome way to quickly visually data. Once you get the hang of this powerful tool, you can reveal key insights in just seconds. Next is managing data. We show you how to use Excel’s powerful tools to sort and filter data, and we give you specific techniques for finding and eliminating duplicates. Charts are simply the best way to communicate information with impact. We show you how to create charts, how to add elements like titles and legends, and apply formatting to get a great presentation. We also look at how to change chart types, and how untangle things when Excel guesses wrong. The number one goal of this course is to help you learn Excel fast so you can get back to your real work. We believe people learn best by doing our videos are short and focused and include a practice worksheet. So you can immediately put your new skills to work. If you have five minutes you can learn a new skill in Excel whether you’re just getting started or have been using Excel for years. Core excel will help you build worksheets that deliver information with style clarity and impact. Thanks for joining our course. Let’s get started!
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
