Excel Essentials I (Virtual) | Eastern Time

At OneNumber, we are focused on educating the next great wave of Tableau experts! We're here to provide classes, consulting and content to help you take your skills to the next level. As a Tableau partner, we've served thousands of Tableau users and we hope to play a role in your Tableau journey too!

OneNumber

Everything you need to know about Excel to work efficiently and effectively TODAY!

<h2>Day One</h2><p>9:00 AM - 12:00 PM Eastern</p><h2>Day Two</h2><p>9:00 AM - 12:00 PM Eastern</p><h2>Day Three</h2><p>9:00 AM - 12:00 PM Eastern</p><p><br></p><p>Excel is an incredibly powerful tool that allows us to clean and sort data, analyse, visualise, and automate our data processes. Knowing where to start your learning can be intimidating, but with Excel Essentials I, we'll cover all the areas of this powerful product to set you up to work in Excel with confidence and skill.</p><p>Topics we will explore include:</p><p><br></p><h3>Introduction to Excel</h3><ul><li>What is Excel?</li><li>What file types can I work with?</li></ul><p><br></p><h3>Worksheet Formatting</h3><ul><li>Filtering and Sorting</li><li>Freeze Rows/Columns</li><li>Field-Based Formatting</li><li>Insert, Delet, and Hide Rows/Columns</li><li>Removing Duplicates</li><li>Conditional Formatting</li><li>Duplicating Worksheets</li><li>Building Tables</li><li>Themes</li><li>Find and Replace</li></ul><h3><br></h3><h3>Shortcuts and Tips</h3><ul><li>Copy and Paste</li><li>Select All</li><li>Autofill</li><li>Adjust All Rows/Columns At Once</li><li>Copy Visible Cells Only</li><li>Cross-Workbook References</li><li>Named Ranges</li><li>Input Data From PDF</li></ul><h3><br></h3><h3>Intro to Functions and Formulas</h3><ul><li>Math and Operators</li><li>Aggregations (SUM, AVG, COUNTD)</li></ul><h3><br></h3><h3>Logic Functions</h3><ul><li>IF</li><li>Nested IF</li><li>SUMIF</li><li>COUNTIF</li><li>AVERAGEIFS</li><li>IFERROR</li></ul><h3><br></h3><h3>String Functions</h3><ul><li>Text to Columns</li><li>CONCAT</li><li>TEXTJOIN</li><li>SEARCH</li><li>LEFT</li><li>RIGHT</li><li>MID</li></ul><h3><br></h3><h3>Case Functions</h3><ul><li>UPPER</li><li>LOWER</li><li>PROPER</li><li>TRIM</li></ul><h3><br></h3><h3>Date Functions</h3><ul><li>DATE and TIME</li><li>DATEVALUE</li><li>VALUE</li><li>DATEDIF</li><li>DATEADD options</li><li>NOW</li><li>TODAY</li><li>NETWORKDAYS</li><li>Arrays</li><li>VLOOKUP</li><li>XLOOKUP</li><li>XLOOKUP vs VLOOKUP</li><li>FILTER</li></ul><p><br></p><h3>Macros</h3><ul><li>Intro to Macros</li></ul><p><br></p><h3>Structuring Data</h3><ul><li>Ideal Data Formatting</li><li>Red Flags for Formatting</li><li>Pivot Tables</li><li>UNIQUE</li><li>Transposing Rows and Columns</li><li>INDEX</li><li>MATCH</li><li>LOOKUP</li><li>Anchoring References</li><li>OFFSET &amp; Dynamic Arrays</li><li>Grouping Data</li></ul><p><br></p><h3>Building Visuals</h3><ul><li>Bar Charts</li><li>Line Graphs</li><li>Highlight Tables</li><li>Scatterplots</li><li>Pie Charts</li></ul><p><br></p><h3>Best Practices</h3><ul><li>Using Colour</li><li>Formatting Options</li><li>Merged Cells</li><li>Error-Handling</li></ul><p><br></p><h3>Collaboration and Sharing</h3><ul><li>Office 365 vs Desktop</li><li>Sharepoint/OneDrive</li></ul><p><br></p><h2>Requirements:</h2><ul><li>A Personal Computer</li><li>An External Monitor (strongly recommended)</li><li>Excel 365 or Desktop</li></ul><p><br></p><h2>Prerequisites:</h2><ul><li>There are no prerequisites to doing this class! If you have a laptop and Excel, you're welcome!</li></ul><p><br></p><h2>What will you get?</h2><p>In addition to two half-days of instruction, attendees will walk away with a 100+ page digital manual, data files to revisit the concepts on their own later, and access to class recordings for two weeks.</p><p><br></p><h2>Where will this be hosted?</h2><p>This training will be hosted virtually. Details will be sent after registration.</p><p><br></p><h2><br></h2><h2>Questions?</h2><p>oliver.linley@onenumber.biz</p><p><a href="http://onenumber.biz/" title="http://onenumber.biz/" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">onenumber.biz</a></p>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Excel Essentials I (Virtual) | Eastern Time

More events from OneNumber

Discover more events from OneNumber, from Business to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Excel Essentials I (Virtual) | Eastern Time

More events from OneNumber

Discover more events from OneNumber, from Business to other experiences you might love.

More Business events

Browse more Business events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.