Epizody
S1 E1 – Intro to Excel
31. července 201924 minSay hello to Excel. You'll cover the learning objectives and get an overview of mouse-features, backstage view, and Excel window.Dostupné k zakoupeníS1 E2 – Creating Workbooks
31. července 201925 minIn this episode, you'll learn how to create basic formulas, relative references, and order of operations. In addition to this, you'll also work with ranges.Dostupné k zakoupeníS1 E3 – Saving Workbooks
31. července 20199 minThis episode shows you how to save workbooks by using save and save as commands. You'll also find out what are file extensions and learn how to share, export, and publish files.Dostupné k zakoupeníS1 E4 – Nagivating Workbooks
31. července 201921 minIn this episode, you'll learn how to open files and find techniques to work with larger files. You'll also learn how to work with freeze pane and split screen options.Dostupné k zakoupeníS1 E5 – Page Setup & Print Options
31. července 201933 minIn this episode, you'll learn all about page setup to take the printouts of workbooks.Dostupné k zakoupeníS1 E6 – Working with Rows, Columns, and Cells
31. července 201911 minThis video takes you through the techniques of adding, deleting, and changing rows, columns, and cells.Dostupné k zakoupeníS1 E7 – Moving Data
31. července 201914 minThis episode will show you how to move data in the workbook using cut, copy, and paste techniques.Dostupné k zakoupeníS1 E8 – Formulas and Functions
31. července 201925 minIn this episode, you'll get an overview of formulas and learn how to create formulas using functions and absolute values.Dostupné k zakoupeníS1 E9 – Working with Sheets
31. července 201916 minIn this episode, you'll work with sheets to find out how to add, delete, and rename sheets and you'll also encounter dimensional formulas.Dostupné k zakoupeníS1 E10 – Formatting Worksheets
31. července 20191 h 2 minThis episode will show you how to format cells, numbers, and tables. You'll also find out about format painters, borders and shading, styles, handles, and custom lists. In addition to this, you'll also learn techniques to protect sheets.Dostupné k zakoupeníS1 E11 – Charts
31. července 201939 minIn this episode, you'll go through different types of charts and learn how to create and edit charts. You'll also learn how to create link chart titles.Dostupné k zakoupeníS1 E12 – Working with Names
31. července 201918 minIn this episode, you'll learn how to create range names, manage names, and use names in formulas.Dostupné k zakoupeníS1 E13 – Sorting and Filtering
31. července 201932 minThis episode will show you how to sort and filter data and how to remove duplicate data easily. You'll also get an overview of the advanced filters used in Excel.Dostupné k zakoupeníS1 E14 – Outlining and Subtotaling
31. července 201915 minIn this episode, you'll learn how to create and outline and subtotal.Dostupné k zakoupeníS1 E15 – Working with Views
31. července 201913 minWant to work with views? Watch this episode.Dostupné k zakoupeníS1 E16 – Linking Files
31. července 201917 minIn this episode, you'll create formulas between files, work with links, and consolidate data.Dostupné k zakoupeníS1 E17 – Advanced Formula Creation
31. července 201931 minIn this episode, you'll become familiar with If statements, VLookups, data validation, and formula auditingDostupné k zakoupeníS1 E18 – PivotTables
31. července 201914 minIn this episode, you'll learn how to create pivot tables and pivot charts.Dostupné k zakoupeníS1 E19 – Additional Excel Features
31. července 201918 minIn this episode, you'll learn Excel additional features such as Slicers, Goal Seeker, and Text to Columns.Dostupné k zakoupeníS1 E20 – Shortcuts
31. července 201912 minWant to find out Excel shortcuts that'll make your working with Excel workbooks easy? Watch this episode.Dostupné k zakoupeníS1 E21 – Closing Video
31. července 201928 sThank you for taking up this course.Dostupné k zakoupení
