Learning Microsoft Excel 2016 Training Video

Courses For Success
Online

AU$ 189 - ($ 431.067)
+ IVA

Información importante

  • Curso
  • Online
  • Cuándo:
    A definir
Descripción

A Practical Training Course That Teaches Real World Skills In this project-based Learning Microsoft Excel 2016 video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Learning Microsoft Excel 2016 training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Learning Microsoft Excel 2016 subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Learning Microsoft Excel 2016 tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 8.5 hours to complete this course  82 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning Microsoft Excel 2016 training course, expert author Guy Vaccaro will teach you everything you need to know to begin creating and managing spreadsheets in Excel 2016. This course is designed for the absolute beginner, meaning no experience with Excel is required.

You will start by learning how to manage workbooks and worksheets, then jump into learning how to enter and edit data in cells. From there, Guy will teach you about formulas and functions, formatting, and page setup and printing. This video tutorial will also cover workbook and worksheet management, mathematical formulas, security, and charts in detail. Finally, you will learn about advanced formulas, including using an IF formula, text manipulation using...

Información importante

Requisitos: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Online

¿Qué aprendes en este curso?

Management
Excel
Security
Microsoft Excel
Printing
IT Security
Microsoft excel training
MS Excel
IT Management
Skills and Training

Programa académico

  • 01. Start Here
    • Get Started With Excel 2016
    • New Tell Me Feature
    • Excel Workbook And Worksheets
    • Customizing Color Schemes And Quick Toolbar
    • Using The Included Working Files
    • About The Author
    • 0107 How To Access Your Working Files
  • 02. Managing Workbooks And Worksheets
    • Creating And Saving New Workbooks
    • Opening Workbooks And Save As Options
    • Saving And Opening OneDrive Files
    • Navigating An Excel Workbook
    • Adding Removing And Renaming Worksheets
    • Using The 2016 Templates
  • 03. Entering And Editing Data In Cells
    • 0301 Entering And Editing Text Numbers And Dates
    • 0302 Cut Copy Paste Vs Drag And Drop
    • 0303 Special Features Of The Fill Handle
    • 0304 Managing Columns And Rows
    • 0305 Searching Within A Worksheet Workbook
  • 04. Math: The Basics
    • 0401 Normal Mathematic Operators
    • 0402 Starting With Basic Functions
    • 0403 Copying Formula
    • 0404 Displaying Formula And Functions
  • 05. Formatting
    • 0501 Cell And Range Selection
    • 0502 Modifying Typeface Size Colors
    • 0503 Number Formats Alignment And Orientation
    • 0504 Merging And Wrapping Cell Contents
    • 0505 Cell Borders
    • 0506 Applying Editing Date Formats
    • 0507 The Format Painter
    • 0508 Clearing Finding And Replacing Formatting
  • 06. Workbook And Worksheet Management
    • 0601 Worksheet Navigating Copying Moving And Tab Color
    • 0602 Side By Side Comparison Of Worksheets
    • 0603 Modifying More Than One Sheet At A Time
  • 07. Page Setup And Printing
    • 0701 Controlling Print And Screen Headings
    • 0702 Orientation Margins And Scaling
    • 0703 Headers And Footers
    • 0704 Using Page Break And Page Layout Views Effectively
    • 0705 Printing Parts Of A Worksheet
    • 0706 Spellchecking And Smart Lookup
  • 08. Mathematical Formulas
    • 0801 The Sum Function
    • 0802 Other Mathematical Functions Average Min Max
    • 0803 Various Count Functions
    • 0804 Absolute Referencing
    • 0805 Formula Across Multiple Sheets
    • 0806 3D Referencing In Action
    • 0807 The Advantages Of Named Cells And Ranges
  • 09. Security
    • 0901 Protection Of Whole Or Part Worksheets
    • 0902 Protection For The Whole Excel Workbook
  • 10. Charts In Excel
    • 1001 Using The Recommended Charts Option
    • 1002 Create A Chart Quickly Or Slowly
    • 1003 Formatting A Chart
    • 1004 Modifying The Chart Type
    • 1005 Formatting Chart Elements
    • 1006 Adding A Trendline
    • 1007 The Pie Chart
    • 1008 Sparklines Mini Charts
    • 1009 The New Forecast Sheet
    • 1010 New To 2016 Chart Types
  • 11. Graphics Objects
    • 1101 Inserting And Enhancing Images
    • 1102 Inserting Shapes And Screenshots
    • 1103 Using SmartArt Graphics
    • 1104 Formatting Graphical Objects
    • 1105 Stacking Grouping And Flowcharts
    • 1106 A Mathematical Formula With A Graphic Object
  • 12. Excel As A Database
    • 1201 Fixing Onscreen And In Print Rows And Columns
    • 1202 Sorting Data
    • 1203 Filter Data To Reduce Dataset Size
    • 1204 Removing Duplicate Entries
    • 1205 Using Subtotals In A Worksheet Of Data
    • 1206 Using Text To Columns
    • 1207 The New Get And Transform For Using Web Data
  • 13. Advanced Formula
    • 1301 Using An IF Formula
    • 1302 New IFs For Multiple Criteria
    • 1303 DATEDIF A Useful Hidden Function
    • 1304 Text Manipulation Functions
    • 1305 Use Of Text To Format Numbers
    • 1306 Date Manipulation Functions
    • 1307 Introducing SUMIF COUNTIF AVERAGEIF
    • 1308 Use Of Rank To Calculate Placings
    • 1309 Flash Fill The Magic Touch
  • 14. What's Next
    • 1401 Office Apps For Excel 2016
    • 1402 Are You Ready To Go Advanced

Información adicional

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...