Disclosure :This site contains affiliate links to products. We may receive a commission for purchases made through these links.

How to Connect with your Spirit Guides


This series is for anyone who wants to learn Microsoft Excel 2010 in a non-intimidating, soup-to-nuts manner. If you’ve never used Excel, this is your starting point. No prior experience is necessary. If you’ve used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you’ve used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be! This training includes the program-specific features that are mapped to the Microsoft Office Specialist (MOS) certification exam for the corresponding product.MOS certification validates proficiency for individuals who PASS the certification exam, and demonstrates that they possess entry-level communications skills using the corresponding Adobe software.Running Time 7.2 HoursPresenter Erin OlsenCourse OutlineChapter 1: GETTING COMFORTABLE WITH EXCEL (51 min)Introducing ExcelRecognizing Interface Features Unique to ExcelUnderstanding Workbook StructureNavigating through WorkbooksMaking Workbook Selections Chapter 2: THE BASICS OF DATA (41 min)Entering TextEntering Dates & NumbersEditing Cell EntriesCopying & Moving DataFilling a Series Chapter 3: MANAGING WORKBOOK STRUCTURE (28 min)Modifying Workbook & Worksheet StructureResizing Worksheet ElementsHiding Workbook Components Chapter 4: CREATING FORMULAS (33 min)Excel Calculations 101Entering FormulasEnforcing Absolute ReferencingControlling Calculation Options Chapter 5: THE BASICS OF FUNCTIONS (26 min)The Foundation of FunctionsUsing AutoSum & the Formulas TabUsing Function AutoComplete Chapter 6: WHAT’S IN A NAME? (43 min)Creating Named CellsDe ning NamesCreating Names from SelectionsCreating Named FormulasUsing Names as ReferencesManaging & Displaying Names Chapter 7: MAKING DATA LOOK GOOD (74 min)Applying Basic FormattingFormatting NumbersExploring the Format Cells Dialog BoxDe ning Custom FormatsCreating & Applying Cell StylesConditional FormattingApplying & Editing Conditional Formatting Rules Chapter 8 A PICTURE IS WORTH A THOUSAND WORDS (38 min)Getting In-Cell Summaries with SparklinesCreating ChartsModifying Chart DesignWorking with Chart Layout & FormatSaving & Using a Chart Template Chapter 9 THE SIMPLICITY OF TABLES (54 min)Converting Data Ranges to TablesModifying Table FormattingWorking with Table RecordsUsing Table CalculationsSorting DataCreating Custom ListsFiltering Data Chapter 10 MANAGING THE EXCEL ENVIRONMENT (20 min)Con guring Excel OptionsAdjusting the ViewControlling Excel Windows Chapter 11 PREPARING FILES FOR DISTRIBUTION (23 min)Print Area, Print Titles & Sheet OptionsRenaming Sheets & Adding Headers/FootersPrinting Worksheets

About Udemy
"Udemy is the world’s largest marketplace for teaching and learning. Over 7 million students in 200+ countries are taking courses to advance their careers and pursue their passions. Over 30,000 courses available on-demand, 24/7, via mobile or desktop." --- Udemy; More Details

More Details - Check Price

Related Products :