IT & Software Excel (2019) Essential Training

Currently reading:
 IT & Software Excel (2019) Essential Training

Covers web development, programming, AI, cloud computing, DevOps, and cybersecurity.

mayoufi

Member
Amateur
LV
5
Joined
Oct 22, 2023
Threads
3,280
Likes
291
Awards
11
Credits
363©
Cash
0$
c781dd39f9dc1899ca50950801d30ea3.jpg


Excel 2019 Essential Training
MP4 | Video: 720p | Duration: 2:08:31 | English | Subtitles: VTT | 408.7 MB



Start mastering Excel, the world-renowned powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more.

Topics include:
  • Navigating Excel tabs and menus
  • Entering data
  • Creating formulas and functions
  • Formatting rows, columns, cells, and data
  • Working with alignment and text wrap
  • Adjusting rows and columns
  • Finding and replacing data
  • Printing and sharing worksheets
  • Creating charts and PivotTables
  • Inserting and deleting sheets
  • Using power functions such as IF and VLOOKUP
  • Password-protecting worksheets and workbooks
  • Sorting data
  • Analyzing data with Goal Seek and Solver
  • Creating and running macros


 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Tips

Similar threads

Top Bottom