Microsoft excel training 20151/1/2024 ![]() ![]() Mynda: I started because I wanted to teach people with small businesses about the programs they have at their fingertips. Can we talk about your catalog of training courses and how you created it? Rick: After the Microsoft Excel MVP Summit, Jordan relayed that there was a lot of conversation about training programs. Microsoft Excel Video Course Diva and Excel MVP Mynda Treacy, who runs the successful online Excel Training program (at ) with topics ranging from Excel Dashboard to Microsoft Word and Outlook courses, joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Microsoft Excel MVP Jordan Goldmeier to discuss Excel training programs. How to Create Excel Training Courses with Mynda Treacy.* Sinet Education reserved the right to alter the course contents, offers, price, certificates etc. Manage Workbook Versions, Copy Styles within Workbooks, Copy Macros within Workbooks, Use Track Changes and Comments, Merge Workbooks, Protect Workbooks for Sharing, Connect To External Data * Each Session include:įaculty training, Lab Practice, Lab Exercises and Portal based assignments. Two-Way Lookup, Using Dropdown Lists as Lookup Values, Three-way Lookup, Getting the Last Value from a List, Partial Lookup using Wildcard Characters and VLOOKUP, VLOOKUP Returning an Error despite a Match in Lookup Value, Doing a Case Sensitive Lookup, Using VLOOKUP with Multiple Criteria, Handling Errors while Using the VLOOKUP Function ![]() Advanced Excel Function implementation Project , Inserting objects in the header and footer, Page Setup, Setting margins, Print Preview, Print, Enable back ground error checkingġ2. Apply Custom Formats and Layouts to Excel Work SheetsĪpply Custom Data Formats, Use Advanced Fill Options, Apply Advanced Conditional Formatting and Filtering, Apply Custom Styles and Templates, Use Form Controls, Prepare Workbooks for Internationalization, Use Outlines, Use Custom ViewsĬreating and Recording Macros, Assigning Macros to the work sheets, Saving Macro enabled workbook, Page setup, Setting print area, Print titles Inserting custom Header and Footer Advance Formulae and Functions in ExcelĬreate advanced formulae, Functions, Apply functions in formulae, Mathematical Functions, Financial functions, Useful Data Functions, Some Other Useful Functions, Look up data by using functions, Apply advanced date and time functions, Functions for Manipulating Text, Arraysġ0. Protecting a workbook with a password, Allow user to edit ranges, Track changes, Working with Comments, Insert Excel Objects and Charts in Word Document and Power point Presentationĩ. Protecting and Sharing the Excel Work Book Use What-If Analysis Tools, Create Scenarios, Merge Scenarios, Create Scenario Summaries, Use Data Tables, Create Advanced Charts, Basic Excel Charts, Use Area, Scatter & Stock Charts, Use Surface, Radar & Combination Charts, Create Custom Chart Templates, Work with Sparkline’sĨ. , Inserting slicer, Creating Calculated fields Understand PivotTables, Create a PivotTable Framework Using the PivotTable and PivotChart Create Pivot Chart from pivot Table. ![]() Analyse Data Using Excel PivotTables and Pivot Charts ![]() , Adding chart title, Changing layouts, Chart styles, Editing chart data range, Editing data series, Changing chartĦ. Inserting Column, Pie chart etc., Create an effective chart with Chart Tool Design, Format, and Layout options Create Effective Excel Charts to Present Data Visually Sort and filtering data, Using number filter, Text filter, Custom filtering, Removing filters from columns, Conditional formattingĥ. Logical Functions, Lookup and Reference Functions Mathematical Functions, Statistical Functions, Text Functions. Perform Calculations with Excel Functions Introduction to Excel CalculationsĬreating simple formulas, Setting up your own formula, Date and Time Functions, Financial Functionģ. Introduction and Formatting of Excel work book Introduction to Excel interface, Understanding rows and columns, Naming Cells, Working with Excel workbook and sheets, New, Open, Close, Save, Save As, Formatting Text: Font Size, Font Style, Font Color, Use the Bold, Italic, and Underline, Wrap text, Merge and Centre, Currency, Accounting and other formats, Modifying Columns, Rows & Cells 2. Sinet Microsoft Advance Excel Course Contents 1. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |